单选题

You work as a database administrator for Supportcenter.cn. 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 recoverscontrol 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 Supportcenter.cn. 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 are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()

    多选题查看答案

  • You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

    多选题查看答案

  • You work as a database administrator for Supportcenter.cn. 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 Supportcenter.cn. 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 Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()

    多选题查看答案

  • You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()

    多选题查看答案

  • You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()

    多选题查看答案

  • You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()

    单选题查看答案

  • You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()

    多选题查看答案