多项选择题

In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）

A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations

点击查看答案

上一题目录下一题

相关考题

单项选择题

In which cases is reference partitioning effective in enhancing performance?（）

A. It is effective only in partition pruning.
B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

多项选择题

Which two activities are NOT supported by the Data Recovery Advisor?（）

A. Diagnose and repair a data file corruption offline.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair failures on a standby database.
D. Recover from failures in the Real Application Cluster (RAC) environment.

单项选择题

Which setting enables the baselines by default in Oracle Database 11g?（）

A. setting the STATISTICS_LEVEL parameter to TYPICAL
B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C. enabling Automated Maintenance Task using Oracle Enterprise Manager
D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE