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 

第1题：

In which scenario will you perform a user-managed incomplete recovery？（）

• A、 when a table is dropped and stored in the Recycle Bin
• B、when a table is dropped and purged from the Recycle Bin
• C、 when you are required to recover an existing table to its previous state
• D、 when you are required to view all the versions of a row of an existing table between a specific time period

第2题：

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

第3题：

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.

第4题：

In which situation are you NOT required to perform an incomplete recovery？（）

• A、 when all the control files are lost
• B、 when all the members of a redo log group are lost
• C、 when a table is dropped and purged from the Recycle Bin
• D、 when a temporary file of the default temporary tablespace is lost

第5题：

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

第6题：

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）  

• A、 Initiate an incomplete recovery operation using RMAN.
• B、 Copy the table from a development database.
• C、 Advise the user to rekey the data.
• D、 Perform a Flashback Drop operation.
• E、 Perform a Flashback Recovery operation.

第7题：

In which scenario will you perform an incomplete recovery？（）

• A、 when a table is dropped and stored in the Recycle Bin
• B、 when all the control files are deleted
• C、 when a member of a multiplexed redo log group is dropped
• D、 when you are required to recover a table to its previous state

第8题：

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

第9题：

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

第10题：

You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）

• A、 all the datafiles in the database
• B、 the datafiles associated with the SYSTEM tablespace
• C、 the datafiles associated with the DATA1 tablespace
• D、 all the datafiles in the database except those associated with the DATA1 tablespace