Free 1Z0-060 Web TestEngine Demo

Q12 Single choice

Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE NORESETLOGS, whenever you make structural changes to the database. A media failure has damaged all the control files, but the online redo log files are intact. You
issue a SHUTDOWN ABORT.

How should you recover the control file to its default location?

A
Restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, start a new instance and mount the database, recover the database, and then open the database with the RESETLOGS option.
B
Issue the STARTUP NOMOUNT command, restore the backup control file only to the default location,
issue RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL, and open the
database with the RESETLOGS option.
C
Issue the STARTUP MOUNT command, restore the backup control file to all the locations specified in
the CONTROL_FILES parameter file, and then issue RECOVER DATABASE USING BACKUP
CONTROLFILE.
D
Issue the STARTUP NOMOUNT command, re-create the control file manually by using the CREATE CONTROLFILE command, issue the RECOVER DATABASE command, and then issue the ALTER DATABASE OPEN command.

1Z0-060 Web TestEngine demo