Which three statements are true about space usage alerts?
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.
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120
A is wrong – For both warning and critical thresholds, when remaining space falls below an amount in KB, an alert is issued.
D is correct – alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
E is correct – When you create a new locally managed tablespace, it is assigned the default threshold values defined for the database.
ADE is correct