Oracle Database Administration II — Question 60

Which three are true about the SQL Tuning Advisor? (Choose three.)

Answer options

• A. It checks each query being analyzed for stale statistics.
• B. It checks each query being analyzed for missing statistics.
• C. It only recommends syntactic changes to SQL statements.
• D. It can recommend semantic changes to SQL statements.
• E. It considers all SQL statements being analyzed by the advisor task as a group.
• F. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Correct answer: A, B, D

Explanation

The SQL Tuning Advisor checks for both stale and missing statistics, making options A and B correct. Option D is also correct as it can suggest semantic changes to SQL statements. Options C, E, and F are incorrect because the advisor does more than just syntactic changes, does not group statements during analysis, and does not build SQL profiles to prevent regressions.