Oracle
1Z0-068 · Question #126
Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)
The correct answer is A. setting the PARALLEL_DEGREE_POLICY to LIMITED D. using a database service to limit the number of instances that participate in parallel execution. See the full explanation below for the reasoning.
Question
Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)
Options
- Asetting the PARALLEL_DEGREE_POLICY to LIMITED
- Bsetting the PARALLEL_FORGE_LOCAL to TRUE
- Csetting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS
- Dusing a database service to limit the number of instances that participate in parallel execution
- Ecreating a UNIFORM service for a policy-managed RAC database
How the community answered
(41 responses)- A73% (30)
- B5% (2)
- C5% (2)
- E17% (7)
Community Discussion
No community discussion yet for this question.