Q38 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?
- (A). in the undo tablespace
- (B). in the SYSAUX tablespace
- (C). in the SGA
- (D). in the PGA
- (E). in the temporary tablespace
Answer: E
http://www.dba-oracle.com/t_temp_undo_enabled.htm