多选题You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)AYou must configure block change tracking fileBYou

第1题：

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.

第2题：

You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

• A、 V$BACKUP_CORRUPTION
• B、 V$COPY_CORRUPTION
• C、 V$DATABASE_BLOCK_CORRUPTION
• D、 RC_BACKUP_CORRUPTION

第3题：

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

• A、 take data files from the read-only tablespace offline before performing a recovery
• B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
• C、 drop the read-only tablespace and re-create the tablespace after recovery
• D、 perform a recovery； status of the tablespace in control file will be changed automatically

第4题：

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.

第5题：

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

第6题：

You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）

• A、 You need to mention it with every BACKUP command.
• B、 The block change tracking feature is used automatically by RMAN.
• C、 You need to configure it using the CONFIGURE command.
• D、 You need to set the necessary initialization parameters to direct RMAN to use the feature.

第7题：

You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

• A、You must ensure that the SALES database is mounted or open.
• B、You must restore a backup control file to perform a block media recovery.
• C、You must take the tools01.dbf data file offline before you start a block media recovery.
• D、You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E、You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

• A、On startup， SMON coordinates instance recovery.
• B、On startup， CKPT coordinates instance recovery.
• C、On startup， use RMAN to perform instance recovery.
• D、Uncommitted changes will be rolled back after the database is opened.
• E、On startup， perform media recovery and then instance recovery.
• F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

第14题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

• A、You must configure block change tracking file
• B、You must have first level 1 backups for RMAN to restore blocks
• C、You must ensure that the SALES database is mounted or open
• D、You must have full or level 0 backups for RMAN to restore blocks
• E、You must take the tools01.dbf data file offline before you start a block media recovery

第15题：

Which of the following are correct about block media recovery？（）

• A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
• B、 Logical corruptions are repairable by BMR
• C、 Physical corruptions are repairable by BMR
• D、 RMAN can use any backup for a BMR restore
• E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

第16题：

A data file become 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 the database.

第17题：

Which of the following would you use to enable automatic media recovery for a database？（）

• A、SET AUTORECOVERY ON
• B、SET RECOVERY ON
• C、SET AUTO ON
• D、You cannot enable automatic media recovery.

第18题：

You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

• A、 You do not need to restore all the data files.
• B、 You do not need to open the database with the RESETLOGS operation
• C、 You do not need to perform a full backup after the RESETLOGS operation.
• D、 You do not need to recover all the data files to the same system change number （SCN）.

第19题：

You are implementing transaction log shipping for a database named DB1 from a server named SQL1 to a server named SQL2. Because DB1 is 100 GB in size， it is too big to transfer over the network in a reasonable amount of time. You need to minimize the impact on the network while you initialize the secondary database. Which two actions should you perform？（）

• A、Specify the simple recovery model for DB1.
• B、Specify either the full or the bulk-logged recovery model for DB1.
• C、Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the RECOVERY option.
• D、Perform a complete backup of DB1 to portable media. Restore the secondary database from that backup； specify the STANDBY option.
• E、Before you activate transaction log shipping to the secondary database， execute the following statement on the primary server.BACKUP LOG DB1 WITH TRUNCATE ONLY

第20题：

第21题：

第22题：

第23题：

第24题：