ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

165 / 190

Question 165:

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.