Hello,
Now examine this statement:
ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
Tablespace altered.
Which two are true about undo retention in this configuration? (Choose two.)
A. Unexpired undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.
B. Active undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.
C. Undo data is written to flashback logs after 900 seconds.
D. Expired undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.
E. Undo data expires after 900 minutes.
F. Unexpired undo is retained for 900 seconds, only if free undo space is available.
I have choose B and E as Unexpired undo is never overwritten when RETENTION=GUARANTEE