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'

Question

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'

Quizplus · Accepted Answer

The Answer of 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'

Based on the Table Below, the SQL Statement That Changes