单选题In which scenario will you perform a cancel-based recovery？（）Awhen a tablespace is dropped and you have only RMAN-based backup of the databaseBwhen a table is dropped and stored in the Recycle BinCwhen you are required to recover an existing table to i

第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题：

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)

第3题：

You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）

• A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.
• B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
• C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
• D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

第4题：

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

第5题：

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

第6题：

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

第7题：

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

• A、You must shut down the database instance to perform the backups.
• B、You must configure the Flash Recovery Area （FRA） for the database.
• C、You can perform complete database backups without closing the database.
• D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

第8题：

Which of the following statements is NOT true about RMAN？（）

• A、It improves usability by enabling you to reuse the scripts to perform recovery operations.
• B、It detects block corruption while restoration and recovery operations.
• C、It enables you to perform block media recovery.
• D、It is capable to recover through unrecoverable operations， with only full database backups.

第9题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

• A、shut down and restart the instance
• B、add new tempfiles to the temporary tablespaces after recovery
• C、perform a media recovery and open the database with the RESETLOGS option
• D、perform a media recovery and bring the database to NOARCHIVELOG mode

第10题：

Which statement about recovering from the loss of a redo log group is true?（）

• A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
• B、If the lost redo log group is CURRENT, you must clear the log file.
• C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
• D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.