Multiple Choice
Contents of the BOOKS table
-Based upon the contents of the BOOKS table,which of the following will determine the number of books provided by publisher 3?
A) SELECT SUM(isbn)
FROM books
WHERE pubid = 3;
B) SELECT TOTAL(*)
FROM books
WHERE pubid = 3;
C) SELECT COUNT(pubid)
FROM books
WHERE pubid = 3;
D) none of the above
Correct Answer:

Verified
Correct Answer:
Verified
Q100: Columns used to group data in the
Q101: Which of the following is a valid
Q102: Group functions are also known as aggregate
Q103: If both nonaggregated and aggregated columns are
Q104: The _ function can be used to
Q106: The <u>VAR</u> function is used to determine
Q107: Group functions return one result per group
Q108: The _ function is used to calculate
Q109: The only group function that includes NULL
Q110: The VARIANCE function can be used with