Oracle Database Administration II — Question 178

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Answer options

• A. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
• B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
• C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
• D. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
• E. Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Correct answer: A, C

Explanation

Option A is correct because flashback logs are indeed purged automatically if the retention target is set lower than the time they have been retained. Option C is also correct as it states that flashback logs are deleted proactively before space pressure occurs. Options B and D are incorrect because they either misstate the conditions for deletion or the role of administrators in triggering deletions. Option E is incorrect since changing the retention target does not automatically purge flashback logs.