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:

Attribute

A quality or characteristic given to a person, group, or some other thing.

University's Database

A structured collection of data or information that pertains to the operations, students, faculty, and resources of a university.

Instance

A specific realization or example of an abstract concept, such as an occurrence of a class in programming or a particular event.

Relational Table

A structured format to store data in rows and columns, allowing for the relationship between different types of data.