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 writes a text file to the database's trace directory containing the SQL statement (CREATE CONTROLFILE) needed to recreate the control file. It does not produce a copy of the database schema, nor does it create a binary or exact text copy of the control file itself.

Keep practicing — related questions