Based on the SQL Shown, Which Query Lists the Name

question 8

Multiple Choice

Based on the SQL shown, which query lists the name and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000? Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
• B)SELECT CustomerName, Balance FROM Customers WHERE Balance > 2000;
• C)SELECT Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
• D)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 OR 5000;

---

Definitions:

Sensation Seeking

The trait of searching for experiences and feelings that are varied, complex, novel, and intense.

Zuckerman

Refers to Marvin Zuckerman, a psychologist known for his research on sensation seeking and its influence on personality and behavior.

Questionnaires

A set of printed or digital questions used for gathering information from respondents for research purposes.

Locus of Control

The degree to which people believe they have control over the outcome of events in their lives, as opposed to external forces having that control.