Multiple choice technology databases

What are the min.extents allocated to a rollback extent ?

  1. One

  2. Two

  3. Three

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In traditional Oracle rollback segment architecture (pre-undo tablespace), a rollback segment must allocate a minimum of TWO extents before it can be used for transaction rollback information. This is a fundamental requirement for rollback segment initialization. The first extent contains the segment header, and at least one additional extent is needed for transaction data.

Keep practicing — related questions