單項(xiàng)選擇題

In which scenario will you issue the following command？（）
SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING
BACKUP CONTROLFILE；

A. when all the control files are missing and only a binary backup of the current control file exists
B. when a multiplexed copy of the current control file is missing
C.when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
D. when the SPFILE is missing

你可能感興趣的試題

單項(xiàng)選擇題

In which scenario will you perform an incomplete recovery？（）

A. when a table is dropped and stored in the Recycle Bin
B. when all the control files are deleted
C. when a member of a multiplexed redo log group is dropped
D. when you are required to recover a table to its previous state

單項(xiàng)選擇題

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.

In which scenario will you issue the following command？（） SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；

你可能感興趣的試題

In which scenario will you perform an incomplete recovery？（）

In which scenario will you issue the following command？（）
SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING
BACKUP CONTROLFILE；