Oracle Database: Program with PL/SQL — Question 43

Your company decided to update its employees contact information as a one-time event.
With thousands of employees records to be updated, the project manager hoped to achieve substantial performance gains using the
DBMS_PARALLEL_EXECUTE package and identified these four actions to be executed.
1) dbms_parallel_execute.create_task
2) GRANT system privilege CREATE JOB to the user executing this task
3) dbms_parallel_execute.run_task
4) dbms_parallel_execute.create_chunks_by_rowid
Select the correct order of actions to implement the parallel execution of PL/SQL blocks.

Answer options

• A. 2, 1, 3 and 4
• B. 1, 2, 4 and 3
• C. 2, 1, 4 and 3
• D. 1, 2, 3 and 4
• E. 2, 4, 1 and 3

Correct answer: E

Explanation

The correct order is E because you need to first grant the necessary privileges, then create the chunks for processing, followed by creating the task, and finally running the task. Options A, B, C, and D do not follow the logical flow required for parallel execution with the DBMS_PARALLEL_EXECUTE package.