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.
Correct answer is C,D,E.
I think none of the above is a correct answer.
DDL Statements Not Allowed on Tables Enabled for Flashback Data Archive
Using any of the following DDL statements on a table enabled for Flashback Data Archive causes error ORA-55610:
ALTER TABLE statement that does any of the following:
Drops, renames, or modifies a column
Performs partition or subpartition operations
Converts a LONG column to a LOB column
Includes an UPGRADE TABLE clause, with or without an INCLUDING DATA clause
DROP TABLE statement
RENAME TABLE statement
TRUNCATE TABLE statement
What is your Oracle Database Release?
Answer D does look correct, given Kelvin’s list.
Adding a column is not listed as causing ora-55610. All others are.
Reference link for his list is: http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#BJFJHDAG
Oracle Database 11g R2
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS640
Correct Answer is C,D,E
Transparent Schema Evolution
– Add, drop, rename, and modify column
– Drop and truncate partition
– Rename and truncate table
• Flashback queries work across DDL changes.
• All other DDL is not automatically supported
Referred to the 11g R2 documents :
C,D,E are correct .
11g R2 (11.2)
C,D,E
11g R2 (11.1) VERSION OF THE TEST:
The following DDL operations change the structure of a table, so that you cannot subsequently use the TO SCN or TO TIMESTAMP clause to flash the table back to a time preceding the operation: upgrading, moving, or truncating a table; adding a constraint to a table, adding a table to a cluster; modifying or dropping a column; changing a column encryption key; adding, dropping, merging, splitting, coalescing, or truncating a partition or subpartition (with the exception of adding a range partition).
So you CAN ADD a column: D