Oracle
1Z0-063 · Question #34
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
(31 responses)- A3% (1)
- B10% (3)
- C74% (23)
- D13% (4)
Community Discussion
No community discussion yet for this question.