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:
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.
A,C,D,E are all correct:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF008
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.