Based on the Tables Below,which of the Following SQL Statements

question 63

Multiple Choice

Based on the tables below,which of the following SQL statements would increase the balance of the Gonzales by $100 to a total of $450? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

• A)SELECT Gonzales FROM CUSTOMER INSERT VALUES PLUS (100)INTO Balance;
• B)SELECT Gonzales FROM CUSTOMER INSERT VALUES (450)INTO Balance;
• C)INSERT INTO CUSTOMER VALUES PLUS (100) SELECT Balance WHERE CustName = 'Gonzales';
• D)INSERT INTO CUSTOMER VALUES (450) SELECT Balance WHERE CustName = 'Gonzales';
• E)UPDATE CUSTOMER SET Balance = 450 WHERE CustName = 'Gonzales';

---

Definitions:

Serial Cohabitation

The practice of living with multiple romantic partners in succession, without being married, over a person’s lifetime.

Serial Monogamy

A succession of monogamous (exclusive) relationships.

Open Marriage

A marriage in which the partners agree that each may engage in sexual relationships with other people.

Singles World

The social scene or lifestyle of individuals who are not in a marriage or romantic relationship.