You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?
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.
A is wrong. “TO TRACE” creates a file with the SQL, not a copy of the control file. B is correct.
Thanks MJ, is correct your opinion.
Correct answer is B
B
B
B
B
B
B
http://otndnld.oracle.co.jp/document/products/oracle11g/111/doc_dvd/server.111/E05760-03/control.htm#239259
B