单选题The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）AThe Oracle database will not perform block checking for any of the data blocks.BThe Oracle database will perform block checking for the d

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

What purpose would you achieve by enabling the block change tracking feature？（）

• A、 Eliminate the necessity for backups.
• B、 Perform optimized image copy backups.
• C、 Perform optimized incremental backups.
• D、 Enable checkpoint （CKPT） to perform checkpointing at every block change.
• E、 Enable database writer （DBWn） to write changed blocks to data files faster.

第3题：

The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?（）

• A、The Oracle database will perform block checking for the index blocks only 
• B、The Oracle database will not perform block checking for any of the data blocks 
• C、The Oracle database will perform block checking for the default permanent tablespace only 
• D、The Oracle database will perform block checking for the data blocks in all user tablespaces 
• E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle

第4题：

You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）

• A、 by using the DBMS_REPAIR package
• B、 by using the DB_BLOCK_CHECKING parameter
• C、 by using the DBVERIFY utility
• D、 will not be completely resolved until the hardware fault is corrected

第5题：

You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file：  DB_BLOCK_CHECKING = TRUE；  What will be the result of setting this parameter？（）

• A、 Only data blocks of the SYSTEM tablespace will be checked.
• B、 Only data blocks of the SYSAUX tablespace will be checked.
• C、 A checksum will occur only on the checkpoint.
• D、 A checksum will occur every time a block is modified.

第6题：

The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

• A、 The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
• B、 The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
• C、 The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
• D、 The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
• E、 The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）

• A、Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
• B、The change tracking file must always be backed up when you perform a full database backup.
• C、Block change tracking will always reduce I/O performed during cumulative incremental backups.
• D、More than one database block may be read by an incremental backup for a change made to a single block.
• E、The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

第15题：

The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

• A、 The Oracle database will perform block checking for the index blocks only
• B、 The Oracle database will not perform block checking for any of the data blocks
• C、 The Oracle database will perform block checking for the default permanent tablespace only
• D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
• E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

第16题：

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）

• A、The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
• B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
• C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
• D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
• E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent

第17题：

You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes.   Which action will you perform to check the data blocks？（）

• A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
• B、 Use the ANALYZE utility.
• C、 Use the DBVERIFY utility.
• D、 Use the DBMS_REPAIR package.

第18题：

You have the following requirements in relation to the detection of block corruption for your database instance：   Check for logical self-consistency of data blocks when modified in memory.  Checksums are calculated before and after the block change.  Checks are performed for the lost writes to the physical standby database.   Which method would help you perform the above checks automatically？（）

• A、 Set the DB_SECUREFILE parameter to PERMITTED
• B、 Set the DB_ULTRA_SAFE parameter to DATA_ONLY
• C、 Set the DB_LOCK_CHECKSUM parameter to TYPICAL
• D、 Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：