多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for rec

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

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

• A、Restore the data file and perform incomplete recovery.
• B、Restore the data file and perform point-in-time recover.
• C、Drop the tablespace and lose all data in the tablespace.
• D、Restore the database and lose all data since the last backup.