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 is the UPDATE statement followed by the SET clause to specify the column and new value, and the WHERE clause to specify which row(s) to update.

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