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

• 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: B,C,E

Reference: Oracle Database 12c: Administration Wrokshop

A. False. Tablespace Space Usage metris is database related

B. True. Stateful alerts appear in DBA_OUTSTANDING_ALERTS and, when cleared, go to DBA_ALERT_HISTORY

C. True. Most alerts (such as "Out of space") are clared automatically when the cause of the problem disappears.

D. False. They're generated by MMON

E. True

F. False. This parameter is not required to generate alerts