Multiple Choice
Consider the following SQL query.Which item best describes the results of the query?SELECT VendorID,Sum(POTotal) FROM [Purchase Orders]GROUP BY VendorID
A) Displays all purchase order lines for all vendors.
B) Adds new purchase order information to the purchase orders table.
C) Displays the vendor ID and all purchase order totals in the purchase orders table.
D) Displays the vendor ID and the sum of all purchase order totals for that vendor.
Correct Answer:

Verified
Correct Answer:
Verified
Q7: Which of the following tasks cannot be
Q8: Classes in a relational database model for
Q9: A Query in a program language such
Q10: Which of the following about SQL is
Q11: Which of the following items does not
Q13: Which of the following is not one
Q14: A foreign key in a database table
Q15: Which set of multiplicities correctly shows the
Q16: Which set of multiplicities correctly shows the
Q17: In Access,users can edit database information in