ocp-286

QUESTION NO: 286
Which of the following statements is true regarding implementing a Flashback Table recovery?

A. An SCN is never used to perform a Flashback Table recovery.
B. If a significant number of changes have been made to the table, row movement must be enabled.
C. The tablespace must be offline before performing a Flashback Table recovery. 执行闪回表恢复之
前表空间必须处于脱机状态。
D. Flashback Table recovery is completely dependent on the availability of undo data in the undo
tablespace.
Answer: D
Like the other Flashback options, Flashback Table must be able to find the necessary undo records in
order to recover. The use of SCNs is valid in Flashback Table; therefore option A is incorrect. Row
Movement must be enabled in all cases, not just when a significant number of changes have been made.
Therefore option B is incorrect. One of the main features of Flashback Table is that the tablespace can
remain online, so option C is incorrect.

---

关于执行闪回表恢复下面的哪个语句是正确的？

D.闪回表恢复是完全依赖于撤消表空间中的撤消数据的可用性。

闪回表与其他闪回选项一样，必须能够找到必要的撤销记录，以恢复SCN的使用是有效的闪回表，因此选项A是不正确的； 行移动必须启用在所有情况下，不只是当已取得
一个显著的变化，因此，选项B不正确。闪回表的主要特点之一是，表空间可以保持在线，因此选项C是不正确的。

---