True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
A query is designed to make data entry into a database easier.
|
|
|
2.
|
Consistency checks ensure that only reasonable data values are entered into a
database.
|
|
|
3.
|
Reducing data redundancy by recording data only once is called data
normalization.
|
|
|
4.
|
A data warehouse is a smaller slice of a data mart.
|
|
|
5.
|
The main reason businesses use data mining is to simplify transaction processing
systems.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
6.
|
Two lists reflecting different data about the same person is an example of
_____.
a. | data redundancy | c. | data disparity | b. | data inconsistency | d. | data duplication
errors |
|
|
|
7.
|
Which of the following is NOT an advantage of using a database versus
lists?
a. | Information can be easily shared among users. | c. | Data integrity can be assured with
a database. | b. | Data entry errors can be minimized with databases. | d. | Databases are easier to build and maintain than
lists. |
|
|
|
8.
|
A group of related fields in a relational database is called a _____.
a. | primary key | c. | master key | b. | record | d. | table |
|
|
|
9.
|
In databases, tables are related using _____.
a. | primary keys and foreign keys | c. | data marts | b. | boolean
logic | d. | database
logic |
|
|
|
10.
|
A field that has a unique value for each record in a database is called the
_____.
a. | logical key | c. | key field | b. | master field | d. | primary key |
|
|
|
11.
|
A primary key of one table that is also found in a related table is a
_____.
a. | linked key | c. | secondary key | b. | foreign key | d. | subordinate key |
|
|
|
12.
|
Which of the following is one of the four main operations of a database
management system?
a. | Querying data | c. | Structuring data | b. | Dissecting data | d. | Consolidating
data |
|
|
|
13.
|
Ensuring that a field must contain a number that is between two values is an
example of a(n) _____.
a. | existence check | c. | range check | b. | completeness check | d. | consistency
check |
|
|
|
14.
|
A system that is designed to help perform routine daily tasks is known as a(n)
_____.
a. | decision support system | c. | data warehouse | b. | office support
system | d. | management
information system |
|
|
|
15.
|
An electronic system used to record sales of products through Web site is an
example of a _____.
a. | transaction processing system | c. | management information
system | b. | decision support system | d. | knowledge-based system |
|