Prev Question
Next Question

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not
guaranteed. Which statement regarding retention of undo data is correct?

Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the
TEMPORARY tablespace to provide read consistency.

Undo data will be stored permanently after 1,000 seconds.

Undo data becomes obsolete after 1,000 seconds.

Undo data gets refreshed after every 1,000 seconds.

Committed undo data would be retained for 1,000 seconds if free undo space is available.

Prev Question
Next Question

Leave a Reply

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