Question 30:
Which three are true about Optimizer Statistics Advisor? (Choose three.)
Answer options:
A. It can be run only manually. B. It is part of the DBMS_ADVISOR package. C. It can recommend changes to improve the statistics gathering process. D. It always analyzes all schemas in the database. E. It runs automatically every night by default. F. It is part of the DBMS_STATS package.