单选题

You are working as a DBA in a company. The datafiles in the database are as follows:    On Monday, you tried to start up the database but failed because all the control files were missing. You recreated the control file using the script you have created by issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. What is the prerequisite for recreating the control file?()

A All the datafiles should be listed in the CREATE CONTROLFILE statement.

B The DATA2.dbf and DATA3.dbf datafiles should be listed in the CREATE CONTROLFILE statement. 

C The SYSTEM01.dbf datafile should be listed in the CREATE CONTROLFILE statement.

D The SYSAUX01.dbf datafile should be listed in the CREATE CONTROLFILE statement.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()

    多选题查看答案

  • You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()

    多选题查看答案

  • You are managing an Oracle Database 11g database. The database is open, and you plan to  performRecovery Manager (RMAN) backups.  Which three statements are true about these backups()

    多选题查看答案

  • You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

    多选题查看答案

  • You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance:   SQL> ALTER SYSTEM SWITCH LOGFILE;   Which two tasks are performed when the statement is executed? ()

    多选题查看答案

  • You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use?()

    单选题查看答案

  • You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()

    单选题查看答案

  • You are working on the Certkiller database.  What is the default name of the alert log file in this database?()

    单选题查看答案

  • You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:  SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()

    多选题查看答案

  • You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process?()

    单选题查看答案