Solved

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

Question 62

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


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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents