High School

Write a command for the table "dogs" to delete the row where the id is 101.

A. DELETE FROM dogs WHERE id = 101
B. REMOVE FROM dogs WHERE id = 101
C. DROP FROM dogs WHERE id = 101
D. ERASE FROM dogs WHERE id = 101

Answer :

Final answer:

The correct SQL command to delete a row with an id of 101 from the 'dogs' table is 'DELETE FROM dogs WHERE id = 101'. The other options given are not valid SQL commands for this action.

Explanation:

The command to delete a row from the table dogs where the id is 101 is:

DELETE FROM dogs WHERE id = 101

This SQL command specifies that you want to delete records from the specified table, which in this case is 'dogs'. The WHERE clause is used to select the specific row to delete, where the id column matches the value 101. None of the other options provided (REMOVE, DROP, ERASE) are valid SQL commands for deleting a single row from a table.

Other Questions