The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?
A.
statistics recommendations
B.
SQL Profile recommendations
C.
Index-related recommendations
D.
restructuring of SQL recommendations
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDIBFGA
During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.