Multiple Choice Quiz


1	A function that calculates the lowest value in the column is called
		A)	the Sum function
		B)	the Avg function
		C)	the Max function
		D)	the Min function


2	A function that calculates statistical standard deviation is called
		A)	the Sum function
		B)	the StDev function
		C)	the Avg function
		D)	the Var function


3	You almost never sum
		A)	columns
		B)	ID values
		C)	rows
		D)	averages


4	When designing an aggregation query you must be careful to
		A)	decide what the question requires
		B)	understand the question
		C)	A and B
		D)	Neither A nor B


5	If the ID column is the primary key
		A)	it will never contain missing data
		B)	it will always contain missing data
		C)	there are times when it can contain missing data
		D)	B and C


6	When you want to identify the grouped columns use the
		A)	where notation
		B)	ending column notation
		C)	run query notation
		D)	group By notation


7	In aggregation queries most of the criteria (except dates) gets applied
		A)	both before and after the totals or counts have been computed
		B)	before the totals or counts have been computed
		C)	after the totals or counts have been computed
		D)	None of the above


8	A query can display
		A)	either detail rows or subtotals – not both
		B)	both detail rows and subtotals
		C)	detail rows never subtotals
		D)	subtotals never detail rows


9	A parameter query can be designed to
		A)	display a specific value for each parameter
		B)	display calculations for the columns
		C)	ask for more than one piece of information
		D)	create straightforward values


10	Parameter queries can be used as the basis for
		A)	forms
		B)	data access pages
		C)	reports
		D)	All of the above

2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.