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

The correct answer is B. It creates a file that contains the SQL statement, which is required to re-create the control file. "TO TRACE" creates a file with the SQL, not a copy of the control file.

New Features for Manageability

Question

You issue the command:

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

Options

AIt creates a copy of the control file and stores it in the location specifiedin the diagnostic_dest
BIt creates a file that contains the SQL statement, which is required to re-create the control file.
CIt updates the alert log file with the location and contents of the control file.
DIt creates a binary backup of the control file.

How the community answered

(39 responses)

A
8% (3)
B
77% (30)
C
3% (1)
D
13% (5)

Explanation

"TO TRACE" creates a file with the SQL, not a copy of the control file.

Topics

#control file backup#BACKUP CONTROLFILE TO TRACE#trace file#SQL recreation

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice