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 constraintDrops 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.
D is the correct answer, you are quoting from 12c documentation
For 11g:
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5009.htm#SQLRF20008
You are quoting 11.1. Exam is validated against 11.2.
The correct answers are C, D, E.
Source: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS640
“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”