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

question 69

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

---

Definitions:

Quest for Achievements

The pursuit or endeavor to attain goals, success, or particular standards of excellence.

Yerkes-Dodson Law

The Yerkes-Dodson Law suggests that there is an optimal level of arousal for performance, where too little or too much arousal can decrease performance efficiency.

Stress Level

The degree of tension or anxiety experienced by an individual or group.

Performance Benefits

The advantages gained from improved performance, such as increased productivity, higher quality of work, enhanced reputation, and potential financial rewards.