OCP CBT Question 606

Please solve the following question.

Examine the following Oracle Scheduler command executed by a DBA. Which statement accurately describes the outcome of this command?

sqlDBMS_SCHEDULER.CREATE_JOB (job_name => 'HOURLY_DATA_PURGE_JOB',job_type => 'PLSQL_BLOCK',job_action => 'BEGIN DELETE FROM AUDIT_TRAIL WHERE AUDIT_DATE < SYSDATE - 30; COMMIT; END;',start_date => SYSTIMESTAMP,repeat_interval => 'FREQ=HOURLY; INTERVAL=1',enabled => TRUE,comments => 'Purges audit trail data older than 30 days every hour.');

The job will execute immediately and then every hour thereafter.

The job will be created but will not run until explicitly enabled using DBMS_SCHEDULER.ENABLE.

The job will execute 30 days after its creation and then hourly.

The job will purge data older than 30 days only on the hour mark, not immediately upon creation.