You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo?

The correct answer is B. Temporary undo reduces the amount of undo stored in undo tablespaces. D. Performance improves because no redo and undo are generated for the temporary tables. https://oracle-base.com/articles/12c/temporary-undo-12cr1

Managing Undo Data

Question

Options

APerformance improves because less redo is writtento the redo log.
BTemporary undo reduces the amount of undo stored in undo tablespaces.
CPerformance improves because data manipulation language (DML) operations performed on
DPerformance improves because no redo and undo are generated for the temporary tables.

How the community answered

(42 responses)

A
5% (2)
B
93% (39)
C
2% (1)

Explanation

https://oracle-base.com/articles/12c/temporary-undo-12cr1

Topics

#temporary undo#temporary tables#redo reduction#undo tablespace

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice