Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large numbe

第1题：

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

• A、flash back the database
• B、perform point-in-time recovery
• C、perform a full database recovery
• D、drop and re-create the tablespace
• E、use Recovery Manager （RMAN） to recover the database

第2题：

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）

• A、Complete Recovery with online redo log
• B、Complete Recovery with archived redo log
• C、Tablespace Point-in-Time Recovery (TSPITR)
• D、Incomplete Recovery with system change number (SCN)

第3题：

To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

• A、OPEN
• B、MOUNT
• C、NOMOUNT
• D、CLOSE

第4题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

• A、 ONLINE
• B、 REVERSE
• C、 PARALLEL
• D、 COMPRESS
• E、 NOLOGGING
• F、 COMPUTE STATISTICS

第5题：

You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

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

第6题：

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

• A、You find that one of the redo log members in each redo log group is lost.
• B、You find that a data file that belongs to the USERS tablespace is damaged.
• C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
• D、You find that the current redo log group is damaged and is not available for recovery.
• E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

第7题：

Why should you back up a duplicated tablespace after a TSPITR is complete？（）  

• A、 The tablespace cannot be duplicated or restored to any point in time after the duplication. 
• B、 The tablespace cannot be duplicated or restored to the point in time before the duplication. 
• C、 The entire database cannot be restored after a TSPITR， so a backup is required.
• D、 You cannot bring the tablespace online until its been backed up.
• E、 There is no requirement to do so， as RMAN will back up the tablespace after the TSPITR.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

• 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

第14题：

Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

• A、 The target database must be in NOARCHIVELOG mode.
• B、 No backup is required of the database before you perform a TSPITR.
• C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
• D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
• E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

第15题：

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

• A、Open the database in NORMAL mode
• B、Open the database in read-only mode
• C、Open the database in RESTRICTED mode
• D、Open the database with the RESETLOGS option

第16题：

An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace：   1. You log on to Enterprise Manager as SYSDBA.    2. You select the maintenance screen.    3. You choose Perform Recovery option on the maintenance screen.    4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen.    6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen.    7. You click the continue button.    An information screen appears saying that the database is unavailable. What is this information screen？（）

• A、Recovery Manager
• B、Recovery Window
• C、Recovery Wizard
• D、Enterprise Manager Home Page

第17题：

You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

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

第18题：

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

第19题：

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

• A、 You cannot perform the TSPITR with the constraints enabled.
• B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.
• C、 You can perform TSPITR only on the USERS tablespace.
• D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.
• E、 The TSPITR will only be successful if the constraint is enabled.

第20题：

第21题：

第22题：

第23题：