What areas can SQL Access Advisor give advice on?
A.
Partitioning advice, index advice, and materialized views advice
B.
Index advice and compression advice
C.
Index advice and data masking advice
D.
Partitioning advice and compression advice
Explanation:
The SQL Access Advisor was introduced in Oracle 10g to make suggestions about
additional indexes and materialized views which might improve system performance. Oracle 11g
has made two significant changes to the SQL Access Advisor:
The advisor now includes advice on partitioning schemes that may improve performance.
The original workload manipulation has been deprecated and replaced by SQL tuning sets.
Reference:
http://www.oracle-base.com/articles/11g/SQLAccessAdvisor_11gR1.php
The option A is correct. La version 11g incluye particionamiento.