What is the key difference between DELETE and TRUNCATE in SQL?
Answer options
A
DELETE is DDL; TRUNCATE is DML
B
DELETE can have a WHERE clause; TRUNCATE removes all rows
C
DELETE is faster than TRUNCATE
D
TRUNCATE can be rolled back; DELETE cannot
Correct answer: DELETE can have a WHERE clause; TRUNCATE removes all rows
Explanation
Quick AnswerThe correct answer is DELETE can have a WHERE clause; TRUNCATE removes all rows because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.