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.
I would go with E, not D. The drop already occurred. Recovery is needed.
D is correct.
refer here
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm