多选题For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）ARMAN image copiesBRMAN database backupsCRMAN tablespace backupsDuser­managed backups placed in the flash recovery areaEuser­managed bac

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

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.

第3题：

Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）

• A、New channels for restore and recovery tasks
• B、New name for the data files of the tablespace
• C、Auxiliary name for the data files of the tablespace
• D、Auxiliary destinations for an auxiliary set of data files

第4题：

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

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

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.

第7题：

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

第8题：

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

• A、The database will open, and the tablespace automatically comes out of the backup mode
• B、The database will be mounted, and recovery must be performed on the USERS tablespace.
• C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
• D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

第9题：

第10题：

第11题：

第12题：

第13题：

To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）  

• A、 The database will open，and the tablespace automatically comes out of the backup mode.
• B、 The database will be mounted，and recovery must be performed on the USERS tablespace.
• C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
• D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

第14题：

You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）

• A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
• B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
• C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
• D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

第15题：

Which two are characteristics of user-managed backup and recovery operations？（）

• A、Recovery is initiated using SQL*Plus.
• B、Database files are backed up using SQL commands.
• C、Database files are backed up with Recovery Manager.
• D、Database files are restored using Recovery Manager.
• E、Database files are backed up using operating system commands.

第16题：

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

第17题：

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

• A、 Restore the lost data file from the backup， and then flash back the database.
• B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
• C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
• D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
• E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

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

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

第20题：

第21题：

第22题：

第23题：

第24题：