Oracle Database 11g: Administration I — Question 10

Which two are true about server-generated alerts? (Choose two.)

Answer options

• A. Stateful alerts are preserved across instance restarts.
• B. They are automatically written to alert.log.
• C. By default, an email is sent by the database instance for each server-generated alert.
• D. Stateless alerts can be found in DBA_OUTSTANDING_ALERTS.
• E. By default, a server-generated alert is raised for each tablespace that has 85 % or more of its space used.

Correct answer: B, E

Explanation

Option B is correct because server-generated alerts are indeed automatically recorded in alert.log. Option E is also correct as a default alert is triggered when a tablespace exceeds 85% usage. Options A, C, and D are incorrect because stateful alerts do not persist through instance restarts, emails are not sent by default for every alert, and stateless alerts are not specifically found in DBA_OUTSTANDING_ALERTS.