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
correct answer is CDE.
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 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.
For example, the following DDL statements cause error ORA-55610 when used on a table enabled for Flashback Data Archive:
•ALTER TABLE statement that includes an UPGRADE TABLE clause, with or without an INCLUDING DATA clause
•ALTER TABLE statement that moves or exchanges a partition or subpartition operation
•DROP TABLE statement
If you must use unsupported DDL statements on a table enabled for Flashback Data Archive, use the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure to disassociate the base table from its Flashback Data Archive. To reassociate the Flashback Data Archive with the base table afterward, use the DBMS_FLASHBACK_ARCHIVE.REASSOCIATE_FBA procedure.
https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS640