Multiple choice technology programming languages

Delete is faster than Truncate.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE is faster than DELETE because it simply deallocates data pages without logging individual row deletions. DELETE logs each row deletion for rollback capability, making it slower. TRUNCATE is a DDL operation that resets the table, while DELETE is a DML operation that removes rows one by one.