Oracle Database 12c: Installation and Administration — Question 146

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

Answer options

• A. Archived redo log files that have multiple copies in a different archive location
• B. user-managed backups of data files and control files
• C. RMAN backups that are obsolete
• D. flashback logs

Correct answer: C, D

Explanation

The correct answers are C and D because the FRA is designed to manage RMAN backups and flashback logs, and it will automatically delete obsolete RMAN backups first when space is needed. Options A and B are incorrect because archived redo logs with multiple copies and user-managed backups are not automatically removed by the system's retention policy.