单项选择题

In which situation are you NOT required to perform an incomplete recovery？（）

A. when all the control files are lost
B. when all the members of a redo log group are lost
C. when a table is dropped and purged from the Recycle Bin
D. when a temporary file of the default temporary tablespace is lost

点击查看答案

上一题目录下一题

相关考题

单项选择题

In which scenario will you perform a cancel-based recovery？（）

A. when a tablespace is dropped and you have only RMAN-based backup of the database
B. when a table is dropped and stored in the Recycle Bin
C. when you are required to recover an existing table to its previous state
D. when a tablespace is dropped and you have only a user-managed full backup of the database

单项选择题

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMAN>BACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

A. Start the database in the MOUNT stage.
B. Back up the control file to trace.
C. Set the DBID
D. Issue the RECOVER DATABASE command.

单项选择题

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