Oracle Database Administration II — Question 167

Which three are true about backing up the control file? (Choose three.)

Answer options

• A. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used
• B. It can get backed up automatically as a binary copy
• C. It can be backed up manually as a binary copy
• D. It can be backed up manually as a trace file containing SQL statements for control file re-creation
• E. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re-creation when a database backup occurs
• F. It cannot be backed up manually as a binary copy

Correct answer: B, C, D

Explanation

Options B, C, and D are correct because the control file can indeed be backed up either automatically or manually in binary format and as a trace file containing SQL statements. Options A and E are incorrect as they describe scenarios where the control file is backed up automatically, which is not true in the context given, and option F is incorrect because it states that manual binary backups are not possible.