Q55
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 ...
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
The command to remove rows from a table in SQL is DELETE FROM CUSTOMER WHERE .... Option D is the correct choice for deleting rows from the 'CUSTOMER' table based on specific conditions specified in the WHERE clause. Options A, B, and C do not represent the standard SQL syntax for removing rows.