Multiple choice technology databases

What advantage would you get if you increase the length of the time during which the undo information would be restored in the database

  1. roll back of large transaction

  2. roll forward to redo a transaction

  3. data concurrency for large updates

  4. read consistency for long running transactions.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Increasing undo retention allows Oracle to keep older undo data longer, which is essential for maintaining read consistency for long-running queries and transactions. This prevents 'snapshot too old' errors. It does not directly help with rolling back large transactions (that depends on undo space), roll forward (redo logs handle that), or concurrency (that's about locking, not retention).

Keep practicing — related questions