多选题What information does the report schema command not provide？（）ASize of the datafilesBSize of the tempfilesCDate of last backup for datafiles and tempfilesDFilenames for each datafileECheckpoint SCN associated with the last RMAN backup

第1题：

What does the minimize load database parameter mean when backing up a database?（）

• A、RMAN will attempt to make the backup run as fast as possible without any IO limitations. 
• B、RMAN will automatically restrict the number of channels in use to one. 
• C、RMAN will spread the backup IO over the total duration stated in the backup command.
• D、RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up. 
• E、Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first. 

第2题：

In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；

• A、 to configure RMAN to maintain backup information in the RMAN repository for seven days
• B、 to configure RMAN to maintain backup information in the control file for at least seven days
• C、 to display the list of files that have not been backed up for the last seven days
• D、 to display the list of files that must be backed up within seven days

第3题：

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

第4题：

You executed the following command in the Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）  

• A、 A list of files that require a backup within 3 days
• B、 A list of files requiring more than 3 days of archivelogs to apply
• 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 as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

第5题：

What is the impact of the results of the output of the following command？（）   RMAN> report unrecoverable database；  Report of files that need backup due to unrecoverable operations  File Type of Backup Required Name  4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF  

• A、 There are no backup sets with any backups of the users01.dbf datafile.
• B、 The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
• C、 The users01.dbf datafile is corrupted.
• D、 The users01.dbf datafile backup exceeds the retention criteria.
• E、 The last backup of the users01.dbf datafile failed and must be rerun.

第6题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

• A、You need to perform the restore and recover operations manually, because the backup was made manually. 
• B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
• C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
• D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

第7题：

What information does the report schema command not provide？（） 

• A、 Size of the datafiles
• B、 Size of the tempfiles
• C、 Date of last backup for datafiles and tempfiles
• D、 Filenames for each datafile
• E、 Checkpoint SCN associated with the last RMAN backup

第8题：

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.

第9题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第10题：

You executed the following command in Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）  

• A、 a list of files that require a backup within three days
• B、 a list of files requiring more than 3 days of archive logs to apply
• 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 in the last three days and which is required to be backed up again based on the high number of transactions performed on them