Based on the Code Shown, Which Query Lists the Number

question 34

Multiple Choice

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

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

---

Definitions:

Credibility

The quality or attribute of being trusted and believed in, often based on a reputation for honesty, reliability, and competence.

Clip Art

Pre-made images or illustrations that can be used for various purposes, including in documents or presentations to enhance visual appeal.

Copyrighted

The legal right granted to the creator of an original work exclusive rights to its use and distribution, usually for a limited time, with the aim of enabling the creator to receive compensation for their intellectual property.

Aesthetic Appeal

The quality of being visually pleasing or beautiful in appearance.