SQL Functions, Grouping & Joins — Chapter Test

Answer all 5 questions, then submit. You need 60% to pass. Log in to save progress.

Question 1

Which function returns the number of rows?

ASUM()

BCOUNT()

CAVG()

DMAX()

Question 2

Which clause groups rows so an aggregate applies to each group?

AWHERE

BORDER BY

CGROUP BY

DHAVING

Question 3

To filter GROUPS using an aggregate condition, you use…

AWHERE

BHAVING

CORDER BY

DDISTINCT

Question 4

An equi-join is best described as…

AEvery row of A paired with every row of B

BA Cartesian product filtered by a matching-column condition

CJoining a table to itself

DSorting two tables

Question 5

What does a Cartesian product (CROSS JOIN) of a 3-row and a 2-row table produce?

A5 rows

B6 rows

C3 rows

D1 row