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.

相关问题推荐

• While performing the backup of the flash recovery area， you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files.  What implications does it have on the backup of the flash recovery area？（）  

  A、 The backup fails because one of the archived redo log files is missing.

  B、 The backup succeeds but it would be without the missing archived log.

  C、 During backup，you are prompted for the alternative destination for the missing archived redo log file.

  D、 The backup succeeds because it fails over to one of the alternative archived redo log destinations.

  查看答案

• 某IP网络连接如下图所示，主机PC1发出一个全局广播消息，无法收到该广播消息的是(32)。

  

  A．PC2

  B．PC3

  C．PC4

  D．PC5

  查看答案

• Which of the following methods can be used to detect block corruption？（）  

  A、 ANALYZE operations

  B、 dbv

  C、 SQL queries that access the potentially corrupt block

  D、 RMAN

  E、 All of the above

  查看答案

• 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 number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）

  A、 Perform Export before TSPITR and Import after TSPITR

  B、 Move objects to another schema that has the same tablespace assigned

  C、 Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）

  D、 Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）

  查看答案

• 采用CRC进行差错校验，生成多项式为G(X)=X4+X+1，信息码字为10110，则计算出的CRC校验码是(18)。

  A．0000

  B．0100

  C．0010

  D．1111

  查看答案