Contents of the PROMOTION table

-Based on the contents of the PROMOTION table,which of the following will correctly change the value assigned to the MAXRETAIL column for Free Shipping to 75.00?
A) INSERT INTO promotion (maxretail) VALUES (75) WHERE gift = 'FREE SHIPPING';
B) UPDATE promotion (maxretail) SET = 75 WHERE gift = 'FREE SHIPPING';
C) UPDATE promotion SET maxretail = 75 WHERE gift = 'FREE SHIPPING';
D) none of the above

Question

Contents of the PROMOTION table​
  ​
-Based on the contents of the PROMOTION table,which of the following will correctly change the value assigned to the MAXRETAIL column for Free Shipping to 75.00?​
A) ​INSERT INTO promotion (maxretail) VALUES (75) WHERE gift = 'FREE SHIPPING'; 
B) ​UPDATE promotion (maxretail) SET = 75 WHERE gift = 'FREE SHIPPING'; 
C) ​UPDATE promotion SET maxretail = 75 WHERE gift = 'FREE SHIPPING'; 
D) ​none of the above

Quizplus · Accepted Answer

To modify the value of an existing record in a table, we need to use the UPDATE statement with the SET keyword to specify the new value we want to assign to the column. The correct syntax is:
UPDATE table_name
SET column_name = new_value
WHERE condition; 
In this case, the table name is "promotion", the column name is "maxretail", the new value is 75, and the condition specifies that we only want to modify the record where the gift is "FREE SHIPPING". Therefore, choice C is the correct one. Choices A and B are incorrect because INSERT is used to add new records to the table, not modify existing ones, while SET is missing the column name. Choice D is incorrect because we need to update the MAXRETAIL column, not any other column in the table.

Contents of the PROMOTION Table​

Contents of the PROMOTION Table