Which two are benefits of configuring temporary undo?

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

Question:

Which two are benefits of configuring temporary undo?

Options:

Performance improves because less redo is written to the redo log.

Temporary undo reduces the amount of undo stored in undo tablespaces.

Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.

Performance improves because no redo and undo are generated for the temporary tables.

Correct Answer

The Correct Answer for this Question is

Performance improves because less redo is written to the redo log.
Temporary undo reduces the amount of undo stored in undo tablespaces.

You may also like...

Leave a Reply

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