What might be the problem?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *