OCP CBT Question 612

Please solve the following question.

A DBA has defined a maintenance window named `WEEKEND_MAINT_WINDOW` to occur every Saturday and Sunday from 00:00 to 06:00. A critical batch job, `FULL_BACKUP_JOB`, must only run during this window. How can the DBA ensure `FULL_BACKUP_JOB` respects this window?

Window Definition Example`sqlDBMS_SCHEDULER.CREATE_WINDOW (window_name => 'WEEKEND_MAINT_WINDOW',resource_plan => 'DEFAULT_PLAN',start_date => TRUNC(SYSDATE) + 1, -- Next dayrepeat_interval => 'FREQ=WEEKLY; BYDAY=SAT,SUN; BYHOUR=0; BYMINUTE=0; BYSECOND=0',duration => INTERVAL '6' HOUR,enabled => TRUE,comments => 'Weekend maintenance window.');`

Assign FULL_BACKUP_JOB to a job class that is associated with WEEKEND_MAINT_WINDOW.

Explicitly set FULL_BACKUP_JOB's window_name attribute to WEEKEND_MAINT_WINDOW.

Define FULL_BACKUP_JOB with a start_date and repeat_interval that exactly match WEEKEND_MAINT_WINDOW's schedule.

Create a separate EVENT_SCHEDULE that fires when WEEKEND_MAINT_WINDOW opens and then starts FULL_BACKUP_JOB.