Q28. A schema owner truncated a table in error and must recover the data.
Which Oracle Flashback feature could be used to recover the data?
- A. FLASHBACK TABLE
- B. FLASHBACK VERSION QUERY
- C. FLASHBACK DATABASE
- D. FLASHBACK TRANSACTION
- E. FLASHBACK DATA ARCHIVE
Answer: E
Ref:
19.9.6 DDL Statements on Tables Enabled for Flashback Data Archive
Flashback Data Archive supports only these DDL statements:
ALTER TABLE statement that does any of the following:
Adds, drops, renames, or modifies a column
Adds, drops, or renames a constraint
Drops or truncates a partition or subpartition operation
TRUNCATE TABLE statement
RENAME statement that renames a table
FLASHBACK TABLE: co the dc su dung voi dieu kien la phai tao restore point truoc do