View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view.
After 30 minutes, you executed the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;
REASON METRIC_VALUE
—————————— ———————- Tablespace [TEST] is [28 perce 28.125 nt] full
What could be the two reasons for the elimination of the other rows in the output? (Choose two.)
A.
The threshold alerts are transferred to DBA_ALERT_HISTORY.
B.
The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C.
The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
D.
The threshold alert conditions are cleared.