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/，如需轉載，請註明出處，否則將追究法律責任。