Beginner
Database Management Systems
Q25 / 100
What is the difference between TRUNCATE and DELETE?
Correct! Well done.
Incorrect.
The correct answer is B) TRUNCATE removes all rows quickly without logging individual rows and cannot be rolled back easily; DELETE removes rows with WHERE clause support and is fully logged
B
Correct Answer
TRUNCATE removes all rows quickly without logging individual rows and cannot be rolled back easily; DELETE removes rows with WHERE clause support and is fully logged
Explanation
TRUNCATE is DDL (not DML), resets the table to empty quickly (minimal logging), and cannot fire row-level triggers. DELETE is DML, supports WHERE, fires triggers, and is fully transactional.
Progress
25/100