Multiple Choice
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';
Correct Answer:

Verified
Correct Answer:
Verified
Q5: Rows in a table can be changed
Q20: SQL triggers are used for _.<br>A)validity checking<br>B)providing
Q21: The following database will be used in
Q25: Given the SQL statement<br>CREATE TABLE SALESREP (<br>SalesRepNo
Q26: Which of the following is an SQL
Q28: Which SQL keyword is used to name
Q29: Which SQL keyword is used to change
Q36: A stored program that is stored within
Q59: The SQL command SELECT is used to
Q100: The SQL Server DBMS supports the SQL