Oracle
1Z0-063 · Question #144
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. 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.
How the community answered
(51 responses)- A4% (2)
- B84% (43)
- C10% (5)
- D2% (1)
Community Discussion
No community discussion yet for this question.