Oracle
1Z0-050 · Question #55
1Z0-050 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
Question
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?
Options
- ASet OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
- BCapture the plans from the previous version using STS and then load them into the stored outline.
- CCapture the plans from the previous version using STS and then load them into SQL Management
- DSet OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being
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.