Based on the Code Shown, Which Query Lists the Number

question 30

Multiple Choice

Based on the code shown, which query lists the number, name, street, and credit limit of all customers? The records are ordered by customer name within descending credit limit.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A) SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit DESC, CustomerName ;
• B) SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit ASC, CustomerName ;
• C) SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;
• D) SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit ASC, CustomerName ;

---

Definitions:

Current Liabilities

Obligations or debts that a company expects to pay or settle within one year or its operating cycle, whichever is longer.

Current Assets

Assets that a company expects to convert into cash, sell, or consume within one year or its operating cycle, whichever is longer.

Price-Earnings Ratio

A valuation ratio of a company's current share price compared to its per-share earnings, used to evaluate the relative value of company shares.

Market Price

The current price at which an asset or service can be bought or sold.