Multiple Choice
What will be returned when the following SQL query is executed?
SELECT driver_no, COUNT(*) as num_deliveries
FROM deliveries
GROUP BY driver_no
HAVING COUNT(*) > 2;
A) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries
B) A listing of all drivers
C) A listing of the number of deliveries greater than 2
D) A listing of all drivers who made more than 2 deliveries
Correct Answer:

Verified
Correct Answer:
Verified
Q45: Expressions are mathematical manipulations of data in
Q46: What result set will the following query
Q47: Indexes are created in most RDBMSs to:<br>A)
Q48: Adding the DISTINCT keyword to a query
Q49: Which of the following counts ONLY rows
Q51: A single value returned from an SQL
Q52: The views are created by executing a
Q53: What does the following SQL statement do?
Q54: What were the original purposes of SQL,
Q55: A view may not be updated directly