Which statement is true about the command?

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

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.



Leave a Reply 10

Your email address will not be published. Required fields are marked *


MJ

MJ

A is wrong. “TO TRACE” creates a file with the SQL, not a copy of the control file. B is correct.

puntano

puntano

Thanks MJ, is correct your opinion.

Vonpire

Vonpire

Correct answer is B