OCP 1Z0 053 232

来源：互联网发布：wifi信号源定位软件编辑：程序博客网时间：2024/06/05 05:10

232.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
Answer: BDE

http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#CHDEEBAI

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

0 0