You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table
after enabling Flashback Data Archive?
A.
Drop the table.
B.
Partition the table
C.
Truncate the table.
D.
Add a column to the table.
E.
Rename a column in the table.
Explanation:
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 Data Archive does not support DDL statements that move, split, merge, or coalesce partitions or
subpartitions, move tables, or convert LONG columns to LOB columns.