1Z0-052 · Question #245
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?
The correct answer is D. uses undo data to roll back the transaction. When a user session terminates abnormally mid-transaction, Oracle uses undo data to roll back the uncommitted changes and restore database consistency.
Question
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?
Options
- Auses undo data for roll forward
- Buses Flashback Log for recovery
- Cuses online redo logs to roll back
- Duses undo data to roll back the transaction
- Euses Recovery Manager (RMAN) to roll back
- Fuses the System Monitor (SMON) background process to perform instance recovery
How the community answered
(39 responses)- B5% (2)
- D92% (36)
- F3% (1)
Why each option
When a user session terminates abnormally mid-transaction, Oracle uses undo data to roll back the uncommitted changes and restore database consistency.
Undo data is used to roll back (undo) uncommitted changes, not to roll forward - roll forward operations use redo log data to reapply committed changes.
Flashback Logs support the Flashback Database feature to rewind an entire database to a prior point in time, not to recover individual aborted user transactions.
Online redo logs contain redo vectors used to roll forward committed changes during instance recovery, not to roll back changes from individual terminated sessions.
Oracle records 'before image' data in undo segments for every DML change. When a session ends abnormally, the PMON background process detects the dead process and uses this undo data to reverse all uncommitted changes, returning affected rows to their pre-transaction state. This automatic rollback ensures read consistency and data integrity without manual intervention.
RMAN is a backup and restore tool for recovering database files from physical failures, not an automatic mechanism for rolling back uncommitted user transactions.
SMON performs instance recovery after a full database crash by applying redo and rolling back uncommitted transactions from the undo, but for a single dead user process that role belongs to PMON.
Concept tested: Oracle transaction rollback using undo segments
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/transactions.html
Topics
Community Discussion
No community discussion yet for this question.