Multiple choice technology databases

You issue this statement ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statment generate ?

  1. A text copy of the control file.

  2. A binary copy of the control file.

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

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

The statement ALTER DATABASE BACKUP CONTROLFILE TO TRACE generates a trace file in the user dump destination containing SQL commands to recreate the control file. This is useful for recovery when you've lost the control file but have the database files. The trace file contains CREATE CONTROLFILE syntax (option D), not the entire database creation (option C). It's text-based (not binary, option B) and contains SQL statements (not just a copy, option A).

Keep practicing — related questions