Oracle Database 12c: Advanced Administration — Question 32

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

Answer options

• A. statistics recommendations
• B. SQL profile recommendations
• C. SQL statement restructure recommendations
• D. creation of materialized views to improve query performance

Correct answer: C

Explanation

The correct answer is C because the SQL Tuning Advisor specifically provides recommendations for restructuring SQL statements to enhance performance. Options A and B refer to statistics and SQL profiles, which are not automatically implemented by the SQL Tuning Advisor, and option D pertains to materialized views, which are also not directly related to the SQL Tuning Advisor's automatic actions.