What is the result of this command？（） RMAN> Report need back

第1题：

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

第2题：

What is the purpose of the catalog command？（）  

• A、 To review RMAN control file and recovery catalog metadata and ensure that its correct
• B、 To delete RMAN backup-related metadata from the recovery catalog
• C、 To create metadata in the control file and the recovery catalog related to backup set pieces 
• D、 To create a report that lists database backups
• E、 To rebuild the recovery catalog

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

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

第5题：

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

第6题：

What does the output on this report indicate？（）   RMAN> report need backup；  RMAN retention policy will be applied to the command  RMAN retention policy is set to redundancy 1  Report of files with less than 1 redundant backups  File #bkps Name  5 0 C:///ORACLE/ORADATA/ORCL/MY_DATA_01.DBF  

• A、 The my_data_01.dbf datafile is corrupted and needs to be restored.
• B、 The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
• C、 The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
• D、 The my_data_01.dbf datafile no longer meets the retention criteria for backups.
• E、 Datafile 5 is missing.

第7题：

What RMAN command must you use before you can back up a database using the recovery catalog？（）

• A、 create catalog
• B、 install database
• C、 catalog database
• D、 merge Catalog with database
• E、 register database

第8题：

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

第9题：

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

第10题：

You issue the following command：   RMAN>CONFIGURE BACKUP OPTIMIZATION ON；   What is the result of this command on your backups？（）

• A、 An incremental backup strategy will be used automatically.
• B、 Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
• C、 RMAN will configure itself for maximum performance at the cost of CPU.
• D、 RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
• E、 RMAN will automatically compress backups.