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.
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)- A3% (1)
- B90% (27)
- E7% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.