Oracle
1Z0-050 · Question #68
1Z0-050 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)
Options
- AThe optimizer adds the new plan to the plan history.
- BThe optimizer selects the new plan for the execution of the SQL statement.
- CThe optimizer adds the new plan to the SQL plan baseline as an accepted plan.
- DThe optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
- EThe optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.