which recommendations does the SQL Access Advisor generate?

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

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.