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 andmaterialized 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.