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';
Correct Answer:
Verified
Q39: SQL triggers can be used with SQL
Q43: When a trigger is fired,the DBMS makes
Q51: If the table PRODUCT has a column
Q53: The SQL keyword used to limit column
Q57: Which SQL keyword is used to change
Q58: One advantage of using the CONSTRAINT phrase
Q61: SQL views are always updateable when _.
A)the
Q62: When the correct SQL command is used
Q63: Which SQL keyword is used to add
Q71: Which SQL keyword is used to change
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents