Match each aggregate function with the value it returns:
I. Avg
II. Count
III. Maximum
IV. Minimum
V. Sum
A. Returns the data item with the highest value
B. Returns the data item with the lowest value
C. Returns the mean value of a group of numbers
D. Returns the total value of a column of numbers
E. Returns the number of fields containing data
C, E, A,B, D
You might also like to view...
After cleaning off a virus and some malware, the computer still is not functioning correctly. The user does have a fairly recent version of data on the computer. Which of the following would be best to use to reset the computer to the condition it was in when it was purchased?
A) ZIP B) Recovery Console C) Factory restore disc D) Imaging software
A laptop user is complaining about typing on their new laptop. They claim that the cursor jumps randomly from place-to-place. What might be the cause of this?
A. The user needs to update a driver for the keyboard B. The user should use sticky keys C. The user should replace the keyboard D. The user should disable the touch pad.