单项选择题
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.
相关考题
-
多项选择题
WhichcommandsareusedforRMANdatabaserecovery？（）
A. restore
B. repair
C. copy
D. recover
E. replace -
单项选择题
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above -
多项选择题
What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)
A. It cannot generate recommendations that support multiple workload queries.
B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
C. It can recommend partitioning only on tables that have at least 10,000 rows.
D. It can recommend only B-tree indexes and not bitmap or function-based indexes
