Oracle
1Z0-062 · Question #278
1Z0-062 Question #278: Real Exam Question with Answer & Explanation
The correct answer is C: when the undo tablespace is of a fixed size and retention guarantee is not enabled. https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)
Question
When is the UNDO_RETENTION parameter value ignored by a transaction?
Options
- Awhen there are multiple undo tablespaces available in a database
- Bwhen the data file of the undo tablespace is autoextensible
- Cwhen the undo tablespace is of a fixed size and retention guarantee is not enabled
- Dwhen Flashback Database is enabled
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)
Community Discussion
No community discussion yet for this question.