CompTIA DataSys+ (DS0-001) — Question 4

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?

Answer options

• A. In the system global area
• B. In the undo tablespace
• C. In the SYSAUX tablespace
• D. In the temporary tablespace

Correct answer: B

Explanation

The correct answer is B, as the undo data generated during transactions is stored in the undo tablespace. Other options are incorrect because the system global area is for managing memory allocation, the SYSAUX tablespace is used for auxiliary database components, and the temporary tablespace is meant for temporary storage of data rather than undo information.