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:

Self-Reporting Instruments

Tools or questionnaires used for gathering data where participants report their own feelings, behaviors, or attitudes.

Communicable Diseases

Diseases that can be transmitted from one person to another, either directly through contact or indirectly through vectors.

Transmission

The act or process by which something is spread or passed from one person or thing to another.

Illnesses

Conditions that impair normal functioning, typically manifested by distinguishing signs and symptoms.