Oracle Database 12c: Advanced Administration — Question 183

You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?

Answer options

• A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
• B. It creates a file that contains the SQL statement, which is required to re-create the control file.
• C. It updates the alert log file with the location and contents of the control file.
• D. It creates a binary backup of the control file.

Correct answer: B

Explanation

The correct answer is B because the command creates a trace file containing the SQL statements needed to recreate the control file, which is essential for recovery processes. Options A, C, and D are incorrect as they do not accurately describe the function of the command; it does not create a binary backup, update the alert log, or store the file in a specified location.