Multiple Choice
Based on the table below, the SQL statement that changes the last name of customer 3175 to Michael is _____________________.
Customer table
A) UPDATE Customer SET LastName = 'Michael' WHERE Customer_Number = 3175
B) UPDATE Customer SET Customer_Number = 3175 WHERE LastName = 'Michael'
C) UPDATE Customer table SET LastName = 'Michael' WHERE Customer_Number = 3175
D) UPDATE Customer SET FirstName = 'Susan' WHERE LastName = 'Michael'
Correct Answer:

Verified
Correct Answer:
Verified
Q3: Microsoft Access is an example of a:<br>A)Heavyweight
Q11: Oracle is an example of a:<br>A)Heavyweight Java
Q32: When you first get a result set
Q34: All database URLs have the format:<br>A)jdbc:subprotocol:driver-specific data<br>B)jdbc/subprotocol/driver/data<br>C)oracle.jdbc.driver.OracleDriver<br>D)c:\jdk1.7.0\db\lib\driver.jar
Q36: What will the following expression match to?<br>Name
Q43: To get the number of columns in
Q53: Based on the customer table below, which
Q58: You can use the generic _ method
Q64: Beginners are afraid of issuing complex SQL
Q74: What is one reason why you need