Oracle OCP 1Z0-053 Q385(Flashback Table Recovery)

385.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


参考：https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9012.htm

Purpose

Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system. Also, Oracle Database cannot restore a table to an earlier state across any DDL operations that change the structure of the table.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8520577/viewspace-2062546/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8520577/viewspace-2062546/