What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving
enabled?
A.
It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B.
The rows in the table are truncated without being archived.
C.
The rows in the table are archived, and then truncated.
D.
The rows in both the table and the archive are truncated.
Explanation:
You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK
TABLE statement to retrieve the contents of a table that has been truncated.
wrong answer.
A is correct.
i think is C
A: you cannot restore Data after Truncate.
I didn’t get the question rigth, i thought it asked if we can flashback truncated data..
I think B is a good answer.