Oracle
1Z0-117 · Question #130
1Z0-117 Question #130: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #130. The question stem and answer options stay visible for context.
Question
You notice some performance degradation for a high-load SQL statement in your database. After investigations, you run the SQL Tuning Advisor, which recommends a SQL Profile. You accept the profile recommendation resulting in a new, tuned execution plan for the statement. Your database uses SQL plan management and a SQL plan baseline exists for this SQL statement. Which statement is true?
Options
- AThe database adds the tuned plan to the SQL plan baseline as a nonfixed plan.
- BThe database adds the tuned plan to the SQL plan baseline as a fixed plan.
- CThe optimizer uses the new tuned plan only when a reproducible fixed plan is present.
- DThe created SQL profile will continuously adapt to all changes made to the database, the object, and
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.