At the request of a user, you issue the following command to restore a dropped table:
SQL> flashback table “BIN$F2JFfMq8Q5unbC0ceE9eJg==$0” to before drop;
Later, the user notifies you that the data in the table seems to be very old and out of date.
What might be the problem?
A.
Because a proper range of SCNs was not specified, the wrong data was restored.
B.
A proper range of timestamps was not specified, so the wrong data was restored.
C.
A previous Flashback Drop operation had been performed, resulting in multiple versions
of the table being stored in the Recycle Bin.
D.
Either option A or B could be correct. Not enough information was provided to determine
which.
E.
None of the above.
The option C makes no sense, unless it’s supposed to be:
A previous Drop operation had been performed, resulting in multiple versions
of the table being stored in the Recycle Bin.
Then there qould be more than one version of the table in the recycle bin, and maaaaybe the oldest version was the one restored.
Otherwise the answer should be E
@noe, I agree, you hit the nail on the head.
“BIN$F2JFfMq8Q5unbC0ceE9eJg==$0” is probably the RECYCLEBIN name of an older version of the table that was dropped sometime ago.
like @noa says …
Otherwise the answer should be E
this question is also in the book
http://muhammad-asif-dba.blogspot.com.es/2015/02/download-oracle-12c-ocp-upgrade-exam.html
Here is the answer given
E. A Flashback Drop operation restores dropped objects from the Recycle Bin. It does not use SCN or timestamp ranges, so options A, B, and D are incorrect. Also, Flashback Drop operations don’t create objects in the Recycle Bin (they move them out of the Recycle Bin), so C is incorrect. The likely cause is that multiple versions of the table existed in the Recycle Bin and the wrong one was restored.
Please ignore the “source” I have given for the question and answer above, as I cannot determine exactly where I got it.
the right answer would be that the developer gave you the wrong version.
IMHO the right answer may be: “The user restored the wrong table”.
C doesn’t have sense