Oracle Database 11g: Administration I — Question 21

Which command is used to display files that no longer conform to the backup retention policy?

Answer options

• A. CROSSCHECK BACKUP
• B. SHOW DATAFILE BACKUP COPIES
• C. LIST EXPIRED BACKUP
• D. REPORT OBSOLETE

Correct answer: B

Explanation

The correct answer, SHOW DATAFILE BACKUP COPIES, is specifically designed to list backup copies of datafiles, including those that do not meet retention policy requirements. The other options either check the status of backups (CROSSCHECK BACKUP), list expired backups (LIST EXPIRED BACKUP), or report on obsolete backups (REPORT OBSOLETE), but they do not directly address the display of files that no longer conform to the retention policy.