Oracle Database 12c: Installation and Administration — Question 49

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.

Correct answer: A, D, E

Explanation

The correct statements A, D, and E reflect the specific conditions under which space usage alerts operate. Option A is correct as alerts are triggered when critical thresholds are breached, while D indicates that alerts do not apply to offline or read-only tablespaces. Option E is accurate because newly created locally managed tablespaces inherit the default threshold values. Options B and C are incorrect as they do not specifically relate to the criteria for issuing alerts.