单选题You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command：   RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS；   After configuring the recovery 

第1题：

If you have any questions, please feel free to interrupt at any time. This sentence means if you have something that you don’t understand, you can make a break in at any time.

A对

B错

第2题：

The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）

• A、 a list of all those files that have been deleted in the last two days
• B、 a list of all those files that have been recovered within the last two days
• C、 a list of all the expired backups and copies
• D、 a list of backups and copies that are outside the range covered by the current retention policy

第3题：

第4题：

You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

• A、 multiplexed control files
• B、 RMAN obsolete backups
• C、 multiplexed online redo log files
• D、 archived redo logs that have not been copied to tape

第5题：

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.

第6题：

If you have any questions, please feel free to interrupt at any time. This sentence means if you have something that you don’t understand, you can make a break in at any time.

第7题：

In which scenario will you use the Flashback Transaction Query feature？（）

• A、 when you want to restore an important table that is dropped from the Recycle Bin
• B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
• C、when you want to restore a dropped user’s schema
• D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

第8题：

第9题：

If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）

• A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
• B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
• C、 The next time you connect RMAN to just the recovery catalog
• D、 The next time you connect to the recovery catalog and the target database with RMAN
• E、 Connecting to the recovery catalog and issuing the resync all databases command

第10题：

The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

• A、time­based recovery
• B、log sequence recovery
• C、cancel­based recovery
• D、change­based recovery