Oracle Database Administration 2022 Certified Professional — Question 2

Which three types of statistics are captured by Statspack with snap level 6? (Choose three.)

Answer options

• A. Parent and child latches
• B. Parent and child latches
• C. Optimizer execution plans
• D. Plan usage data
• E. Enqueue statistics
• F. Segment-level statistics

Correct answer: C, D, E

Explanation

The correct options, C (Optimizer execution plans), D (Plan usage data), and E (Enqueue statistics), are specific types of statistics that Statspack captures at snap level 6. Options A and B are duplicates and do not represent unique statistics, while F (Segment-level statistics) is not included in the statistics collected at this snap level.