For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、user­managed backups placed in the flash recovery areaE、user­managed b

第1题：

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（）

• A、stored scripts in the recovery catalog
• B、backups that can be deleted from disk
• C、backup sets and image copies are obsolete
• D、backups that do not have the AVAILABLE status in the RMAN repository RMAN

第2题：

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?（）

• A、Stored scripts in the recovery catalog
• B、Backups that can be deleted from disk
• C、Backup sets and images copies that are obsolete
• D、Backups that do not have the AVAILABLE status in the RMAN repository

第3题：

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)

• A、Alert log file
• B、Archived redo log files
• C、Control file autobackups
• D、Server Parameter file (SPFILE)
• E、Recovery Manager (RMAN) backup piece

第4题：

Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2？（）

• A、 Alert log file
• B、 Archived redo log files
• C、 Control file autobackups
• D、 Server Parameter file （SPFILE）
• E、 Recovery Manager （RMAN） backup piece

第5题：

The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）

• A、 If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.
• B、 If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.
• C、 If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.
• D、 If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.

第6题：

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）.

第7题：

When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）

• A、data file
• B、password file
• C、archivelog file
• D、temporary file
• E、online redo log file
• F、the current control file
• G、the tnsnames.ora file
• H、current server parameter file

第8题：

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts
• B、 Recovery is faster if data is stored in catalog in addition to the control file
• C、 You can store backup information of all registered databases in one place
• D、 Database backups are automatically deleted when they are older than the specified time period

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）

• A、A backup of the target database when it is mounted
• B、A backup of online redo log files when the database is open
• C、A backup of only used data blocks in the file beingbeingbackup up
• D、A backup of online， read/write data files when the database is open
• E、A backup of only those data blocks that have changed since a previous backup
• F、A backup of online， read/write data files when the database is in the NOMOUNT state.

第14题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

• A、shut down and restart the instance
• B、add new tempfiles to the temporary tablespaces after recovery
• C、perform a media recovery and open the database with the RESETLOGS option
• D、perform a media recovery and bring the database to NOARCHIVELOG mode

第15题：

When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）

• A、 data file
• B、 password file
• C、 archivelog file
• D、 temporary file
• E、 online redo log file
• F、 the current control file
• G、 the tnsnames.ora file
• H、 current server parameter file

第16题：

You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

• A、 rman TARGET / NOCATALOG
• B、 rman TARGET sys/password
• C、 rman TARGET sys/password AS SYSDBA
• D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

第17题：

For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）

• A、 RMAN image copies.
• B、 RMAN database backups.
• C、 RMAN tablespace backups.
• D、 User-managed backups placed in the flash recovery area.
• E、 User-managed backups that have been cataloged with RMAN.
• F、 User-managed data file backups for which the pull path name is specified.

第18题：

Using the LIST command in Recovery Manager （RMAN）， which two pieces of information from the RMAN repository can be listed？ （）

• A、backups that can be deleted
• B、stored scripts in the recovery catalog
• C、backup sets and image copies that are obsolete
• D、only the most recent backup sets or image copies
• E、backups that do not have the AVAILABLE status in RMAN repository

第19题：

You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

• A、 user managed complete recovery
• B、 user managed incomplete recovery
• C、 RMAN-based complete recovery
• D、 RMAN-based incomplete recovery

第20题：

第21题：

第22题：

第23题：