Which 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

Which 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';

Quizplus · Accepted Answer

The correct command to delete a row in SQL is "DELETE FROM". The syntax requires specifying the table name, followed by "WHERE" clause that specifies the condition to be applied to identify the row to delete. in this case, the condition is "P_CODE = 'BRT-345'". Options B, C, and D are not valid SQL commands.

Which Command Would Be Used to Delete the Table Row