Contents of the PROMOTION Table​

Multiple Choice

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