OCP CBT Question 613

Please solve the following question.

A database administrator needs to create multiple jobs that perform the exact same PL/SQL operation but with different execution schedules. For example, 'Daily_Cleanup_Job', 'Weekly_Cleanup_Job', and 'Monthly_Cleanup_Job' all call the same `cleanup_procedure`. What Oracle Scheduler component should the DBA use to define the common PL/SQL operation to promote reusability and simplify management?

Example Procedure`sqlCREATE OR REPLACE PROCEDURE cleanup_procedure ISBEGIN DELETE FROM old_records WHERE record_date < SYSDATE - 365; COMMIT;END;`

A single job with a complex repeat_interval covering all schedules.

An Oracle Scheduler Program.

An Oracle Scheduler Chain with a single step.

Multiple jobs, each containing the cleanup_procedure call directly in its job_action.

Example ProceduresqlCREATE OR REPLACE PROCEDURE cleanup_procedure ISBEGIN DELETE FROM old_records WHERE record_date < SYSDATE - 365; COMMIT;END;

Example Procedure`sqlCREATE OR REPLACE PROCEDURE cleanup_procedure ISBEGIN DELETE FROM old_records WHERE record_date < SYSDATE - 365; COMMIT;END;`