A. The SGA Tuning Advisor
B. The SQL Access Advisor
C. The SQL Tuning Advisor
D. The Memory Advisor
答案:(B)
解析:
答案解析:
The SQL Access Advisor is primarily responsible for making schema modification recommendations.
It can recommend that you create access structures such as indexes and materialized views to optimize SQL queries.
It can also recommend that you partition tables,indexes,or materialized views to improve query performance.