Contents of the PROMOTION Table​

question 131

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

---

Definitions:

Commitment

A pledge or promise to do something; the state of being dedicated to a cause, activity, or goal.

Compliance

Partial success of an influence attempt by a leader: The person makes a modest effort.

Resistance

The state that occurs when an influence attempt by a leader is unsuccessful: The target is opposed to carrying out the request and finds ways to either not comply or do a poor job.

Good-natured Kidding

Light-hearted teasing or joking among individuals in a friendly and well-intentioned manner.