Name: 
 

A114/I111 Chapter Three Review



Completion
Complete each sentence or statement.
 

1. 

Numbers without decimal parts are called ____________________.
 

 

2. 

The command to define a table is ____________________ TABLE.
 

 

3. 

The ____________________ clause will restrict the query results.
 

 

4. 

A(n) ____________________ condition has the form: field name, comparison operator, and then either another field name or a value.
 

 

5. 

A(n) ____________________ condition is formed by connecting two or more simple conditions using either the AND or the OR operator
 

 

6. 

When using the ____________________ operator, both simple conditions must be true for the compound condition to be evaluated to true.
 

 

7. 

When using the ____________________ operator, only one of the simple conditions must be true for the compound condition to be evaluated to true.
 

 

8. 

You can also precede a single condition with the ____________________ operator to negate a condition.
 

 

9. 

The ____________________ operator provides an alternative to a query that contains a range using the AND operator.
 

 

10. 

Numeric fields can be added together using the ____________________ operator.
 

 

11. 

Numeric fields can be multiplied together using the ____________________ operator.
 

 

12. 

The ____________________ operator allows you to use a wildcard when searching for characters in a string.
 

 

13. 

The ____________________ operator allows you to specify a set of values.
 

 

14. 

To display the output in a sorted manner, use the ____________________ clause.
 

 

15. 

The field on which to sort data is called a(n) ____________________.
 

 

16. 

When you need to sort data on two fields, the more important key is called the ____________________ sort key.
 

 

17. 

When you need to sort data on two fields, the less important key is called the ____________________ sort key.
 

 

18. 

SQL's built-in functions are also called ____________________ functions.
 

 

19. 

The function that will calculate a total for a particular field is the ____________________ function.
 

 

20. 

The function that will provide the number of rows meeting certain criteria is the ____________________ function.
 

 

Short Answer
 

21. 

Which aggregate function will display the smallest value?
 

22. 

Which aggregate function will display the largest value?
 

23. 

What is another term for a nested query?
 

24. 

What clause is used to combine groups of records that share a common characteristic?
 

25. 

When rows are grouped, how many lines of output is produced for each group?
 

26. 

In order to restrict which groups will be displayed, which clause is used?
 

27. 

In order to join tables, which clause are the conditions placed in?
 

28. 

What is the term when two tables have the same structure, the same number of fields, and their corresponding fields have the same data type?
 

29. 

In order to modify existing data, what command is used?
 

30. 

In the UPDATE command, what keyword is used to specify the field to be changed and the new value?
 

Essay
 
 
two_files/i0340000.jpg
 

31. 

Using the above figure, create a new table named CustDiff, consisting of all fields from the Customer table and those rows in which the credit limit is less than or equal to $7,500.
 

32. 

Using the above figure, list the number, name, and balance of all customers.
 



 
Check Your Work     Reset Help