Oracle
1Z0-054 · Question #190
1Z0-054 Question #190: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #190. The question stem and answer options stay visible for context.
Question
A user session executes a query and the plan for the query is shown in the Exhibit as Plan-1. After verifying with the SQL Access advisor, an index is created on the table in the JOB_ID column and the query is executed again. A new plan is generated against the second query shown in the Exhibit as Plan-2. When explaining the plan for the second query, you observe that the optimizer uses the first plan instead of the second. The following parameters are set for the user session: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=TRUE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE SQLTUNE_CATEGORY=DEFAULT Why does the optimizer not use the second plan?
Exhibit
Options
- Abecause the second plan is not verified
- Bbecause the second plan is not part of the SQL plan baseline
- Cbecause the SQLTUNE_CATEGORY parameter is set to DEFAULT
- Dbecause the explain plan option in the user session does not allow the new plan because
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.