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 SQL statement that changes the last name of customer 3175 to Michael would be an UPDATE statement that specifies the Customer table and sets the LastName column to 'Michael' for the row where the Customer_Number column equals 3175. The correct statement would be: UPDATE Customer SET LastName = 'Michael' WHERE Customer_Number = 3175. Option B changes the Customer_Number column to 3175 for the row where the LastName column equals 'Michael', which does not accomplish the desired task. Option C is incorrect syntax because "Customer table" should not be included in the statement. Option D changes the FirstName column to 'Susan' for any row where the LastName column equals 'Michael', which is not what was requested.

Based on the Table Below, the SQL Statement That Changes