Multiple choice technology databases

What are the states of a rollback segment ?

  1. ONLINE

  2. OFFLINE

  3. PARTLY AVAILABLE

  4. NEEDS RECOVERY

  5. INVALID
Reveal answer Fill a bubble to check yourself
A,B,C,D,E Correct answer
Explanation

Oracle rollback segments have five possible states: ONLINE (available for transactions), OFFLINE (not available), PARTLY AVAILABLE (contains active transactions), NEEDS RECOVERY (requires recovery before use), and INVALID (corrupted or unusable). These states track the segment's availability and status for transaction management.

AI explanation

Oracle rollback segments can be in one of five documented states, all listed here as correct: ONLINE (available for transactions to use), OFFLINE (taken out of use, not available), PARTLY AVAILABLE (some transactions still reference it during a state transition, e.g., mid-offline), NEEDS RECOVERY (the segment is corrupted/inconsistent and requires recovery before further use), and INVALID (the segment no longer exists, e.g., was dropped, but stale references remain, such as in DBA_ROLLBACK_SEGS). These exact five states are documented in Oracle's data dictionary views (DBA_ROLLBACK_SEGS.STATUS), so marking all five as valid states is accurate — this is a factual/enumerable Oracle DBA question rather than one with a single 'best' answer.

Keep practicing — related questions