A. The Automatic Memory Manager (AMM)B. The SQL Tuning ……

多项选择题Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)

A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor

多项选择题What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)

A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh

单项选择题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