Oracle
1Z0-062 · Question #274
1Z0-062 Question #274: Real Exam Question with Answer & Explanation
The correct answer is A: Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM. https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm
Question
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?
Options
- AUndo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM
- BInactive undo is retained for at least 1000 seconds if free undo space is available.
- CInactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo
- DUndo becomes expired obsolete after 1000 seconds.
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm
Community Discussion
No community discussion yet for this question.