You are using Recovery wizard for performing incomplete reco

第1题：

You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process？（）

• A、 Database Identifier （DBID）
• B、 names and location of datafiles
• C、 names and location of control files
• D、 names and location of online redo log files

第2题：

You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

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

第3题：

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、 Whole database
• B、 Tablespaces
• C、 Datafiles
• D、 Archive logs
• E、 Redo logs

第4题：

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

• A、 incomplete recovery
• B、 complete recovery
• C、 recovery using the Flashback Database feature
• D、 recovery using the export/import utility

第5题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

• A、Reregistering the target database in recovery catalog
• B、Transporting the new tablespaces to the recovery catalog database
• C、Syncronizing the recovery catalog with the target database control file
• D、Performing a fresh backup of the target database to include the new data files in the catalog database

第6题：

You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

• A、 Reregistering the target database in recovery catalog
• B、 Transporting the new tablespaces to the recovery catalog database
• C、 Syncronizing the recovery catalog with the target database control file
• D、 Performing a fresh backup of the target database to include the new data files in the catalog database

第7题：

You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

• A、 UNTIL CANCEL
• B、 UNTIL SCN
• C、 UNTIL SEQUENCE
• D、 UNTIL TIME

第8题：

You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

• A、 The log sequence for the database will restart from 1.
• B、 The log sequence number will be written to the control file.
• C、 The log sequence number will be written to the datafile headers.
• D、 The log sequence number will be written to the initialization parameter file.

第9题：

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

• A、 by using the Flashback Database feature
• B、 by using RMAN incomplete recovery
• C、 by performing a user-managed incomplete recovery
• D、 by dropping and re-creating the index tablespace

第10题：

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