Oracle Database 12c: Installation and Administration — Question 161

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

Answer options

• 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.

Correct answer: C

Explanation

Executing a TRUNCATE TABLE command on a table with Flashback Archiving enabled first archives the rows before truncating them, which is why option C is correct. Option A is incorrect because the operation does not fail; options B and D are incorrect as they misrepresent the behavior of truncation with archiving.