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

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 (450) SELECT Balance WHERE CustName = 'Gonzales'; 
D)UPDATE CUSTOMER SET Balance = 450 WHERE CustName = 'Gonzales';

Quizplus · Accepted Answer

The correct SQL statement to increase the balance of the Gonzales account by $100 to a total of $450 is to update the Balance column in the CUSTOMER table using the following SQL statement:

UPDATE CUSTOMER
SET Balance = Balance + 100
WHERE CustName = 'Gonzales';

This will add $100 to the current balance of the Gonzales account and update it to $450. Option A is incorrect as the syntax is invalid and does not make sense. Option B is incorrect as it only inserts a new record with a Balance of $450, but does not update the existing record. Option C is incorrect as it is trying to insert a new record and select a value from the Balance column where the CustName is Gonzales, but the syntax is invalid.

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