Multiple choice

Examine the following statement:

ALTER DATABASE BACKUP CONTROL FILE TO 'control01.bkp';

What does the statement generate?

  1. A file containing a SQL statement which will re-create the database.

  2. A text copy to the control file.

  3. A binary copy of the control file.

  4. A file containing a SQL statement which will re-create the control file.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The BACKUP CONTROL FILE TO trace creates a binary copy of the control file at the specified location. This is different from the TO TRACE option which creates a text file with SQL commands. The binary backup preserves the exact state of the control file including data file info, checkpoint details, and recovery metadata - essential for disaster recovery scenarios.

Keep practicing — related questions