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

question 24

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

---

Definitions:

Basilar Membrane

A key structure in the cochlea of the inner ear that oscillates in response to sound, playing a critical role in the perception of sound.

Internal Senses

Refers to the body's ability to sense its own physiological condition, encompassing sensations like hunger, thirst, and the need for sleep.

Viscera

The internal organs in the main cavities of the body, especially those within the abdominal cavity.

Taste Buds

Sensory organs located on the tongue and other parts of the mouth, which are responsible for detecting the five elements of taste perception: sweetness, sourness, saltiness, bitterness, and umami.