Oracle Database Administration I — Question 44

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

Answer options

• A. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
• B. UNDO_RETENTION specifies how long all types of UNDO are retained.
• C. Unexpired UNDO is always retained.
• D. Active UNDO is always retained.
• E. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Correct answer: C, E

Explanation

The correct answers are C and E because unexpired UNDO is indeed always retained, and UNDO_RETENTION specifies the timeframe for which Oracle tries to keep unexpired UNDO. Options A and B are incorrect as they imply retention of expired UNDO and all types of UNDO, which is not the case.