Oracle Database Administration II — Question 148

You execute this command successfully:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

What is the outcome?

Answer options

• A. It creates a file that contains SQL statements to re-create the control file
• B. It creates a file that contains RMAN scripts to create a duplicate database
• C. It creates a copy of the control file in the fast recovery area (FRA)
• D. It creates a binary backup of the control file
• E. It updates the alert log with the location and contents of the control file

Correct answer: A

Explanation

The correct answer is A because the command produces a trace file with SQL statements necessary for reconstructing the control file. Options B and C are incorrect since they refer to RMAN scripts and copies in the FRA, which are not outcomes of this command. Option D is wrong because the command does not create a binary backup, and option E is also incorrect as it does not update the alert log.