nerdexam
Oracle

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.

Managing Undo Data

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)
  • A
    88% (35)
  • C
    5% (2)
  • D
    8% (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.

AMultiple transactions can use the same undo segment.Correct

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.

BA transaction is assigned an undo segment when it is started.Correct

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.

CMore than one transaction cannot share the same extent in the undo tablespace.

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.

DThe transactions use system undo segment to store undo data if all the segments in the undo tablespace

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

#undo segments#transaction undo assignment#undo tablespace sharing#concurrent transactions

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice