Oracle
1Z0-117 · Question #34
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 tha
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.
Managing SQL Performance with SQL Plan Management
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.
Topics
#SQL plan baseline#DBMS_SPM#plan evolution#accepted plan