单选题When issuing the CROSSCHECK command in RMAN， if a backup file CANNOT be found， to what status is that file set？（）A DELETEDB OBSOLETEC EXPIREDD UNKNOWN

第1题：

Why would you run the delete obsolete command？（）  

• A、 To remove missing backup set pieces physically from disk
• B、 To remove metadata related to backup set pieces in the control file and the recovery catalog
• C、 To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
• D、 To delete backup set pieces associated with backups that are no longer needed due to retention criteria
• E、 To remove old versions of RMAN backups

第2题：

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

• A、RMAN would use the current operating system location to place the backup.
• B、RMAN would use the control file of the target database to maintain the backup.
• C、RMAN would use the recovery catalog of the target database to maintain the backup.
• D、RMAN would use the control file of the target database to maintain the backup metadata. 
• E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

第3题：

You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

• A、Datafiles
• B、 Current control file
• C、 Server parameter file （spfile）
• D、 Password file

第4题：

If you CROSSCHECK the backup piece that was previously marked as EXPIRED but is now available， what would the status of this backup piece be in the RMAN repository？（）

• A、EXPIRED
• B、AVAILABLE
• C、UNAVAILABLE
• D、ACCESSIBLE

第5题：

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

• A、The backup status will be marked expired in RMAN recovery catalog.
• B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
• C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
• D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
• E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

第6题：

When issuing the CROSSCHECK command in RMAN， if a backup file CANNOT be found， to what status is that file set？（）

• A、DELETED
• B、OBSOLETE
• C、EXPIRED
• D、UNKNOWN

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of the above command？（）

• A、 After two days， the backup will be marked obsolete.
• B、 After two days， the backup will be deleted from the media.
• C、 If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.
• D、 If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.

第14题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

• A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
• B、 When a structural change is made to the database， then a backup of the current control file is performed.
• C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
• D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

第15题：

Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system？（）

• A、CHANGE
• B、RESYNC
• C、CATALOG
• D、CROSSCHECK

第16题：

You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）

• A、RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
• B、RMAN reads the block change tracking file when it performs both incremental backups.
• C、RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
• D、RMAN does not read the block change tracking file when it performs either incremental backup.

第17题：

You issue the following RMAN command to set a retention policy on a database：   RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of issuing this command？（）  

• A、 After two days，a backup will be marked obsolete
• B、 After two days，a backup will be deleted from the media
• C、 If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.
• D、 If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.

第18题：

When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）

• A、At the end of every RUN block. 
• B、After every SET CONTROLFILE AUTOBACKUP FORMAT command. 
• C、After every BACKUP or COPY command issued at the RMAN prompt. 
• D、At the end of every RUN block if the last command in the block was either BACKUP or COPY. 
• E、Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. 
• F、After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：