Multiple choice sql

Which SQL statement is used to delete data from a database?

  1. TRUNCATE

  2. DELETE

  3. REMOVE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DELETE is the standard SQL DML statement for removing rows from a table, optionally with a WHERE clause for selective deletion. TRUNCATE also removes data but is a DDL operation that clears all rows at once and cannot be rolled back in some databases.

AI explanation

Correct answer: DELETE. The SQL DELETE statement removes rows from a table based on a WHERE condition (or all rows if omitted), logging each row deletion. TRUNCATE also removes data but is a DDL-like operation that clears an entire table without row-by-row logging or WHERE support, and REMOVE is not a valid SQL keyword at all.

Keep practicing — related questions