Which three statements are true about space usage alerts? (Choose three.) 

Answer options:

A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
C. Database alerts can provide warnings about low space availability at both tablespace and segment levels.
D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

ADE

References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120