Oracle Database 12c: Installation and Administration — Question 151

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: B

Explanation

The correct answer is B, as SQL profile recommendations can be automatically implemented to optimize SQL execution. Options A, C, and D refer to recommendations that require manual implementation or do not fall under the automatic actions taken by the SQL Tuning Advisor.