nerdexam
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)
  • A
    4% (2)
  • B
    84% (43)
  • C
    10% (5)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice