Oracle
1Z0-067 · Question #101
When is the UNDO_RETENTION parameter value ignored by a transaction?
The correct answer is C. when the undo tablespace is of a fixed size and retention guarantee is not enabled. See the full explanation below for the reasoning.
Question
When is the UNDO_RETENTION parameter value ignored by a transaction?
Options
- Awhen the data file of the undo tablespace is autoextensible
- Bwhen there are multiple undotablespaces available in a database
- Cwhen the undo tablespace is of a fixed size and retention guarantee is not enabled
- Dwhen Flashback Database is enabled
How the community answered
(47 responses)- A4% (2)
- B2% (1)
- C85% (40)
- D9% (4)
Community Discussion
No community discussion yet for this question.