You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?

Answer: D

Explanation: The SQL Access Advisor analyzes all SQL running during a given time period and recommends indexes and materialized views to improve the overall performance of the database. A is incorrect because there is no such advisor as the Automatic Memory Manager. B is incorrect because the SQL Tuning Advisor looks only at a single SQL statement and provides recommendations. C is incorrect because the Segment Advisor recommends segment shrink when table and index segments are heavily fragmented.