Oracle Database 12c: Performance Management and Tuning — Question 18

In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level.
Which two statements are true? (Choose two.)

Answer options

• A. Alerts are recorded in both Oracle Enterprise Manager Cloud Control and DBA_OUTSTANDING_ALERTS only when the critical threshold is exceeded.
• B. Alert settings for the warning and critical levels must be disabled before taking the USERS tablespace offline.
• C. Alerts that are triggered are automatically recorded in DBA_ALERT_HISTORY after they are cleared.
• D. Alerts are triggered when the space usage reaches the warning level, again when it reaches the critical level, and yet again when the space usage falls below

Correct answer: A, B

Explanation

Option A is correct because alerts are indeed noted only when the critical threshold is crossed. Option B is also correct as disabling alerts is necessary before taking the tablespace offline. Options C and D are incorrect because alerts do not automatically record in DBA_ALERT_HISTORY or trigger multiple times for falling below thresholds.