单选题You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）A  UNTIL CANCELB  UNTIL SCNC  UNTIL S

第1题：

You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

• A、 Whole database
• B、 Tablespaces
• C、 Datafiles
• D、 Archive logs
• E、 Redo logs

第2题：

When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）

• A、Thread number.
• B、Log Sequence number.
• C、Control file sequence number.
• D、Name of the last archived log.

第3题：

第4题：

In which scenario will you perform a user-managed incomplete recovery？（）

• A、 when a table is dropped and stored in the Recycle Bin
• B、when a table is dropped and purged from the Recycle Bin
• C、 when you are required to recover an existing table to its previous state
• D、 when you are required to view all the versions of a row of an existing table between a specific time period

第5题：

You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

• A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.
• B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
• C、 The control file must be recreated.
• D、 The database must be opened with the RESETLOGS option.

第6题：

You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

• A、 The log sequence for the database will restart from 1.
• B、 The log sequence number will be written to the control file.
• C、 The log sequence number will be written to the datafile headers.
• D、 The log sequence number will be written to the initialization parameter file.

第7题：

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

• A、Perform Export before TSPITR and Import after TSPITR
• B、Move objects to another schema that has the same tablespace assigned
• C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

第8题：

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

• A、 until Thursday morning
• B、 until that point in time when the database is opened
• C、 until that point in time when the recovery is performed
• D、 until last Sunday’s backup
• E、 until that point in time when the table is dropped and purged
• F、 until Wednesday evening

第9题：

You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

• A、 UNTIL CANCEL
• B、 UNTIL SCN
• C、 UNTIL SEQUENCE
• D、 UNTIL TIME

第10题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

• A、 UNTIL SEQUENCE
• B、 UNTIL SCN
• C、 UNTIL CHANGE
• D、 UNTIL CANCEL