TruKKer Principal Engineer Interview Questions and Answers

Difference between SQL DELETE and TRUNCATE

• DELETE is a DML command while TRUNCATE is a DDL command

• DELETE removes specific rows from a table while TRUNCATE removes all rows

• DELETE can be rolled back while TRUNCATE cannot be rolled back

• DELETE is slower than TRUNCATE as it logs each row deletion