Based on the Table Below, the SQL Statement That Changes

question 10

Multiple Choice

Based on the table below, the SQL statement that changes the address and city of customer 3175, Gregory Adams, to 1337 Parkway Ave and Pembrook, SD, 57462, respectively, is _____________________.
Customer table

• A) UPDATE Customer Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE FirstName = 'Gregory' AND LastName = 'Adams'
• B) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE FirstName = 'Gregory' AND LastName = 'Adams'
• C) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462' WHERE Name = 'Gregory Adams'
• D) UPDATE Customer SET Address = '1337 Parkway Ave', City = 'Pembrook', State = 'SD', Zip = '57462'

---

Definitions:

Cash Inflows

Money or funds coming into a company, from operations, investments, or financing activities.

Useful Life

The estimated duration of time that an asset is expected to remain productive or useful for its intended purpose.

Labor Savings

The reduction in the amount of labor (and consequently, labor costs) necessary to perform a particular task or produce a certain amount of goods or services.

Internal Rate

Typically referring to the internal rate of return (IRR), which is the discount rate that makes the net present value (NPV) of all cash flows from a particular project equal to zero.