Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
A
relation is a(n) a. | attribute. | c. | field. | b. | column. | d. | table. | | | | |
|
|
|
2.
|
If
two tables have the same column name, the best approach is to a. | not use these
two tables together. | b. | not use the column names in the same
statement. | c. | use the table name and the column name, separated by a
period. | d. | use the table name only. | | |
|
|
|
3.
|
Each
relation is a ____ dimensional table.
|
|
|
4.
|
The
attributes of an entity become the ____ in a table. a. | rows | c. | headers | b. | data | d. | columns | | | | |
|
|
|
5.
|
Each
location in the table must be ____-valued. a. | double | c. | distinctly | b. | single | d. | uniquely | | | | |
|
|
|
6.
|
Rows
are also called a. | fields. | c. | tuples. | b. | columns. | d. | attributes. | | | | |
|
|
|
7.
|
The
____ key of a table is the column that uniquely identifies a row in a table. a. | primary | c. | foreign | b. | secondary | d. | minor | | | | |
|
|
|
8.
|
An
approach to writing queries in a visual method is called a. | SQL. | c. | QBE. | b. | QAC. | d. | ACCESS. | | | | |
|
|
|
9.
|
In
order to display all fields, we can use the ____ symbol in our queries.
|
|
|
10.
|
Using
the * means that we will see all ____ in the query. a. | rows | c. | tables | b. | columns | d. | databases | | | | |
|
|
|
11.
|
The
relational operator to test for inequality is
|
|
|
12.
|
The
compound criteria (conditions) are created by using a. | AND,
OR. | c. | OR,
NOT. | b. | AND,
NOR. | d. | NOT,
ONLY. | | | | |
|
|
|
13.
|
To
use the AND criterion, place the criteria on the ____ criteria row in the design
grid. a. | same | c. | row above
the | b. | row below
the | d. | rows above and
below the | | | | |
|
|
|
14.
|
To
use the OR criterion, place the criteria on ____ criteria row(s) in the design grid. a. | the
same | c. | a different
| b. | all the
| d. | none of
the | | | | |
|
|
|
15.
|
In
order to write a query to determine the customers whose balance is between $1000 and $5000, you would
use the ____ criterion.
|
|
|
16.
|
Any
field names to be calculated are placed between ____ when the query is written.
|
|
|
17.
|
Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions
that can be used in a query. a. | accumulated | c. | afterstatistic | b. | allowed | d. | aggregate | | | | |
|
|
|
18.
|
To
calculate the lowest balance for all customers, which aggregate function should be
used? |