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?
|
|
|
19.
|
In
order to create a unit out of a number of records that share some common characteristic,
select a. | Order
by. | c. | Collect
by. | b. | Organize
by. | d. | Group
by. | | | | |
|
|
|
20.
|
If
you are sorting by more than one column, the more important field/column is called the
a. | primary sort
key. | c. | maximum sort
key. | b. | secondary sort
key. | d. | minor sort
key. | | | | |
|
|
|
21.
|
In
order to select data from more than one table, it will be necessary to ____ the
tables. a. | merge | c. | join | b. | combine | d. | break apart | | | | |
|
|
|
22.
|
A
query that changes data is a(n) ____ query. a. | addition | c. | update | b. | modification | d. | select | | | | |
|
|
|
23.
|
A(n)
____ query deletes all the records satisfying the criteria entered in the query. a. | update | c. | select | b. | modify | d. | delete | | | | |
|
|
|
|
|
|
24.
|
Refer
to figure 2.1 on pages 30-31. How many records would be deleted for the following query? Delete all
order lines in which the order number is 21610.
|
|
|
|
|
|
25.
|
Refer
to figure 2.1 on pages 30-31. How many records would be affected for the following
conditions?
Change the zip code for the customers in the city of Fillmore to
33363.
|
|
|
26.
|
A
____ query creates a new table using the query results. a. | new-table | c. | create-table | b. | make-table | d. | merge-table | | | | |
|
|
|
27.
|
The
type of algebra that manipulates a database is called ____ algebra. a. | boolean | c. | relational | b. | Cartesian | d. | basic | | | | |
|
|
|
28.
|
Which
command takes a vertical subset of a table? a. | SELECT | c. | PROGRAM | b. | DELETE | d. | PROJECT | | | | |
|
|
|
29.
|
Which
operation will allow you to extract data from more than one table? a. | select | c. | project | b. | merge | d. | join | | | | |
|
|
|
30.
|
Two
tables are considered to be ____ compatible if they have the same number of columns and their
corresponding columns represent the same type of data. a. | union | c. | difference | b. | intersection | d. | product | | | | |
|
|
|
31.
|
Two
tables ____ have the same structure to be union-compatible. a. | need not
| c. | should | b. | must | d. | can | | | | |
|
|
|
32.
|
The
____ operator is for all the rows in a table that were contained in table A or table B or in
both. a. | union | c. | product | b. | difference | d. | intersection | | | | |
|
|
|
33.
|
The
____ set operator will show all rows common to both tables A and B. a. | union | c. | product | b. | difference | d. | intersection | | | | |
|
|
|
34.
|
The
____ set operator shows all the rows from table A that are not in table B. a. | union | c. | product | b. | difference | d. | intersection | | | | |
|
|
|
35.
|
The
____ set operator is performed by the SUBTRACT command in relational algebra. a. | union | c. | product | b. | difference | d. | intersection | | | | |
|
|
|
36.
|
The
____ set operator is used to concatenate every row in the first table with every row in the second
table. a. | union | c. | product | b. | difference | d. | intersection | | | | |
|
|
|
37.
|
The
product of two tables is also called the ____ product. a. | Cartesian | c. | Cathode | b. | Cartigan | d. | Cartilage | | | | |
|
|
|
38.
|
Using
the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in the product
of these two tables is
|
|
|
|
|
|
39.
|
Refer
to figure 2.44 on page 60. What is the result of dividing the OrderLine table (use the whole table -
columns OrderNum and PartNum) with the Part table (use the PartNum columns containing data DR93 and
DW11)? a. | 21608 | c. | 21613 | b. | 21610 | d. | 21614 | | | | |
|
|
|
40.
|
The
difference operation is performed by the ____ command. a. | subtract | c. | product | b. | intersection | d. | union | | | | |
|
|
|
41.
|
The
operation where every row in table A is combined with every row in table B is the a. | intersection. | c. | product. | b. | union. | d. | difference. | | | | |
|
|
|
42.
|
If
you want only those combinations that satisfy certain restrictions, you should use the ____ operation
instead of the product operation. a. | union | c. | difference | b. | join | d. | subtract | | | | |
|