单选题

You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()

AStart the instance and open the database, instance recovery automatically recovers control files 

BCreate a file based on the contents of the trace file and save it to the control file locations and start the database 

CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.) 

DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 

EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this?()

    单选题查看答案

  • You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old  In which situation would you receive such an error?()

    单选题查看答案

  • You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing?()

    单选题查看答案

  • You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this? ()

    单选题查看答案

  • You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this?()

    多选题查看答案

  • You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups()

    多选题查看答案

  • You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, and dropped a couple of tablespaces. This morning, due to hardware failure, you lost all your control files.  How would you recover the database from this situation?()

    单选题查看答案

  • You work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) to perform backups in your databases.  Which four backup operations can be performed using RMAN?()

    多选题查看答案

  • You need to rename a data file of a tablespace. How would you perform this?()

    单选题查看答案

  • You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting?()

    单选题查看答案