1Z0-052 · Question #179
Which two statements are true regarding transactions in an Oracle database? (Choose two.)
The correct answer is A. Multiple transactions can use the same undo segment. B. A transaction is assigned an undo segment when it is started. Oracle transactions are assigned a dedicated undo segment at start time, but multiple transactions can share a single undo segment using separate transaction table slots.
Question
Which two statements are true regarding transactions in an Oracle database? (Choose two.)
Options
- AMultiple transactions can use the same undo segment.
- BA transaction is assigned an undo segment when it is started.
- CMore than one transaction cannot share the same extent in the undo tablespace.
- DThe transactions use system undo segment to store undo data if all the segments in the undo tablespace
How the community answered
(40 responses)- A88% (35)
- C5% (2)
- D8% (3)
Why each option
Oracle transactions are assigned a dedicated undo segment at start time, but multiple transactions can share a single undo segment using separate transaction table slots.
Multiple transactions can reside in the same undo segment simultaneously - Oracle uses a transaction table in the undo segment header to track each transaction's undo entries separately, allowing concurrent sharing of the same segment.
When a transaction issues its first DML statement, Oracle assigns it to an undo segment in the undo tablespace, where all before-image data for that transaction is stored until it commits or rolls back.
Multiple transactions can and do share the same undo segment and its extents - each transaction is differentiated by a separate slot in the segment's transaction table, not by exclusive extent ownership.
Oracle does not fall back to the system undo segment for user transactions when the undo tablespace is full; instead the transaction receives an ORA-30036 error indicating the undo tablespace cannot extend.
Concept tested: Oracle undo segment assignment and transaction sharing
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/transactions.html
Topics
Community Discussion
No community discussion yet for this question.