Which two statements are true?

Examine the parameters for a database instance:

Which two statements are true?

Examine the parameters for a database instance:

Which two statements are true?

A.
Undo records for temporary tables are stored in a temporary tablespace.

B.
Undo records for temporary tables are stored in the undo tablespace and logged in the redo.

C.
Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those
sessions where temporary undo is enabled.

D.
No redo is generated for the undo records belonging to temporary tables.

E.
No redo and undo records are generated for temporary tables.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Richard

Richard

The correct answers should be A and D. Operations on temporary tables do not generate redo.