Oracle
1Z0-117 · Question #89
1Z0-117 Question #89: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #89. The question stem and answer options stay visible for context.
Question
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for a statement that has stale statistics. Automatic optimizer statistics is enabled for the database. What does the optimizer do in this situation?
Options
- AUpdates the existing SQL profiles for which the statistics are stale.
- BMakes the statistics information available to GATHER_DATABASE_STATS_JOB_PROC
- CStarts the statistics collection process by running GATHER_STATS_JOB
- DWrites a warning message in the alert log file
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.