Oracle Database Administration II — Question 16

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.

Correct answer: C, E, F

Explanation

The correct answers are C, E, and F because the Optimizer Statistics Advisor does indeed suggest changes to improve the statistics gathering process, runs automatically every night by default, and is part of the DBMS_STATS package. Options A, B, and D are incorrect as the advisor can run automatically, is not exclusively part of the DBMS_ADVISOR package, and does not analyze all schemas by default.