Oracle Database Administration 2022 Certified Professional — Question 34

What are the least elevated values of STATISTICS_LEVEL and CONTROL_MANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

Answer options

• A. STATISTICS_LEVEL=ALL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING
• B. STATISTICS_LEVEL=BASIC and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC
• C. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING
• D. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC

Correct answer: C

Explanation

The correct answer, C, indicates that STATISTICS_LEVEL must be set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS to DIAGOSTIC+TUNING for Monitoring of Database Operations. Option A requires higher settings than necessary, while B uses BASIC which does not support the needed features, and D lacks the necessary access for full monitoring capabilities.