OCP-1Z0-053-200题-161题-262

QUESTION 161

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

同262题：http://blog.csdn.net/rlhua/article/details/19037831

Explanation/Reference:

Section: Managing Database Performance & Tuning

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.