Home » MCQs » SQL MCQs » SQL Table MCQs

What is the difference between DELETE and TRUNCATE statements?

9. What is the difference between DELETE and TRUNCATE statements?

1. DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
2. DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
3. DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
4. DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.

Answer: B) DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table

Explanation:

DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.