OCP-1Z0-053-V13.02-262题

最新推荐文章于 2016-11-24 16:11:02 发布

Riveore

最新推荐文章于 2016-11-24 16:11:02 发布

阅读量5.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： OCP-1Z0-053

本文链接：https://blog.csdn.net/rlhua/article/details/19037831

OCP-1Z0-053 专栏收录该内容

796 篇文章

订阅专栏

本文探讨了在Oracle11g中SQL访问顾问生成的推荐事项，包括分区建议、统计收集建议、索引创建建议和材料化视图建议。通过优化材料化视图、分区和索引，可以显著提高复杂、数据密集型查询的数据检索性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

262.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

Answer: ACDE

答案解析：

官方参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF008

8.1 Overview of SQL Access Advisor

Materialized views, partitions, and indexes are essential when tuning a database to achieve optimum performance for complex, data-intensive queries. SQL Access Advisor helps you achieve your performance goals by recommending the proper set of materialized views, materialized view logs, partitions, and indexes for a given workload. Understanding and using these structures is essential when optimizing SQL as they can result in significant performance improvements in data retrieval. The advantages, however, do not come without a cost. Creation and maintenance of these objects can be time consuming, and space requirements can be significant. In particular, partitioning of an unpartitioned base table is a complex operation that must be planned carefully.