Chapter 1 The_ Database Environment and Development Process
1. A database is an organized collection of ________ related data.
A. logically
B. physically
C. loosely
D. badly
Ans: A
LO: 3.1: Define key terms.
Difficulty: Easy
Classification: Concept
Information Technology
2. Older systems that often contain data of poor quality are called ________ systems.
A. controlled
B. legacy
C. database
D. mainframe
Ans: B
LO: 3.1: Define key terms.
Difficulty: Moderate
Classification: Concept
Information Technology
3. Program-data dependence is caused by:
A. file descriptions being stored in each database application.
B. data descriptions being stored on a server.
C. data descriptions being written into programming code.
1
,D. data cohabiting with programs.
Ans: A
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
Information Technology
4. Because applications are often developed independently in file processing systems:
A. the_ data is always non-redundant.
B. unplanned duplicate data files are the_ rule rather than the_ exception.
C. data can always be shared with others.
D. there is a large volume of file I/O.
Ans: B
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
Information Technology
5. Relational databases establish the_ relationships between entities by means of common fields included in a
file called a(n. :
A. entity.
B. relationship.
C. relation.
D. association.
Ans: C
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
Information Technology
2
,6. A(n. ________ is often developed by identifying a form or report that a user needs on a regular basis.
A. enterprise view
B. reporting document
C. user view
D. user snapshot
Ans: C
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
Information Technology
7. A graphical system used to capture the_ nature and relationships among data is called a(n. :
A. XML data model.
B. hypertext graphic.
C. relational database
D. data model.
Ans: D
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
3
, 8. Data that describe the_ properties of other data are:
A. relationships.
B. logical.
C. physical.
D. metadata.
Ans: D
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
9. All of the_ following are properties of metadata EXCEPT:
A. data definitions.
B. processing logic.
C. rules or constraints.
D. data structures.
Ans: B
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
10. A person, place, object, event, or concept about which the_ organization wishes to maintain data is called
a(n. :
A. relationship.
B. object.
C. attribute.
D. entity.
Ans: D
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
4
1. A database is an organized collection of ________ related data.
A. logically
B. physically
C. loosely
D. badly
Ans: A
LO: 3.1: Define key terms.
Difficulty: Easy
Classification: Concept
Information Technology
2. Older systems that often contain data of poor quality are called ________ systems.
A. controlled
B. legacy
C. database
D. mainframe
Ans: B
LO: 3.1: Define key terms.
Difficulty: Moderate
Classification: Concept
Information Technology
3. Program-data dependence is caused by:
A. file descriptions being stored in each database application.
B. data descriptions being stored on a server.
C. data descriptions being written into programming code.
1
,D. data cohabiting with programs.
Ans: A
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
Information Technology
4. Because applications are often developed independently in file processing systems:
A. the_ data is always non-redundant.
B. unplanned duplicate data files are the_ rule rather than the_ exception.
C. data can always be shared with others.
D. there is a large volume of file I/O.
Ans: B
LO: 1.2: Name several limitations of conventional file processing systems.
Difficulty: Moderate
Classification: Concept
Information Technology
5. Relational databases establish the_ relationships between entities by means of common fields included in a
file called a(n. :
A. entity.
B. relationship.
C. relation.
D. association.
Ans: C
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
Information Technology
2
,6. A(n. ________ is often developed by identifying a form or report that a user needs on a regular basis.
A. enterprise view
B. reporting document
C. user view
D. user snapshot
Ans: C
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
Information Technology
7. A graphical system used to capture the_ nature and relationships among data is called a(n. :
A. XML data model.
B. hypertext graphic.
C. relational database
D. data model.
Ans: D
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
3
, 8. Data that describe the_ properties of other data are:
A. relationships.
B. logical.
C. physical.
D. metadata.
Ans: D
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
9. All of the_ following are properties of metadata EXCEPT:
A. data definitions.
B. processing logic.
C. rules or constraints.
D. data structures.
Ans: B
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
10. A person, place, object, event, or concept about which the_ organization wishes to maintain data is called
a(n. :
A. relationship.
B. object.
C. attribute.
D. entity.
Ans: D
LO: 1.3: Explain at least 10 advantages of the_ database approach, compared to traditional file processing.
Difficulty: Moderate
Classification: Concept
4
