ocp-284

最新推荐文章于 2021-04-10 00:51:42 发布

翻译最新推荐文章于 2021-04-10 00:51:42 发布 · 1.2k 阅读

文章标签：

#command #oracle11g

OCP-1Z0-053 专栏收录该内容

674 篇文章

订阅专栏

本文探讨了使用闪回删除操作时可能导致的数据过时问题，解释了问题可能的原因并提供了解决方案。

QUESTION NO: 284
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

根据用户的请求，你发出以下命令来还原删除的表： 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? 后来，用户通知您，表中的数据似乎是很旧、过时。这可能是什么问题？