Oracle
1Z0-117 · Question #34
1Z0-117 Question #34: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Question
View the exhibit and examine the findings provided by the SQL Tuning Advisor for SELECT Statement. A SWL plan baseline already exists for the execution plan. What two methods can you use to ensure that an alternate plan becomes an accepted plan?
Exhibit
Options
- AUse the DBMS_SPM.ALTER_SQL_PLAN_BASELINE function.
- BUse the DBMS_SQLTUNE.CREATE_SQL_PLAN_BASELINE function.
- CUse the DBMS_SQLTUNE.CREATE_SQL_PLAN_BASELINE function and run the DBMS_STATS
- DUse the DBMS_SPM.LOAD_PLANS_FROM_SQLSET function.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 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.