37 In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply

最新推荐文章于 2024-07-24 23:48:47 发布

原创最新推荐文章于 2024-07-24 23:48:47 发布 · 545 阅读

0 ·

CC 4.0 BY-SA版权

OCP 053 专栏收录该内容

86 篇文章

订阅专栏

在Oracle11g中，SQL访问顾问生成了包括分区建议、统计收集建议、索引创建建议和材料化视图建议在内的多种优化建议。此工具通过分析工作负载和其他指定信息来提供关于材料化视图、B树、位图和函数基索引、以及表和索引分区的调优建议。

37
In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations

E. materialized view log recommendations

Correct Answer: ACDE
Section: (none)
Explanation
Explanation/Reference:
Explanation:
In Oracle 11g, the SQL Access Advisor can generate partitioning recommendations, index creation
recommendations, materialized view recommendations, and materialized view log recommendations. The
SQL Access Advisor is a tuning tool that provides advice regarding the tuning of materialized views,
indexes (Btree, bitmap, and function-based), and materialized view logs, as well as advice on table and
index partitioning.
The SQL Access Advisor provides recommendations by analyzing a known workload and other specified
information. SQL Access Advisor does not generate statistics collection recommendations. This task is
performed by the SQL Tuning Advisor.