In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a
value?
A.
When the data file of the undo tablespace is autoextensible
B.
When there are more than one undo tablespace available in the database
C.
When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.
When the undo tablespace is autoextensible and retention guarantee is not enabled
Explanation:
C. For fixed- size undo tablespaces, the system automatically tunes for the maximum possible undo retention period, based on undo tablespace size and usage history, and ignores UNDO_RETENTION unless retention guarantee is enabled