Which of the following SQL commands changes the value in the column LAST_NAME within the row containing a REP_ID of 007?
A) UPDATE SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';
B) CHANGE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007';
C) REPLACE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007';
D) INSERT SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';

Question

Quizplus · Accepted Answer

The correct SQL command to update a value in a column for a specific row based on a condition is the UPDATE statement followed by the SET clause. The WHERE clause specifies the condition that must be met, in this case, where REP_ID equals '007'.

Which of the Following SQL Commands Changes the Value in the Column