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 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';

Question

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 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';

Quizplus · Accepted Answer

To increase the balance of the Gonzales account by $100 to a total of $450, we need to update the existing balance of $350. The correct SQL statement to do so is the UPDATE statement, which allows us to modify existing rows in a table. Specifically, we need to update the Balance column of the CUSTOMER table for the row where the CustName is 'Gonzales'. Therefore, option E is the correct choice. The other options either have syntax errors or do not make sense in the context of the question.

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