Oracle
1Z0-117 · Question #35
1Z0-117 Question #35: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #35. The question stem and answer options stay visible for context.
Question
You ran a high load SQL statement that used an index through the SQL Tuning Advisor and accepted its recommendation for SQL profile creation. Subsequently you noticed that there has been a 2% growth in number of rows in the tables used by the SQL statement and database statistics have also been refreshed. How does this impact the created SQL profile?
Options
- AIt becomes invalid and no longer used the optimizer.
- BIt remains valid and ensures that the optimizer always use the execution plan that was created before
- CIt remains and allows the optimizer to pick a different plan required.
- DIt becomes invalid and a new SQL profile is created for the statement by the auto tuning task.
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.