Oracle Database Administration II — Question 138

Which two are true about Optimizer Statistics? (Choose two.)

Answer options

• A. They can be gathered by the DBMS_STATS package.
• B. They are gathered by the SQL Tuning Advisor.
• C. They provide real-time data about schema objects.
• D. They are ignored by Optimizer if they are stale.
• E. By default, they are automatically gathered by a maintenance job.

Correct answer: A, E

Explanation

The correct answers are A and E because Optimizer Statistics can indeed be gathered using the DBMS_STATS package, and by default, they are automatically collected by a maintenance job. Options B and C are incorrect as the SQL Tuning Advisor does not gather statistics, and statistics do not provide real-time data. Option D is misleading; while stale statistics may be less effective, they are not entirely ignored.