Oracle Database Administration II — Question 7

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

Answer options

• A. All metrics are instance related.
• B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
• C. A space usage management alert is automatically cleared after the underlying problem is resolved.
• D. They are generated by SMON when a tablespace is 97% full.
• E. Metrics are statistical counts for a specific unit.
• F. STATISTICS_LEVEL must be set to ALL to generate alerts.

Correct answer: B, C, E

Explanation

Option B is correct because cleared stateful alerts can indeed be checked in DBA_ALERT_HISTORY. Option C is correct as space usage management alerts are designed to clear when the issue is addressed. Option E is valid since metrics do represent statistical counts. Options A and D are incorrect because not all metrics are instance-related and SMON does not generate alerts solely based on tablespace capacity reaching 97%. Option F is also wrong; alerts can be generated without STATISTICS_LEVEL being set to ALL.