Oracle Database Administration II — Question 114

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

Answer options

• A. It is a set of recommendations by the optimizer to create new indexes.
• B. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
• C. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
• D. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
• E. It is a set of recommendations by the optimizer to change the access methods used.

Correct answer: B

Explanation

The correct answer, B, accurately reflects that the SQL Tuning Advisor provides recommendations to modify SQL statements to enhance execution plans. Options A, C, D, and E describe other aspects of optimization, such as creating indexes or improving join orders, but do not specifically address the restructuring of SQL statements for better execution outcomes.