Examveda

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

A. REMOVE FROM CUSTOMER ...

B. DROP FROM CUSTOMER ...

C. DELETE FROM CUSTOMER WHERE ...

D. UPDATE FROM CUSTOMER ...

Answer: Option C

Solution (By Examveda Team)

Option A: REMOVE FROM CUSTOMER ... - There is no SQL command called REMOVE. This option is incorrect.
Option B: DROP FROM CUSTOMER ... - The DROP command is used to remove entire tables or other database objects, not rows from a table. This option is incorrect.
Option C: DELETE FROM CUSTOMER WHERE ... - The DELETE command in SQL is used to remove rows from a table. You specify the table name (CUSTOMER) and use WHERE clause to specify which rows to delete based on a condition.
Option D: UPDATE FROM CUSTOMER ... - The UPDATE command is used to modify existing rows in a table, not to remove rows. This option is incorrect.
Conclusion:
To remove rows from a table 'CUSTOMER' in SQL, you use the DELETE statement with a WHERE clause to specify the condition for deletion. Therefore, the correct answer is Option C: DELETE FROM CUSTOMER WHERE ....

This Question Belongs to Database >> Introduction To SQL

Join The Discussion

Related Questions on Introduction to SQL

The SQL WHERE clause:

A. limits the column data that are returned.

B. limits the row data are returned.

C. Both A and B are correct.

D. Neither A nor B are correct.