1Z0-043: Oracle database 10g:Administration ii
1. There was media failure and you need to check the data files for any block corruption. Which option
would you use to create a report on any corruptions found within the database?
A.the DBNEWID utility
B.the DBVERIFY utility
C.the ANALYZE command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the CHECK_OBJECT procedure of the DBMS_REPAIR package
ANSWER: B
2. The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES
table is affected by the block corruption found in the USERS tablespace. Which option would you use?
A.the DBNEWID utility
B.the ANALYZE command
C.the RMAN LIST command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the RMAN BLOCKRECOVER command
ANSWER: B
3. The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking
would be performed?
A.The Oracle database will not perform block checking for any of the data blocks.
B.The Oracle database will perform block checking for the default permanent tablespace only.
C.The Oracle database will perform block checking for the data blocks in all user tablespaces.
D.The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
E.The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX
tablespaces.
ANSWER: D
