Oracle Database Administration II — Question 58

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

Answer options

• A. A target database's persistent RMAN configuration settings are always stored in the target's control file
• B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• C. Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.
• D. The RMAN SHOW ALL command displays only settings with nondefault values.
• E. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
• G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Correct answer: A, C, F

Explanation

The correct answer includes A, C, and F because they accurately describe how RMAN configurations work: A explains the storage of settings, C describes the automatic deletion of obsolete backups in the FRA, and F mentions that the V$RMAN_CONFIGURATION view displays only modified settings. Options B, D, E, and G are incorrect because they misrepresent the behavior of RMAN regarding backup deletion, the SHOW ALL command, synchronization with the RMAN catalog, and the necessity of choosing between retention policies.