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、usermanaged backups placed in the flash recovery areaE、usermanaged backups that have been cataloged with RMANF、usermanaged data file backups for which the full path name is specified
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、usermanaged backups placed in the flash recovery area
- E、usermanaged backups that have been cataloged with RMAN
- F、usermanaged data file backups for which the full path name is specified
相关考题：
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 scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
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 catalogB. Backups that can be deleted from diskC. Backup sets and images copies that are obsoleteD. Backups that do not have the AVAILABLE status in the RMAN repository
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 catalogB. backups that can be deleted from diskC. backup sets and image copies are obsoleteD. backups that do not have the AVAILABLE status in the RMAN repository RMAN
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 catalogB、backups that can be deleted from diskC、backup sets and image copies are obsoleteD、backups that do not have the AVAILABLE status in the RMAN repository RMAN
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 mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.
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 catalogB、Backups that can be deleted from diskC、Backup sets and images copies that are obsoleteD、Backups that do not have the AVAILABLE status in the RMAN repository
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 instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode
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 fileB、Archived redo log filesC、Control file autobackupsD、Server Parameter file (SPFILE)E、Recovery Manager (RMAN) backup piece
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）A、 data fileB、 password fileC、 archivelog fileD、 temporary fileE、 online redo log fileF、 the current control fileG、 the tnsnames.ora fileH、 current server parameter file
Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2？（）A、 Alert log fileB、 Archived redo log filesC、 Control file autobackupsD、 Server Parameter file （SPFILE）E、 Recovery Manager （RMAN） backup piece
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 / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
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.
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.
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 cataloglD、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）.
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 deletedB、stored scripts in the recovery catalogC、backup sets and image copies that are obsoleteD、only the most recent backup sets or image copiesE、backups that do not have the AVAILABLE status in RMAN repository
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）A、data fileB、password fileC、archivelog fileD、temporary fileE、online redo log fileF、the current control fileG、the tnsnames.ora fileH、current server parameter file
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 recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery
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 scriptsB、 Recovery is faster if data is stored in catalog in addition to the control fileC、 You can store backup information of all registered databases in one placeD、 Database backups are automatically deleted when they are older than the specified time period
多选题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？（）AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online， read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online， read/write data files when the database is in the NOMOUNT state.
单选题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 recoveryB user managed incomplete recoveryC RMAN-based complete recoveryD RMAN-based incomplete recovery
多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（）AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup piece
单选题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？（）AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.EThe 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）.
多选题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 backupsDusermanaged backups placed in the flash recovery areaEusermanaged backups that have been cataloged with RMANFusermanaged data file backups for which the full path name is specified
单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）A by using the Flashback Table featureB by using the Flashback Database featureC by performing incomplete recovery using RMAN utilityD by performing incomplete recovery using user-managed recovery
多选题For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）ARMAN image copies.BRMAN database backups.CRMAN tablespace backups.DUser-managed backups placed in the flash recovery area.EUser-managed backups that have been cataloged with RMAN.FUser-managed data file backups for which the pull path name is specified.
多选题When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）Adata fileBpassword fileCarchivelog fileDtemporary fileEonline redo log fileFthe current control fileGthe tnsnames.ora fileHcurrent server parameter file