A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table. Which of the following describes where the undo is stored?

The correct answer is D. In the temporary tablespace. In Oracle databases, when 'temporary undo' is enabled (a feature introduced in Oracle 12c), undo data generated by operations on temporary tables is stored in the temporary tablespace rather than the undo tablespace. This improves performance and reduces undo overhead. Normally,

Database Management and Maintenance

Question

Options

AIn the system global area
BIn the undo tablespace
CIn the SYSAUX tablespace
DIn the temporary tablespace

How the community answered

(53 responses)

A
2% (1)
B
6% (3)
C
2% (1)
D
91% (48)

Explanation

In Oracle databases, when 'temporary undo' is enabled (a feature introduced in Oracle 12c), undo data generated by operations on temporary tables is stored in the temporary tablespace rather than the undo tablespace. This improves performance and reduces undo overhead. Normally, without temporary undo enabled, undo for all transactions (including those on temporary tables) goes to the undo tablespace (B). The system global area (A) is an in-memory structure, not persistent storage for undo. The SYSAUX tablespace (C) stores auxiliary database metadata and is not used for undo data.

Topics

#Undo Management#Temporary Tablespaces#Database Storage#DML Operations

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice