The command would be used to delete the table row where the P_CODE is 'BRT-345'.
A)DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';
B)REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345';
C)ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345';
D)ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345';

Question

Quizplus · Accepted Answer

The correct command to use when deleting a row from a table is DELETE FROM. In this case, we want to delete the row where the P_CODE equals 'BRT-345', so we include that condition in the WHERE clause. Option B is not a valid SQL command, while options C and D are not appropriate for deleting rows from a table.

The Command Would Be Used to Delete the Table Row