Based on the Code Shown, Which Query Lists the Number

question 15

Multiple Choice

Based on the code shown, which query lists the number, name, and available credit for all customers with credit limits that exceed their balances???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A) SELECT CustomerNum, CustomerName AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
• B) SELECT CustomerNum, CustomerName, CreditLimit AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
• C) SELECT CustomerNum, CustomerName, Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
• D) SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;

---

Definitions:

Financial Calculator

A specialized calculator designed to perform financial functions including interest rates, payments, investment value calculations, and other financial metrics.

Present Value

The current equivalent value of a future stream of payments or a single financial sum, using a specific return rate.

Annuity

An economic tool that delivers a stable flow of income to an individual, commonly employed in retirement planning strategies.

Discount Rate

The interest rate used to discount future cash flows to their present values, often reflecting the cost of capital or risk.