单选题You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use？（）A  FILEB  PARFILEC  LOGFILED  FEEDB

第1题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data

第2题：

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.

第3题：

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）

• A、 LogMiner
• B、 The DBNEWID utility
• C、 The DBVERIFY utility
• D、 The ANALYZE command
• E、 The RMAN REPORT command
• F、 The RMAN CROSSCHECK command.
• G、 The RMAN BLOCKRECOVER command.

第4题：

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

第5题：

You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use？（）

• A、 FILE
• B、 PARFILE
• C、 LOGFILE
• D、 FEEDBACK

第6题：

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.

第7题：

You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

• A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.
• B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
• C、 The control file must be recreated.
• D、 The database must be opened with the RESETLOGS option.

第8题：

You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

• A、by using the ANALYZE utility
• B、by using the DBVERIFY utility
• C、by using the DB_BLOCK_CHECKING parameter
• D、by using the DBMS_REPAIR package

第9题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data.

第10题：

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