1Z0-083 practice question 1 of 35

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

Full set: 286 questions
Answer options
A: Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained. Correct answer
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. Correct answer
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. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.; C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
Explanation

Oracle Database 19c includes a feature for proactive deletion of flashback logs. Flashback logs older than the DBFLASHBACKRETENTIONTARGET are proactively deleted even before the Fast Recovery Area (FRA) experiences space pressure. This helps prevent space-related issues. Additionally, if an administrator reduces the value of DBFLASHBACKRETENTIONTARGET, the database will automatically identify and purge any existing flashback logs that are now older than this new, shorter retention period, making them eligible for deletion to reclaim space.

Why Incorrect

B. This describes older behavior. Starting in 12cR2, deletion is proactive and occurs before space pressure, not only after.
D. Flashback log deletion is an automatic, internal database process. It does not rely on administrator-written event triggers for its core functionality.
E. Logs are only purged if the retention target is lowered and existing logs exceed the new target. Increasing the target value does not cause a purge.

References

1. Oracle Database Backup and Recovery User's Guide, 19c. Chapter 16, "Using Flashback Database and Restore Points". Section: "Configuring the Fast Recovery Area for Flashback Logs". It states, "If you lower DBFLASHBACKRETENTIONTARGET, then any flashback logs that have been retained for a time longer than the new setting are eligible for deletion."

2. Oracle Database Backup and Recovery User's Guide, 19c. Chapter 16, "Using Flashback Database and Restore Points". Section: "Proactive Deletion of Flashback Logs". It states, "...flashback logs that are older than the flashback retention period are deleted proactively to save space in the fast recovery area (FRA). This is done even before the FRA is under space pressure."

Scroll to Top