nerdexam
Oracle

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.

Managing Undo Data

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)
  • B
    5% (2)
  • D
    92% (36)
  • F
    3% (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.

Auses undo data for roll forward

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.

Buses Flashback Log for recovery

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.

Cuses online redo logs to roll back

Online redo logs contain redo vectors used to roll forward committed changes during instance recovery, not to roll back changes from individual terminated sessions.

Duses undo data to roll back the transactionCorrect

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.

Euses Recovery Manager (RMAN) to roll back

RMAN is a backup and restore tool for recovering database files from physical failures, not an automatic mechanism for rolling back uncommitted user transactions.

Fuses the System Monitor (SMON) background process to perform instance recovery

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

#undo data#transaction rollback#abnormal session termination#PMON

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice