Multiple Choice
What will be returned when the following SQL statement is executed? Select driver_no,count(*) as num_deliveries
From deliveries
Group by driver_no;
A) A listing of all drivers, sorted by driver number
B) A listing of each driver as well as the number of deliveries that he or she has made
C) A count of all of the deliveries made by all drivers
D) An error message
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The FROM clause is the first statement
Q10: SQL originated from a project called System-S.
Q26: A _ view is materialized when referenced.<br>A)
Q27: Discuss the pros and cons of using
Q30: The following query totals sales for each
Q34: An insert command does not need to
Q48: Adding the DISTINCT keyword to a query
Q52: The views are created by executing a
Q55: A view may not be updated directly
Q92: The first in a series of steps