Based on the Table Below, the SQL Statement That Changes

question 73

Multiple Choice

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'

---

Definitions:

Profit-Maximizing

The process by which a company determines the price and output level that generates the maximum profit.

Marginal Cost

The increased cost resulting from the production of one more unit of a product or service.

Revenue

The total income received by a business or organization from its normal business operations.

Cost

is the monetary valuation of effort, material, resources, time, and utilities consumed, goods or services produced, or other expenses incurred.