Multiple choice technology databases

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

  1. REMOVE

  2. COLLAPSE

  3. DELETE

  4. REMOVE ALL

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DELETE is the SQL statement used to remove rows from database tables. You can delete specific rows using a WHERE clause or all rows (without WHERE). REMOVE, COLLAPSE, and 'REMOVE ALL' are not valid SQL keywords for deleting data.