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
|
|
|
|
|
|
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.
|