Question

The command to remove rows from a table ‘CUSTOMER’ is __________________

(a) DROP FROM CUSTOMER

(b) UPDATE FROM CUSTOMER

(c) REMOVE FROM CUSTOMER

(d) DELETE FROM CUSTOMER WHERE

This question was posed to me in exam.

The query is from Basic SQL in division Laying the Foundation of SQL Server

Answer 1

Correct choice is (d) DELETE FROM CUSTOMER WHERE

For explanation I would say: The SQL DELETE Query is used to delete the existing records from a table. You can use WHERE clause with the DELETE query to delete selected rows.