OCP CBT Question 611

Please solve the following question.

You are designing an automated data warehousing ETL process. This process involves four distinct steps: data extraction, data transformation, data loading, and finally, index rebuilding. Each step is implemented as a separate stored procedure. The extraction step must complete successfully before transformation begins. Transformation must complete before loading, and loading must complete before index rebuilding. If any step fails, the entire process should stop. What is the most suitable Oracle Scheduler component for defining and managing this sequence of tasks?

A single PLSQL_BLOCK job containing all four procedure calls sequentially.

Four individual jobs, each with a start_date dependent on the previous job's estimated completion time.

An Oracle Scheduler Chain.

A set of individual jobs managed by an external operating system script.