Oracle Database: Program with PL/SQL — Question 71

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

Answer options

• A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
• B. To execute chunks in parallel, users must have CREATE JOB system privilege.
• C. No specific system privileges are required to create or run parallel execution tasks.
• D. Only DBAs can create or run parallel execution tasks.
• E. Users with CREATE TASK privilege can create or run parallel execution tasks.

Correct answer: B

Explanation

The correct answer is B, as users indeed require the CREATE JOB system privilege to execute tasks in parallel using the DBMS_PARALLEL_EXECUTE package. Option A is incorrect because while SYS owns the package, it can be accessed by other users with the appropriate privileges. Options C and D are incorrect as they misstate the privileges needed for creating or running tasks, and option E is irrelevant to the specific requirement of executing tasks in parallel.