Multiple choice technology databases

One user session was terminated abnormally in the middle of a transaction What does oracle database do to recover it?

  1. uses undo data for roll forward

  2. uses flashback log for recovery

  3. uses online redo logs to roll back

  4. uses undo data to roll back the transaction

  5. uses recovery managers (RMAN) to roll back.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When a user session terminates abnormally, Oracle automatically uses undo data from the undo tablespace to roll back the uncommitted transaction. This maintains data consistency by reversing all changes made by the incomplete transaction. Redo logs are for roll forward during recovery, not roll back. Flashback logs and RMAN are not involved in automatic transaction rollback.

Keep practicing — related questions