Oracle
1Z0-034 · Question #76
UNDO__RETENTION is set to 1000 and retention is not guaranteed. You configure the database with a fixed size undo tablespace. Which is true about undo retention in this configuration?
The correct answer is C. Inactive undo is retained for at least 1000 seconds if free undo space is available. See the full explanation below for the reasoning.
Question
UNDO__RETENTION is set to 1000 and retention is not guaranteed. You configure the database with a fixed size undo tablespace. Which is true about undo retention in this configuration?
Options
- AUndo expires after 1000 seconds and is deleted.
- BInactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the
- 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 SYSAUX
How the community answered
(41 responses)- A2% (1)
- B7% (3)
- C76% (31)
- D15% (6)
Community Discussion
No community discussion yet for this question.