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

question 69

Multiple Choice

Based on the tables below,which of the following SQL statements would increase the balance of the Gonzales account 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 (450) SELECT Balance WHERE CustName = 'Gonzales';
• D)UPDATE CUSTOMER SET Balance = 450 WHERE CustName = 'Gonzales';