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 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?
When a database is configured to use automatic undo management with temporary undo enabled, the undo for temporary tables is stored in the temporary tablespace. This is to separate the handling of undo for temporary tables from that of persistent tables, which remains in the undo tablespace. The temporary undo records are thus managed within the temporary tablespace.
E is correct answer.
Good hint, i think you have Right ! Oracle database 12c Release 1 (12.1) introduced the concept of temporary undo, allowing the undo segments for global temporary tables to be stored in the temporary tablespace. This allows global temporary tables to be used in physical standby databases and read-only databases, as well as removing the need to create redo.
I would agree http://www.dba-oracle.com/t_temp_undo_enabled.htm
Funny how the reference they put up supports answer E and not answer A: 16.7 Managing Temporary Undo By default, undo records for temporary tables are stored in the undo tablespace and are logged in the redo, which is the same way undo is managed for persistent tables. However, you can use the TEMP_UNDO_ENABLED initialization parameter to separate undo for temporary tables from undo for persistent tables. When this parameter is set to TRUE, the undo for temporary tables is called temporary undo. 16.7.1 About Managing Temporary Undo Temporary undo records are stored in the database's temporary tablespaces and thus are not logged in the redo log. When temporary undo is enabled, some of the segments used by the temporary tablespaces store the temporary undo, and these segments are called temporary undo segments. Reference: https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11479 The correct answer is: E
I would agree
Who's marking the right answers? They're almost all wrong! A is wrong, E is the right one. The same reference supports the E answer
E is correct
E is correct
E-->Temporary undo records are stored in the database's temporary tablespaces and thus are not logged in the redo log. When temporary undo is enabled, some of the segments used by the temporary tablespaces store the temporary undo, and these segments are called temporary undo segments.
...with temporary undo enabled.
Enabling temporary undo allows temporary undo segments to be created in temp tablespaces for the corresponding temporary tables. This can improve performance a lot
E is correct
E. If there is no 'temporary undo enabled', then it will be stored in the undo tablespace.
E is correct answer.
undo of temp table would be stored in temp tablespace if temp undo is enabled
As many user commented, the correct answer is E, this is a particular case.
E is correct answer.
By default, undo records for temporary tables are stored in the undo tablespace . This means that If the temporary undo is set to false, then undo records generated by temporary tables are logged to undo tablespace. However, when temporary undo is enabled, the undo for temporary tables is called temporary undo which are then logged in to a separate tablespace called temporary tablespace.
E is the correct answer. The reference attached here states that. 16.7 Managing Temporary Undo By default, undo records for temporary tables are stored in the undo tablespace and are logged in the redo, which is the same way undo is managed for persistent tables. However, you can use the TEMP_UNDO_ENABLED initialization parameter to separate undo for temporary tables from undo for persistent tables. When this parameter is set to TRUE, the undo for temporary tables is called temporary undo. 16.7.1 About Managing Temporary Undo Temporary undo records are stored in the database's temporary tablespaces and thus are not logged in the redo log. When temporary undo is enabled, some of the segments used by the temporary tablespaces store the temporary undo, and these segments are called temporary undo segments.
https://docs.oracle.com/en/database/oracle/oracle-database/23/admin/managing-undo.html