Oracle Database 12c: Installation and Administration — Question 190

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

Answer options

• 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.

Correct answer: A, B

Explanation

The correct answers are A and B because configuring temporary undo leads to less redo being logged, which improves performance, and it also decreases the amount of undo data stored in the undo tablespaces. Options C and D are incorrect; DML operations on temporary tables do utilize the buffer cache, and while temporary tables do not generate redo and undo in the same way as permanent tables, they still generate some logging which is not fully eliminated.