True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
A
field is a basic unit of data also referred to as a record.
|
|
|
2.
|
A
character is a basic unit of data and can consist of a number, letter, or special
symbol.
|
|
|
3.
|
A
record in the logical design of a database corresponds to a row in the physical table of a relational
database.
|
|
|
4.
|
A
one-to-many relationship cannot be included in a relational database.
|
|
|
5.
|
A
one-to-many relationship means that an occurrence of a specific entity can only exist once in each
table.
|
|
|
6.
|
Data
redundancy is created through a process known as normalization.
|
|
|
7.
|
Data
is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely
identify each record.
|
|
|
8.
|
Partial dependency means that at least one of the data values is dependent on only a
portion of the primary key.
|
|
|
9.
|
A
foreign key uniquely identifies each row in a table.
|
|
|
10.
|
Two
tables can be linked or joined together through a common field.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
11.
|
Which
of the following terms represents a collection of fields? a. | field | c. | character | b. | record | d. | file | | | | |
|
|
|
12.
|
Which
of the following terms refers to a group of related records? a. | database | c. | field | b. | character | d. | file | | | | |
|
|
|
13.
|
A
DBMS includes which of the following capabilities? a. | security | c. | multiuser
access | b. | data dictionary | d. | all of the above | | | | |
|
|
|
14.
|
In
which step of the Systems Development Life Cycle (SDLC) are the logical and physical components
defined? a. | systems
recovery | c. | systems
design | b. | systems analysis | d. | systems implementation and review | | | | |
|
|
|
|
|
|
15.
|
What
type of relationship is depicted in Figure 2? a. | one-to-many | c. | one-to-all | b. | many-to-many | d. | one-to-one | | | | |
|
|
|
16.
|
If
entity A in Figure 2 represents customers and entity B represents automobiles, which of the following
statements is correct? a. | Each customer can only own one car, but each car can be owned
by many customers. | b. | Each customer can only own one car and each car can only be
owned by one customer. | c. | Each customer can own many cars and each car can be owned by
many customers. | d. | Each customer can own many cars, but each car can be owned by
only one customer. | | |
|
|
|
17.
|
If a
recipe contains several ingredients, and those ingredients can also be used in other recipes, this
would be an example of what type of relationship? a. | one-to-many | c. | one-to-all | b. | many-to-many | d. | one-to-one | | | | |
|
|
|
18.
|
The
fact that a person can wear different size clothes and that different people can wear the same size
clothes is best characterized as a what type of relationship? a. | one-to-many | c. | one-to-all | b. | many-to-many | d. | one-to-one | | | | |
|
|
|
19.
|
Which
of the following is used to determine the correct organization for data that is to be stored in a
database? a. | E-R
model | c. | systems
implementation and review | b. | normalization process | d. | systems analysis | | | | |
|
|
|
20.
|
Which
of the following is used to uniquely identify each record? a. | primary
key | c. | partial
dependency | b. | row | d. | account number | | | | |
|
|
|
21.
|
Which
of the following may contain partial dependencies, but cannot contain repeating
groups? a. | unnormalized
data | c. | second normal
form (2NF) | b. | first normal form (1NF) | d. | third normal form (3NF) | | | | |
|
|
|
22.
|
Partial dependency exists if what conditions exist? a. | a column is
dependent on a portion of the table that is not identified as the primary
key | b. | a column is
dependent only on a portion of a composite primary key | c. | the data
contains repeating groups | d. | the table is not in first normal form
(1NF) | | |
|
|
|
23.
|
If
the data has no partial dependencies, repeating groups, or transitive dependencies, and has a
composite primary key, the data is in which form? a. | first normal | c. | third normal | b. | second
normal | d. | unnormalized | | | | |
|
|
|
24.
|
What
is added to a relational database to eliminate many-to-many relationships? a. | bridging
table | c. | primary
entity | b. | transitive dependency | d. | secondary entity | | | | |
|
|
|
25.
|
Data
mining refers to ____. a. | discovering new data to include in the
database | b. | analyzing data already stored in a
database | c. | selling data to other organizations | d. | all of the
above | | |
|
Completion
Complete each sentence or
statement.
|
|
|
26.
|
A
field is referred to as a(n) ____________________ in the physical database.
|
|
|
27.
|
A
file is referred to as a(n) ____________________ in an Oracle10g database.
|
|
|
28.
|
Data
is in ____________________ normal form if it does not have any repeating groups and has a primary
key.
|
|
|
29.
|
If at
least one value in a record does not depend upon the primary key, then a _________________________
exists.
|
|
|
30.
|
_________________________ is a data sublanguage that processes sets of
data.
|