Multiple choice technology databases

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

  1. COLLAPSE

  2. REMOVE

  3. DELETE

  4. TRUNCATE
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The DELETE statement is the standard SQL command used to remove rows from a table. TRUNCATE also removes data but is a DDL command that resets the table, while REMOVE and COLLAPSE are not standard SQL keywords for data deletion.

Keep practicing — related questions