Oracle Database Advanced PL SQL 12c 1z0 148
© examsiri.com
Question : 37 of 54
Marks:
+1,
-0
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.
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.
Go to Question: