QUESTION 16
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.
The SQL Access Advisor was introduced in Oracle 10g to make suggestions about additional indexes and
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.
。
。
。
。
。
。
。
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.
10g中主要关于增加索引和物化视图
11g中有2个重要改变: 1. 分区对象 2.10g的功能被弃用,被优化集代替
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation: