You issue the command:

You issue the command:SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which statement is true about the command? “oeTO TRACE” creates a file with the SQL, not a copy of the control file.

Question:

You issue the command:

Options:

It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

It creates a file that contains the SQL statement, which is required to re-create the control file.

It updates the alert log file with the location and contents of the control file.

It creates a binary backup of the control file.

Correct Answer

The Correct Answer for this Question is

It creates a file that contains the SQL statement, which is required to re-create the control file.