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

ALTER DATABASE BACKUP CONTROLFILE TO TRACE generates a trace file in the user_dump_dest directory containing SQL commands to recreate the control file. This is useful for recovery or documentation purposes. Option A is incorrect because it's not a direct text copy of the control file - it's SQL to recreate it. Option B is wrong because it's not a binary copy. Option C is incorrect because it recreates the control file, not the entire database.

Keep practicing — related questions