Multiple Choice
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';
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions