Oracle Database Administration I — Question 58

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

Answer options

• A. in the undo tablespace
• B. in the SYSAUX tablespace
• C. in the SGA
• D. in the PGA
• E. in the temporary tablespace

Correct answer: E

Explanation

The correct answer is E because UNDO for temporary tables is stored in the temporary tablespace. Options A, B, C, and D are incorrect as they pertain to storage locations for persistent undo or memory structures, which do not apply to temporary tables.