试题详情
单项选择题 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.

  • B
  • 关注下方微信公众号,在线模考后查看

热门试题