单选题You have the following requirements in relation to the detection of block corruption for your database instance: 1. Check for logical self-consistency of data blocks when modified in memory. 2. Checksums are calculated before and after the block change

第1题：

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  

• A、 The block change tracking feature must be enabled.
• B、 OMF must be configured on your database.
• C、 The database must be in ARCHIVELOG mode.
• D、 A USERID must be supplied.

第2题：

You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  

• A、 Repair the corrupted blocks. If any. In the backup created
• B、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
• C、 Back up the database after checking whether array of the files have corrupted blocks
• D、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
• E、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

第3题：

第4题：

Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

• A、 The block change tracking data will be used only from the next incremental 0 backup.
• B、 The incremental backup will use change tracking data for accomplishing the backup.
• C、 The incremental backup will not use change tracking data for accomplishing the backup.
• D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

第5题：

he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）

• A、Use the Data Block Wizard and base the relation on a REF pointer. 
• B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
• C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. 
• D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables. 

第6题：

While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

• A、 Block Media Recovery must be used with RMAN.
• B、 You must perform complete recovery of individual blocks.
• C、 You must have a full RMAN backup， not an incremental backup.
• D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.

第7题：

You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）

• A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
• B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
• C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；
• D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；

第8题：

第9题：

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

第10题：

You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

• A、create a backup of the database and recover all corrupted blocks found in the backup
• B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
• C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
• D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
• E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired