,Chapter 1: Database Systems
TRUE/FALSE
1. Data and information are essentially the same thing.
ANS: F PTS: 1
2. Data processing can be as simple as organizing data to reveal patterns.
ANS: T PTS: 1
3. We are now said to be entering the “knowledge age.”
ANS: T PTS: 1
4. Information implies familiarity, awareness, and understanding knowledge as it applies to an
environment.
ANS: F PTS: 1
5. Data constitute the building blocks of information.
ANS: T PTS: 1
6. Metadata present a more complete picture of the data in the database than the data itself.
ANS: T PTS: 1
7. The only way to access the data in a database is through the DBMS.
ANS: T PTS: 1
8. Database programming languages receive all application requests and translate them into the complex
operations required to fulfill those requests.
ANS: F PTS: 1
9. The DBMS reveals much of the database’s internal complexity to the application programs and users.
ANS: F PTS: 1
© 2010 Cengage Learning. All Rights Reserved. This edition is intended for use outside of the U.S. only, with content that may be different
from the U.S. Edition. May not be scanned, copied, duplicated, or posted to a publicly accessible website, in whole or in part.
,10. One disadvantage of the DBMS is that it increases the risk of data security breaches.
ANS: F PTS: 1
11. An operational database is sometimes referred to as an enterprise database.
ANS: F PTS: 1
12. A data warehouse can store data derived from many sources.
ANS: T PTS: 1
13. The same data might be simultaneously structured and unstructured depending on the intended
processing.
ANS: T PTS: 1
14. Corporations use only structured data.
ANS: F PTS: 1
15. Historically, a manual file system was composed of a system of file folders and filing cabinets.
ANS: T PTS: 1
16. Initially the files within a computer file system were similar to manual files.
ANS: T PTS: 1
17. Structural dependence exists when it is possible to make changes in the file structure without affecting
the application program’s ability to access the data.
ANS: F PTS: 1
18. A query language is a procedural language.
ANS: F PTS: 1
19. One disadvantage of a database system over previous data management approaches is increased costs.
ANS: T PTS: 1
© 2010 Cengage Learning. All Rights Reserved. This edition is intended for use outside of the U.S. only, with content that may be different
from the U.S. Edition. May not be scanned, copied, duplicated, or posted to a publicly accessible website, in whole or in part.
, 20. One advantage of a database system over previous data management approaches is that the database
system is considerably less complex.
ANS: F PTS: 1
MULTIPLE CHOICE
1. ____ is used to reveal the meaning of data.
a. Raw facts c. Formatting
b. Knowledge d. Information
ANS: D PTS: 1
2. Accurate, relevant, and timely information is the key to ____.
a. data management c. knowledge
b. good decision making d. understanding
ANS: B PTS: 1
3. ____ is the body of information and facts about a specific subject.
a. Data c. Knowledge
b. Information d. A database
ANS: C PTS: 1
4. End-user data is ____.
a. raw facts about the end-user
b. raw facts of interest to the end-user
c. data about data
d. accurate, relevant and timely information
ANS: B PTS: 1
5. ____ provide(s) a description of the data characteristics and the set of relationships that link the data
found within the database.
a. Queries c. Metadata
b. End-user data d. Information
ANS: C PTS: 1
6. The ____ serve(s) as the intermediary between the user and the database.
a. DBMS c. end-user data
b. metadata d. programming language
© 2010 Cengage Learning. All Rights Reserved. This edition is intended for use outside of the U.S. only, with content that may be different
from the U.S. Edition. May not be scanned, copied, duplicated, or posted to a publicly accessible website, in whole or in part.
TRUE/FALSE
1. Data and information are essentially the same thing.
ANS: F PTS: 1
2. Data processing can be as simple as organizing data to reveal patterns.
ANS: T PTS: 1
3. We are now said to be entering the “knowledge age.”
ANS: T PTS: 1
4. Information implies familiarity, awareness, and understanding knowledge as it applies to an
environment.
ANS: F PTS: 1
5. Data constitute the building blocks of information.
ANS: T PTS: 1
6. Metadata present a more complete picture of the data in the database than the data itself.
ANS: T PTS: 1
7. The only way to access the data in a database is through the DBMS.
ANS: T PTS: 1
8. Database programming languages receive all application requests and translate them into the complex
operations required to fulfill those requests.
ANS: F PTS: 1
9. The DBMS reveals much of the database’s internal complexity to the application programs and users.
ANS: F PTS: 1
© 2010 Cengage Learning. All Rights Reserved. This edition is intended for use outside of the U.S. only, with content that may be different
from the U.S. Edition. May not be scanned, copied, duplicated, or posted to a publicly accessible website, in whole or in part.
,10. One disadvantage of the DBMS is that it increases the risk of data security breaches.
ANS: F PTS: 1
11. An operational database is sometimes referred to as an enterprise database.
ANS: F PTS: 1
12. A data warehouse can store data derived from many sources.
ANS: T PTS: 1
13. The same data might be simultaneously structured and unstructured depending on the intended
processing.
ANS: T PTS: 1
14. Corporations use only structured data.
ANS: F PTS: 1
15. Historically, a manual file system was composed of a system of file folders and filing cabinets.
ANS: T PTS: 1
16. Initially the files within a computer file system were similar to manual files.
ANS: T PTS: 1
17. Structural dependence exists when it is possible to make changes in the file structure without affecting
the application program’s ability to access the data.
ANS: F PTS: 1
18. A query language is a procedural language.
ANS: F PTS: 1
19. One disadvantage of a database system over previous data management approaches is increased costs.
ANS: T PTS: 1
© 2010 Cengage Learning. All Rights Reserved. This edition is intended for use outside of the U.S. only, with content that may be different
from the U.S. Edition. May not be scanned, copied, duplicated, or posted to a publicly accessible website, in whole or in part.
, 20. One advantage of a database system over previous data management approaches is that the database
system is considerably less complex.
ANS: F PTS: 1
MULTIPLE CHOICE
1. ____ is used to reveal the meaning of data.
a. Raw facts c. Formatting
b. Knowledge d. Information
ANS: D PTS: 1
2. Accurate, relevant, and timely information is the key to ____.
a. data management c. knowledge
b. good decision making d. understanding
ANS: B PTS: 1
3. ____ is the body of information and facts about a specific subject.
a. Data c. Knowledge
b. Information d. A database
ANS: C PTS: 1
4. End-user data is ____.
a. raw facts about the end-user
b. raw facts of interest to the end-user
c. data about data
d. accurate, relevant and timely information
ANS: B PTS: 1
5. ____ provide(s) a description of the data characteristics and the set of relationships that link the data
found within the database.
a. Queries c. Metadata
b. End-user data d. Information
ANS: C PTS: 1
6. The ____ serve(s) as the intermediary between the user and the database.
a. DBMS c. end-user data
b. metadata d. programming language
© 2010 Cengage Learning. All Rights Reserved. This edition is intended for use outside of the U.S. only, with content that may be different
from the U.S. Edition. May not be scanned, copied, duplicated, or posted to a publicly accessible website, in whole or in part.