Oracle Database Administration 2022 Certified Professional — Question 41

You execute the following:
EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

Answer options

• A. Automatic SQL Tuning
• B. SQL Plan Management Evolve Advisor
• C. Optimizer Statistics Advisor
• D. Automatic Optimizer Statistics Collection
• E. Automatic Segment Advisor

Correct answer: D

Explanation

The command EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE disables all automatic tasks except for the Automatic Optimizer Statistics Collection. This means that while other advisors like Automatic SQL Tuning and Optimizer Statistics Advisor are disabled, the Automatic Optimizer Statistics Collection remains operational to ensure that the database statistics are updated regularly.