动态RAM与静态RAM相比，下列哪一项不是它的优点（)A．耗电少B．接口电路简单C．高集成度D．制造成本

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.

A. Access pathanalysis is not performed for SQL statements.

B. SQL structure analysis is not performed for SQL statements.

C. SQL Profile recommendations are not generated for SQL statements.

D. Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

A. partitioning recommendations

B. statistics collection recommendations

C. index creation recommendations

D. materialized view recommendations

E. materialized view log recommendations

A. partitioning recommendations

B. statistics collection recommendations

C. index creation recommendations

D. materialized view recommendations

E. materialized view log recommendations

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

A. SQL Repair Advisor

B. SQL Optimizer

C. SQL Access Advisor

D. SQL Tuning Advisor

recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

A. statistics recommendations

B. SQL Profile recommendations

C. Index-related recommendations

D. restructuring of SQL recommendations

stance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

A. statistics recommendations

B. SQL profile recommendations

C. index-related recommendations

D. restructuring of SQL recommendations

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

A. The SGA Tuning Advisor

B. The SQL Access Advisor

C. The SQL Tuning Advisor

D. The Memory Advisor