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:

Revenue Streams

The various sources from which a business earns money.

Loss-Leader Pricing

A pricing strategy where a product is sold at a price below its market cost to stimulate other profitable sales.

Pro Forma Income Statement

A financial statement that projects a company’s revenues, expenses, and net income for a specific period in the future, based on assumptions.

Sponsored Content

A type of advertising medium where content is created and placed for the purpose of promoting a product, service, or brand, designed to blend in with the platform's natural content.