The TRUNCATE command writes user data to Rollback segments
-
True
-
False
Reveal answer
Fill a bubble to check yourself
B
Correct answer
Explanation
TRUNCATE is a DDL (Data Definition Language) command that removes all rows without logging individual row deletions. It does not write user data to rollback segments, unlike DELETE which logs each row for potential rollback. This is why TRUNCATE cannot be rolled back.
AI explanation
TRUNCATE is a DDL statement that deallocates the data pages/extents of a table directly rather than deleting rows one at a time. Because it doesn't log individual row deletions, it does not write the removed data to rollback (undo) segments, which is also why a TRUNCATE cannot be rolled back once committed. This is the key distinction from DELETE, which does log to rollback segments and can be undone.