Exam 1z0-063 topic 1 question 174 discussion

Actual exam question from Oracle's 1z0-063

Question #: 174
Topic #: 1

[All 1z0-063 Questions]

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by Sherry at Sept. 1, 2019, 2:09 a.m.

Comments

Submit Cancel

Sherry

Highly Voted 5 years, 8 months ago

Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options: * Back up the control file to a binary file (duplicate of existing control file) using the following statement: ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/backup/control.bkp'; * Produce SQL statements that can later be used to re-create your control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; This command writes a SQL script to a trace file where it can be captured and edited to reproduce the control file. View the alert log to determine the name and location of the trace file.

upvoted 7 times

ErikJanssen

4 years, 1 month ago

thanks, I forgot

upvoted 1 times

...

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam

Exam 1z0-063 topic 1 question 174 discussion

Comments

Sherry

ErikJanssen

SY0-701