408.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.
Answer: B
参考:
http://docs.oracle.com/cd/E11882_01/server.112/e10822/tdppt_sqlopt.htm#TDPPT192
哪项陈述最准确地描述了执行一个SQL 访问顾问建议?
B、单个SQL 访问顾问建议可以安排实施。
Option A is incorrect because SQL Access Advisor recommendations are not automatically implemented. Option C is incorrect because the DBA can choose which recommendations to schedule and implement from the task result set. D is incorrect because the recommendations are not automatically scheduled for implementation.
选项A不正确,因为SQL Access Advisor的建议不会自动实现。选项C是不正确的,因为DBA可以选择哪些建议从任务的结果集去安排并执行。D是不正确的,因为不是自动调度的实施建议。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2123886/
,如需转载,请注明出处,否则将追究法律责任。