Upgrade Oracle DBA 11g to Oracle Database 12c — Question 20

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, C, is valid because the SQL Tuning Advisor can suggest changes to the SQL statements to improve their execution. Options A and B pertain to gathering statistics and creating SQL profiles, which are not automatically applied by the advisor. Option D involves the creation of materialized views, which is also not a direct result of the SQL Tuning Advisor's recommendations.