nerdexam
Oracle

1Z0-052 · Question #115

Which of these is true about undo tablespace?

The correct answer is A. Undo tablespace is a temporary tablespace. Undo tablespace stores transaction undo data that is transient by nature, retained only as long as needed for rollback and read consistency.

Managing Undo Data

Question

Which of these is true about undo tablespace?

Options

  • AUndo tablespace is a temporary tablespace
  • BUndo tablespace has only one datafile
  • CUndotablespace has a datafile which is reused in cyclic manner

How the community answered

(42 responses)
  • A
    95% (40)
  • B
    2% (1)
  • C
    2% (1)

Why each option

Undo tablespace stores transaction undo data that is transient by nature, retained only as long as needed for rollback and read consistency.

AUndo tablespace is a temporary tablespaceCorrect

Undo tablespace holds undo records that exist only for the duration of active transactions and the configured undo retention period - the data is not permanently committed user data, making it temporary in terms of its data lifecycle. Oracle internally classifies it as a distinct UNDO tablespace type, but it shares the essential characteristic of storing non-permanent, transient data rather than permanent application data.

BUndo tablespace has only one datafile

An undo tablespace is not restricted to a single datafile; additional datafiles can be added to it as undo space requirements grow.

CUndotablespace has a datafile which is reused in cyclic manner

While undo extents are reused in a wrap-around fashion as old undo data expires, this describes internal space management behavior rather than a defining characteristic that classifies the tablespace type.

Concept tested: Oracle undo tablespace characteristics and data lifecycle

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-undo.html

Topics

#undo tablespace#datafile reuse#cyclic reuse#undo management

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice