Oracle
1Z0-062 · Question #274
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?
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
Managing Undo Data
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.
How the community answered
(53 responses)- A85% (45)
- B2% (1)
- C8% (4)
- D6% (3)
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm
Topics
#UNDO tablespace#Undo retention#RETENTION NOGUARANTEE#Fixed-size undo
Community Discussion
No community discussion yet for this question.