You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

A .  You must ensure that the SALES database is mounted or open. B .  You must restore a backup control file to perform a block media recovery. C .  You must take the tools01.dbf data file offline before you start a block media recovery. D .  You must put the database in NOARCHIVELOG mode to perform a block media recovery. E .  You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

A .  This operation resets the SCN for the database. B .  This operation creates a new incarnation of the database. C .  This operation moves all the redo log files to a different location. D .  This operation deletes the old redo log files and creates new redo log files. E .  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

A .  The target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

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

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.

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

A . flashback logs B . current control file C . control file autobackups D . incremental backup set

A .  The index tablespace contains bitmap indexes. B .  The index tablespace contains more than one data file. C .  The index tablespace supports only complete recovery. D .  The index tablespace is not a dictionary-managed tablespace. E .  There is a dependency relationship between a table and its indexes.

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.

A . You are backing up to tape and your tape device performs its own compression. B . You are making image copies, and you have not enabled tablespace compression. C . You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited. D . You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage. E . You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

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.

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

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

A .  The user has dropped an important table that needs to be recovered. B .  The database files are corrupted when the database is open. C .  You are not able to start up the database instance because the required database files are missing. D .  The archived log files are missing for which backup is not available.

A . Corrupted blocks, if any, are repaired. B . Checks are performed for physical corruptions. C . Checks are performed for logical corruptions. D . Checks are performed to confirm whether all database files exist in correct locations E . Backup sets containing both data files and archive logs are created.

A . You must ensure that the SALES database is mounted or open. B . You must restore a backup control file to perform a block media recovery. C . You must take the tools01.dbf data file offline before you start a block media recovery. D . You must put the database in NOARCHIVELOG mode to perform a block media recovery. E . You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

A . You must configure block change tracking file B . You must have first level 1 backups for RMAN to restore blocks C . You must ensure that the SALES database is mounted or open D . You must have full or level 0 backups for RMAN to restore blocks E . You must take the tools01.dbf data file offline before you start a block media recovery

A . The user has dropped an important table that needs to be recovered. B . The database files are corrupted when the database is open. C . You are not able to start up the database instance because the required database files are missing. D . The archived log files are missing for which backup is not available.

A .  restore B .  repair C .  copy D .  recover E .  replace

A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

A .  UNTIL CANCEL B .  UNTIL SCN C .  UNTIL SEQUENCE D .  UNTIL TIME

A .  V$BACKUP_CORRUPTION B .  V$COPY_CORRUPTION C .  V$DATABASE_BLOCK_CORRUPTION D .  RC_BACKUP_CORRUPTION

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis.Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:1) Restore an autobackup of the server parameter file.2) Restore the control file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich option illustrates the correct sequence that you must use？（） A.8，1，3，2，4，5，7，6 B.1，8，3，4，2，5，7，6 C.1，3，4，2，8，5，6，7 D.1，3，2，4，6，5，7，8