Oracle Database 12c: RAC Administration — Question 42

Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)

Answer options

• A. setting the PARALLEL_DEGREE_POLICY to LIMITED
• B. setting the PARALLEL_FORGE_LOCAL to TRUE
• C. setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS
• D. using a database service to limit the number of instances that participate in parallel execution
• E. creating a UNIFORM service for a policy-managed RAC database

Correct answer: A, D

Explanation

The correct answer includes A and D because setting the PARALLEL_DEGREE_POLICY to LIMITED directly restricts the degree of parallelism, and using a database service can control the participating instances. Options B and C do not effectively limit instances for parallel execution, while E pertains to creating a service rather than limiting execution instances.