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
Q14: The DESCRIBE TABLE command defines a SQL
Q15: To display all the rows and columns
Q16: What special value is used in SQL
Q17: In SQL Server, you can execute the
Q18: Pete would like to set up a
Q20: Jesse has written some commands in MySQL
Q21: How can you correct errors in data?
Q22: When a script file contains more than
Q23: Which statement about changing the default database
Q24: What are a script file and a