OCP CBT Question 609
Please solve the following question.
You have created an Oracle Scheduler job with the following properties: `start_date => TIMESTAMP '2023-10-26 23:00:00'`, `repeat_interval => 'FREQ=DAILY; BYHOUR=0,8,16'`. The current system timestamp is `2023-10-26 22:30:00`. When will this job execute for the first time?
sqlDBMS_SCHEDULER.CREATE_JOB (job_name => 'MULTI_HOUR_JOB',job_type => 'PLSQL_BLOCK',job_action => 'BEGIN DBMS_OUTPUT.PUT_LINE(''Job executed''); END;',start_date => TIMESTAMP '2023-10-26 23:00:00',repeat_interval => 'FREQ=DAILY; BYHOUR=0,8,16',enabled => TRUE,comments => 'Job to run at midnight, 8 AM, and 4 PM daily, starting at 11 PM on Oct 26.');Current system timestamp: 2023-10-26 22:30:00