Based on the Table Below, the SQL Statement That Changes

question 4

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:

Nutrition

The process by which living organisms obtain and process the nutrients necessary for maintaining health and promoting growth.

Obesity Rates

The percentage of a population that is classified as obese based on body mass index (BMI) measures, indicating a high level of body fat in relation to height.

Muscle

A tissue in the body composed of fibers capable of contracting to produce movement or maintain posture.

Fatty Tissue

Connective tissue in the body that stores fat, which can provide insulation and protection for organs and contribute to energy reserves.