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 ALTER DATABASE BACKUP CONTROL FILE TO 'filename' command creates a binary copy of the control file at the specified location. This is different from the TO TRACE option which generates a SQL script. The binary backup preserves all control file contents in their native format.

Keep practicing — related questions