Oracle Database 12c: Installation and Administration — Question 118

Which three statements are true about the SQL Tuning Advisor? (Choose three.)

Answer options

• A. It can get input from the Automatic Workload Repository (AWR).
• B. It can run while a maintenance window is open.
• C. It can recommend creation of SQL plan baselines.
• D. It can rebuild indexes.
• E. It prevents regression of SQL statement performance.
• F. It can get input from SQL Scripts in flat files.

Correct answer: A, B, E

Explanation

The SQL Tuning Advisor can utilize data from the Automatic Workload Repository (AWR) and can operate during a maintenance window, which makes statements A and B correct. Additionally, it helps to prevent regression in SQL statement performance, making E accurate. Options C, D, and F are incorrect as the SQL Tuning Advisor does not create SQL plan baselines, rebuild indexes, or directly process SQL scripts from flat files.