Multiple choice general knowledge math & puzzles

The command to remove rows from a table 'CUSTOMER' is:

  1. REMOVE FROM CUSTOMER …

  2. DROP FROM CUSTOMER …

  3. DELETE FROM CUSTOMER WHERE …

  4. UPDATE FROM CUSTOMER …

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

DELETE FROM is the correct SQL command to remove rows. The syntax requires specifying the table and optionally a WHERE clause. DROP removes entire tables, UPDATE modifies data, and REMOVE is not a valid SQL command.