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 ALTER DATABASE BACKUP CONTROLFILE TO TRACE command generates a trace file in the user_dump_dest directory containing SQL statements (CREATE CONTROLFILE) that can be used to recreate the control file. Option A is incorrect - it's not a direct copy. Option B describes binary control file backups. Option C is wrong - it recreates the control file, not the entire database. This is useful for recovery or control file reconstruction.

Keep practicing — related questions