Oracle Database 12c: Installation and Administration — Question 235

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

Answer options

• A. recommending creation of indexes based on SQL workload
• B. recommending restructuring of SQL statements that have suboptimal plans
• C. checking schema objects for missing and state statistics
• D. recommending optimization of materialized views
• E. generating SQL profiles

Correct answer: B, C, E

Explanation

The correct answers, B, C, and E, represent functions that the SQL Tuning Advisor specifically supports, including advising on SQL statement optimization and generating SQL profiles. Options A and D are incorrect because they do not fall under the direct capabilities of the SQL Tuning Advisor.