Oracle Database Administration II — Question 102

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

Answer options

• A. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
• B. Space might be reclaimed proactively before space pressure occurs.
• C. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
• D. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)
• E. Space is always reclaimed proactively before space pressure occurs.

Correct answer: C, D

Explanation

The correct answers are C and D because space for Flashback logs can be reclaimed automatically when the retention period is reduced (C), and it is also reclaimed when there is space pressure in the Fast Recovery Area (D). Options A and E are incorrect because they imply automatic reclamation without the need for space pressure, which is not always the case.