Oracle
1Z0-417 · Question #13
When reviewing a customer's database configuration, you find that is set as TRUE. What does the Optimizer do? OPTIMIZER_USE_SQL_PLAN_BASELINES
The correct answer is B. develops plans and adds them to baselines as verified. See the full explanation below for the reasoning.
Question
When reviewing a customer's database configuration, you find that is set as TRUE. What does the Optimizer do? OPTIMIZER_USE_SQL_PLAN_BASELINES
Options
- Acompares plans that it develops with accepted plans in baselines
- Bdevelops plans and adds them to baselines as verified
- Cdoesn't develop an execution plan, but uses an accepted plan from baselines
- Ddoesn't develop an execution plan, but uses enabled plans in the baseline
How the community answered
(34 responses)- A6% (2)
- B74% (25)
- C6% (2)
- D15% (5)
Community Discussion
No community discussion yet for this question.