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.
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)- A95% (40)
- B2% (1)
- C2% (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.
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.
An undo tablespace is not restricted to a single datafile; additional datafiles can be added to it as undo space requirements grow.
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
Community Discussion
No community discussion yet for this question.