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

最新推荐文章于 2026-02-01 13:18:42 发布

原创最新推荐文章于 2026-02-01 13:18:42 发布 · 8.3k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

OCP11g解析

OCP-1Z0-053

本文提供SQL查询优化的关键建议，包括创建高效索引、合理分区表格与视图，以及优化视图以提高查询速度与刷新效率。利用SQLAccessAdvisor在Enterprise Manager或API中推荐策略，提升数据库性能。

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#PFGRF95276

SQL Access Advisor index recommendations include bitmap, function-based, and B-tree indexes. A bitmap index offers a reduced response time for many types of ad hoc queries and reduced storage requirements compared to other indexing techniques. Bitmap indexes are most commonly used in a data warehouse to index unique or near-unique keys. SQL Access Advisor materialized view recommendations include fast refreshable and full refreshable MVs, for either general rewrite or exact text match rewrite.

SQL Access Advisor, using the TUNE_MVIEW procedure, also r ecommends how to optimize materialized views so that they can be fast refreshable and take advantage of general query rewrite.

Using SQL Access Advisor in Enterprise Manager or API, you can do the following:

Recommend materialized views and indexes based on collected, user-supplied, or hypothetical workload information.
Recommend partitioning of tables, indexes, and materialized views.
Mark, update, and remove recommendations.