多选题Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）AFailure when no standby database is configuredBFailure because a data file is renamed accidentallyCFailure that requires no archive logs to be applied for reco

第1题：

第2题：

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、flash back all the tables in the data file， one by one
• B、restore the data file to a new location and perform a media recovery
• C、flash back the database; there is no need to restore the data file
• D、restore the data file from the most recent backup and flash back the database

第3题：

第4题：

Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）

• A、failure when no standby database is configured
• B、failure because a data file is renamed accidentally
• C、failure that requires no archive logs to be applied for recovery
• D、failure due to loss of connectivity-for example， an unplugged disk cable

第5题：

Which two activities are NOT supported by the Data Recovery Advisor?（）

• A、Diagnose and repair a data file corruption offline.
• B、Diagnose and repair a data file corruption online.
• C、Diagnose and repair failures on a standby database.
• D、Recover from failures in the Real Application Cluster (RAC) environment.

第6题：

Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）

• A、Failure when no standby database is configured
• B、Failure because a data file is renamed accidentally
• C、Failure that requires no archive logs to be applied for recovery
• D、Failure due to loss of connectivity-for example， an unplugged disk cable

第7题：

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）

• A、Redo logs
• B、Control file
• C、The latest backup of only the damaged data file
• D、The latest backup of all the data file in the USERS tablespace
• E、Temporary files of temporary tablespace
• F、Archive Logs since the latest backup to point of failure

第8题：

第9题：

Your production database is running in archivelog mode and you are using recovery manager （RMAN） with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday， the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.   The steps to recover the damaged data files are follows：   1. Mount the database  2. Open the database  3. Recover the data file  4. Restore the data file  5. Make the data file offline  6. Make the data file online   Which option identifies the correct sequence that you must use to recover the data files？（）

• A、 2，4，3
• B、 1，4，3，2
• C、 2，5，4，3，6
• D、 5，2，4，3，6
• E、 1，5，4，3，6，2

第10题：

What are the two advantages of RMAN Block Media Recovery （BMR） over file/x7flevel recovery？（）

• A、BMR lowers the mean time to recover （MTTR）.
• B、BMR supports point­in­time recovery of individual data blocks.
• C、BMR enables you to use incremental backups for block recovery.
• D、BMR enables recovery even when the database is not mounted or open.
• E、BMR enables you to use proxy backups to perform block media recovery.
• F、BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.