Truncate vs Delete

What is the difference between TRUNCATE and DELETE in SQL?

Asked in the Technical Phone Screen stage. SQL DDL vs DML commands.

Output

1. Explain the difference in how each command removes rows.
2. Explain the difference in transaction behavior and rollback support.
3. Explain the difference in identity or sequence handling.
4. Explain any restrictions that affect when each command can be used.