Which statement regarding retention of undo data is correct?

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?

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?

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

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

C.
Undo data becomes obsolete after 1,000 seconds.

D.
Undo data gets refreshed after every 1,000 seconds.

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



Leave a Reply 0

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