Oracle Exam 1Z0-067 Topic 10 Question 43 Discussion

Actual exam question for Oracle's 1Z0-067 exam

Question #: 43
Topic #: 10

In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.

Which statement is true about undo retention?

AUndo becomes expired obsolete after 1000 seconds.

BInactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.

CInactive undo is retained for at least 1000 seconds if free undo space is available.

DUndo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.

Show Suggested Answer

Suggested Answer: B

by Caprice at May 07, 2022, 07:57 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!