Oracle Database Administration 2022 Certified Professional — Question 24

Which procedure gathers statistics that are always used in the generation of any execution plan?

Answer options

• A. DBMS_STATS.GATHER_DICTIONARY_STATS
• B. DBMS_STATS.GATHER_FIXED_OBJECTS_STATS
• C. DBMS_STATS.GATHER_DATABASE_STATS
• D. DBMS_STATS.GATHER_SYSTEM_STATS

Correct answer: C

Explanation

The correct answer is C, as DBMS_STATS.GATHER_DATABASE_STATS is specifically designed to collect comprehensive statistics for the entire database, which are crucial for generating execution plans. The other options focus on specific areas; for instance, A targets dictionary stats, B is for fixed objects, and D is for system-level statistics, which are not universally applicable to all execution plans.