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
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
Correct Answer:
Verified
Q20: SQL triggers are used for _.<br>A)validity checking<br>B)providing
Q28: The SQL keyword MODIFY is used to
Q39: To set a column value to an
Q40: The SQL keyword UNIQUE is used to
Q47: Unless it is being used to copy
Q64: SQL views are always updateable when _.<br>A)the
Q87: Because SQL stored procedures allow and encourage
Q92: A set of SQL statements stored in
Q97: An SQL virtual table is called _.<br>A)a
Q98: Which SQL statement is used to retrieve