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;
Correct Answer:

Verified
Correct Answer:
Verified
Q3: Which function calculates the number of records
Q4: Which of the following SQL commands sorts
Q5: What are five restrictions placed on table
Q6: SQL uses an on-screen form to create
Q7: Why is SQL a highly sought-after language
Q9: What SQL command can you use to
Q10: When you use a name containing a
Q11: Based on the table description and SQL
Q12: Which of the following is currently considered
Q13: In a query that uses an aggregate