单选题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 utilityB the DBVERIFY utilityC the ANALYZE commandD the RM

第1题：

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

• A、Corrupted blocks, if any, are repaired.
• B、Checks are performed for physical corruptions.
• C、Checks are performed for logical corruptions.
• D、Checks are performed to confirm whether all database files exist in correct locations
• E、Backup sets containing both data files and archive logs are created.

第2题：

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

第3题：

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 RMAN LIST command
• B、 the DBNEWID utility
• C、 the RMAN REPORT command
• D、 the RMAN BLOCKRECOVER command
• E、 the RMAN CROSSCHECK command
• F、 the ANALYZE 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题：

In Recovery Manager （RMAN）， you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged， you want to place the data file in a different location while resto ing the file.  Which option must you consider for this task？（）  

• A、 using only the RMAN SWITCH command to set the new location for the data file
• B、 placing the database in the MOUNT state for the restore and recovery operations
• C、 using an RMAN RUN block with the SET NEWNAME and then the SWITCH command
• D、 configuring two channels： one for the restore operation and the other for the recovery operation

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

• A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
• B、You must define directories for two online redo log groups and three copies of the control file. 
• C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
• D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

第14题：

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

第15题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第16题：

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

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

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：