Match the following aggregate functions with what they compute:

I. Avg
II. Sum
III. Count
IV. Min
V. Max

A. Counts the number of values in a column
B. Average of a column
C. Returns the lowest value
D. Returns the highest value
E. Totals the items in a column


B, E, A, C, D

Computer Science & Information Technology

You might also like to view...

List four situations that make the use of questionnaires appropriate.

What will be an ideal response?

Computer Science & Information Technology

Create an application that allows the user to inventory DVDs. Users input the title of the DVD and bonus materials and that information is stored in an object. The GUI is provided for you (Fig. 18.43). You will create a class (DVDInfo) to represent the DVD object and another class (BonusInfo) to represent bonus materials for a DVD object such as the movie’s trailer.


a) Copying the template to your working directory. Copy the C:Examples Tutorial18ExercisesDVDInventory directory to your C:SimplyJava directory.
b) Opening the Command Prompt window and changing directories. Open the Com- mand Prompt window by selecting Start > Programs > Accessories > Command Prompt. Change to your working directory by typing cd C:SimplyJavaDVD- Inventory.
c) Opening the template files. Open the DVDInventory.java, DVDInfo.java and
BonusInfo.java files in your text editor.
d) Creating the BonusInfo class. View the BonusInfo class. Add code to this class so that its objects will each represent one bonus material item on the DVD. Each BonusInfo object should have a name (name) and a length (itemLength). Use this tutorial’s CookingTime class as your guide in creating the get and set methods for the name and length of each bonus material. Have your set methods truncate a name
longer than twenty characters and set the minutes of a

Computer Science & Information Technology

When a task is ________ in Project 2013's Entry table, the task moves to the left, making it a higher level task in a WBS

A) categorized as a subtask B) summarized C) outdented D) indented

Computer Science & Information Technology

In Project 2010, you need to define recurring tasks only one time using the Recurring Task Information dialog box.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology