Which of the following advisors is run in every maintenance window by the auto-task system?
A.
The Memory Advisor
B.
The SQL Tuning Advisor
C.
The Undo Advisor
D.
The SQL Access Advisor
Explanation:
About Automated Maintenance Tasks (link)Oracle Database has three predefined automated maintenance tasks:
Automatic Optimizer Statistics Collection
Automatic Segment Advisor
Automatic SQL Tuning Advisor
By default, all three automated maintenance tasks are configured to run in all maintenance windows.