Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not
enabled?
A.
It is the time period after which the undo data becomes obsolete.
B.
It is the time period after which the committed undo data would be transferred to a temporary
tablespace.
C.
It is the minimum time period up to which the committed undo data would be retained if free
undo space is available.
D.
It is the time period after which the undo data is transferred to the Flash Recovery Area to
provide read consistency.
When the retention guarantee is not provided, undo data will not enforce the retention time for UNDO_RETENTION , and auto undo tablespace growth, at sufficient free space, then it will keep the data for the amount of time set in UNDO_RETENTION ==> time period up to which the committed undo data to be retained
If the undo table space is fixed, UNDO_RETENTION may be ignored, undo data may be overwritten.
Answer C is correct
UNDO DATA retained
No guarantee => lowest guarantee – MINIMUM TIME