Oracle
1Z0-054 · Question #191
1Z0-054 Question #191: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #191. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the plans in the SQL plan baseline.You observe that the last two SELECT statements (outlined in red and blue) are identical, but have two different plans. Also, the second plan (in blue) is not being used by the optimizer. Which two steps do you perform to ensure that the optimizer uses the second plan (in blue) if the plan is more efficient? (Choose two.)
Exhibit
Options
- AMark the second plan (in blue) as fixed.
- BUse SQL Tuning Advisor to tune the plan.
- CUse SQL Access Advisor to tune the plan.
- DUse the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function to evolve the plan.
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.