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

Verified
Correct Answer:
Verified
Q64: One advantage of using the CONSTRAINT phrase
Q65: When the correct SQL command is used
Q66: According to the SQL-92 standard,statements used to
Q67: If a trigger is being written to
Q68: SQL triggers are created using _.<br>A)the SQL
Q70: One advantage of using the CONSTRAINT command
Q71: What are SQL triggers and how are
Q72: To set a column value to an
Q73: SQL triggers use the ANSI SQL keywords
Q74: The values in an SQL view are