Exam 1z0-082 topic 1 question 5 discussion

E is correct answer.

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. The correct answer is: E

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.

A is correct answer Oracle 12C Version 12c has implemented the TEMP_UNDO_ENABLED parameter that allows modifying the default behavior that was present in previous versions

E

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.

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 correct answer.

As many user commented, the correct answer is E, this is a particular case.

undo of temp table would be stored in temp tablespace if temp undo is enabled

E is correct answer.

E. If there is no 'temporary undo enabled', then it will be stored in the undo tablespace.

E is correct

Enabling temporary undo allows temporary undo segments to be created in temp tablespaces for the corresponding temporary tables. This can improve performance a lot

...with temporary undo enabled.

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.

E is correct