nerdexam
Oracle

1Z0-052 · Question #175

Which three operations require undo data? (Choose three.)

The correct answer is B. Flashing back a transaction C. Recovering a failed transaction D. Running a read-consistent query. Undo data is required for flashback operations, recovering failed transactions, and providing read-consistent query results, but is not needed when committing a transaction or changing tablespace status.

Managing Undo Data

Question

Which three operations require undo data? (Choose three.)

Options

  • ACommitting a transaction
  • BFlashing back a transaction
  • CRecovering a failed transaction
  • DRunning a read-consistent query
  • EChanging a tablespace status from READ ONLY to READ WRITE

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    90% (27)
  • E
    7% (2)

Why each option

Undo data is required for flashback operations, recovering failed transactions, and providing read-consistent query results, but is not needed when committing a transaction or changing tablespace status.

ACommitting a transaction

Committing a transaction makes changes permanent by writing redo data to the redo log - it does not require undo data because there is nothing to roll back after a commit.

BFlashing back a transactionCorrect

Flashing back a transaction uses undo data to reconstruct prior versions of modified rows, allowing Oracle to reverse committed changes to a previous point in time. Without undo data retained in the undo tablespace, the Flashback Transaction feature cannot operate.

CRecovering a failed transactionCorrect

Recovering a failed transaction requires undo data to roll back any uncommitted changes that were made before the failure occurred, restoring the affected data blocks to their pre-transaction state.

DRunning a read-consistent queryCorrect

Read-consistent queries rely on undo data to build a consistent snapshot of the data as it existed at the query's start SCN, allowing readers to see a stable view even when other sessions are concurrently modifying the same rows.

EChanging a tablespace status from READ ONLY to READ WRITE

Changing a tablespace status from READ ONLY to READ WRITE is a DDL operation that updates the control file and data file headers and does not involve undoing any row-level data changes.

Concept tested: Oracle undo data usage scenarios for transactions and queries

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/transactions.html

Topics

#undo data usage#flashback transaction#read consistency#failed transaction recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice