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

　　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.