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 B

第1题：

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 ；

第2题：

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

• A、flash back the corrupted blocks
• B、use the DBMS_REPAIR package
• C、use the RMAN TSPITR command
• D、use the RMAN BLOCKRECOVER command
• E、use the RESTORE DATABASE and RECOVER DATABASE commands
• F、investigate the time at which the corruption occurred and perform a point-in-time recovery

第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

第4题：

You executed the following command：   RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’；   Which statement regarding the above command is correct？（）  

• A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.
• B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.
• C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.
• D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

第5题：

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

第6题：

While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）  

• A、 RECOVER FILE=1201 BLOCK=1968
• B、 RECOVER CORRUPTION LIST
• C、 RECOVER DATAFILE 1201 BLOCK 1968
• D、 RECOVER BLOCK CORRUPTION LIST
• E、 None of the above

第7题：

You received the following error：   ORA-01578： ORACLE data block corrupted   （file # %s， block # %s）   Which file will you check to view additional information regarding the cause of this error？（）

• A、the alert log file and the trace files
• B、 the redo log files
• C、 the control file
• D、 the change tracking file

第8题：

Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）

• A、Rebuild the index using the online option. 
• B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
• C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
• D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

• A、 flash back the corrupted blocks
• B、 use the DBMS_REPAIR package
• C、 use the RMAN TSPITR command
• D、 use the RMAN BLOCKRECOVER command
• E、 use the RESTORE DATABASE and RECOVER DATABASE commands
• F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

第15题：

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）

• A、flash back the corrupted blocks
• B、use the DBMS_REPAIR package
• C、use the RMAN TSPITR command
• D、use the RMAN BLOCKRECOVER command
• E、use the RESTORE DATABASE and RECOVER DATABASE commands
• F、investigate the time at which the corruption occurred and perform a point­in­time recovery

第16题：

You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）

• A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
• B、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
• C、  Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
• D、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails

第17题：

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

第18题：

You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）

• A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.
• B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.
• C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.
• D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

第19题：

You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

• A、 by using the DBMS_REPAIR package
• B、 by using the DBVERIFY utility
• C、 by using Block Media Recovery
• D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

第20题：

Which three statements are true regarding the logical structure of the Oracle database？（）

• A、Each segment contains one or more extents.
• B、Multiple tablespaces can share single data file.
• C、A data block is the smallest unit of I/O for data files.
• D、It is possible to have tablespaces of different block sizes in a database.
• E、Each data block in the database always corresponds to one OS block.

第21题：

第22题：

第23题：