You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary
undo?
A.
Performance improves because less redo is written to the redo log.
B.
Temporary undo reduces the amount of undo stored in undo tablespaces.
C.
Performance improves because data manipulation language (DML) operations performed on temporary
tables do not use the buffer cache.
D.
Performance improves because no redo and undo are generated for the temporary tables.
Explanation:
https://oracle-base.com/articles/12c/temporary-undo-12cr1
The correct answers should be A and B. The temporary undo feature provides the following benefits:
– Reduces the amount of undo data stored in the undo tablespaces.
– Reduces the amount of redos generated. Operations on temporary tables do not generate redo.