Question Details

Detailed explanation and options for the selected question.

What is the difference between DELETE and TRUNCATE in SQL?

A. DELETE removes specific rows; TRUNCATE removes all rows
B. DELETE removes all rows; TRUNCATE removes specific rows
C. DELETE removes a table structure; TRUNCATE does not
D. DELETE modifies table structure; TRUNCATE does not

Explanation:

DELETE removes specific rows based on a condition, while TRUNCATE removes all rows but retains the table structure.