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 questionsOracle 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.
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.
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."
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
- Question 7Choose two. Which two are true about the automatic execution of operating system scripts …
