QuestionQ4

VerifiedDatabase Fundamentals

A database is set up to use undo management with temporary undo enabled. An UPDATE is executed on the table.

Which option describes where the undo is stored?

Explanation

With TEMP_UNDO_ENABLED set to TRUE, Oracle separates undo for temporary objects from undo for persistent objects. An UPDATE of a persistent table stores its undo in the undo tablespace; only undo for temporary objects is stored in a temporary tablespace.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!