单选题Which command would you use to determine what database backups are currently available for restore？（）A  list database backupB  report database backupC  list backup of databaseD  list summary backupE  report backup of database

第1题：

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

• A、To store the backup information of multiple database
• B、To restrict the amount of space that is used by the backups
• C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

第2题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

• A、Hot backup
• B、Online backup
• C、consistent backup
• D、incremental backup
• E、inconsistent backup

第3题：

Which command do you use to generate a report of database incarnations？（）  

• A、 list incarnation of database
• B、 report incarnation of database
• C、 list database incarnation
• D、 database incarnation list
• E、 report database incarnation

第4题：

You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

• A、create a backup of the database and recover all corrupted blocks found in the backup
• B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
• C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
• D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
• E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

第5题：

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

• A、To store the backup information of multiple database
• B、To restrict the amount of space that is used by the backups
• C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

第6题：

Which command would you use to determine what database backups are currently available for restore?（）

• A、list database backup
• B、report database backup  
• C、list backup of database
• D、list summary backup
• E、report backup of database

第7题：

Which command would you use to determine what database backups are currently available for restore？（）  

• A、 list database backup
• B、 report database backup
• C、 list backup of database
• D、 list summary backup
• E、 report backup of database

第8题：

The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）

• A、 a list of all those files that have been deleted in the last two days
• B、 a list of all those files that have been recovered within the last two days
• C、 a list of all the expired backups and copies
• D、 a list of backups and copies that are outside the range covered by the current retention policy

第9题：

You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：  RMAN> REPORT NEED BACKUP days 3;  What would be the output of this command？（） 

• A、a list of files that require a backup within three days
• B、a list of files that have not been backed up for three days
• C、a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
• D、a list of files for which a backup has already been performed and may need a backup after three days

第10题：

You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

• A、the CONVERT command of RMAN
• B、Data Pump Export and Import into the same database
• C、conventional export and import into the same database
• D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
• E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN