383.At the request of a user, you issue the following command to restore a dropped table:
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.
Answer: C
后来,用户通知您,表中的数据似乎是很旧、过时。这可能是什么问题?
C、以前的闪回删除操作已被执行,导致多个版本的表被存储在在回收站。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2123822/
,如需转载,请注明出处,否则将追究法律责任。