Oracle
1Z0-063 · Question #144
1Z0-063 Question #144: Real Exam Question with Answer & Explanation
The correct answer is B. It creates a file that contains the SQL statement, which is required to re-create the control file.. See the full explanation below for the reasoning.
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 specified in 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.
Community Discussion
No community discussion yet for this question.