Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?
A.
SQL Access Advisor recommendations are automatically implemented.
B.
Individual SQL Access Advisor recommendations can be scheduled for implementation.
C.
All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D.
SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
E.
None of the above.
Explanation:
http://www.oracle-base.com/articles/11g/SQLAccessAdvisor_11gR1.php:
The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and materialized views which might improve system performance. Oracle 11g has made two significant changes to the SQL Access Advisor:
1. The advisor now includes advice on partitioning schemes that may improve performance.
2. The original workload manipulation has been deprecated and replaced by SQL tuning sets.