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?

The correct answer is A. in the undo tablespace. https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11478 (16.7)

Administer Undo Data

Question

Options

Ain the undo tablespace
Bin the SYSAUX tablespace
Cin the SGA
Din the PGA
Ein the temporary tablespace

How the community answered

(49 responses)

A
84% (41)
B
10% (5)
C
4% (2)
E
2% (1)

Explanation

https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11478 (16.7)

Topics

#temporary undo#undo tablespace#temporary tables#TEMP_UNDO_ENABLED

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice