Question 1

Which of the following is the unique identifier of an entity?

Accepted Answer

A)  field 
B)  key 
C)  record type 
D)  record occurrence 
E)  file 
A)  field 
B)  key 
C)  record type 
D)  record occurrence 
E)  file

Question 2

A file is a collection of records of the same structure.

Accepted Answer

A) True 
 B)False

Question 3

Records and fields in the Airplane file.
a. Describe the file's record type.
b. Show a record occurrence.
c. Describe the set or range of values that the Airplane Number field can take.
d. Describe the set or range of values that the Manufacturer field can take.

Accepted Answer

a. It contains the fields Airplane Numbe

Question 4

A simple linear file is structured in a tree-like manner.

Accepted Answer

A) True 
 B)False

Question 5

The problems caused by redundant data within individual files are the same problems caused by redundant data across multiple files.

Accepted Answer

A) True 
 B)False

Question 6

Prior to the development of the database concept, programs usually had to be modified if the file structures that they accessed were modified.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is true?

Accepted Answer

A)  Data integration is desirable but data redundancy is not. 
B)  Data redundancy is desirable but data integration is not. 
C)  Both data integration and data redundancy are desirable. 
D)  Neither data integration nor data redundancy is desirable. 
E)  None of the above. 
A)  Data integration is desirable but data redundancy is not. 
B)  Data redundancy is desirable but data integration is not. 
C)  Both data integration and data redundancy are desirable. 
D)  Neither data integration nor data redundancy is desirable. 
E)  None of the above.

Question 8

In an automobile manufacturing company, an object about which we might want to maintain data could be any of the following, except _____.

Accepted Answer

A)  an employee 
B)  a finished car 
C)  a length 
D)  a supplier 
E)  a sales meeting 
A)  an employee 
B)  a finished car 
C)  a length 
D)  a supplier 
E)  a sales meeting

Question 9

Retrieving the records of a file in order based on a set of field values is referred to as _____.

Accepted Answer

A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval 
A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval

Question 10

When different kinds of data (data about different entities) are merged in one file, which of the following anomalies can occur?

Accepted Answer

A)  deletion but not insertion or update 
B)  insertion but not deletion or update 
C)  insertion and deletion but not update 
D)  insertion and update but not deletion 
E)  deletion, insertion, and update 
A)  deletion but not insertion or update 
B)  insertion but not deletion or update 
C)  insertion and deletion but not update 
D)  insertion and update but not deletion 
E)  deletion, insertion, and update

Question 11

Retrieving the records of a file in order based on the order in which they are stored on a disk is referred to as _____.

Accepted Answer

A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval 
A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval

Question 12

By definition, a database management system _____.

Accepted Answer

A)  permits data to be stored non-redundantly but does not provide for data integration 
B)  provides for data integration but does not permit the data to be stored non-redundantly 
C)  permits data to be stored non-redundantly and provides for data integration 
D)  does not permit data to be stored non-redundantly and also does not provide for data integration 
E)  provides for data integration only when the data is stored redundantly 
A)  permits data to be stored non-redundantly but does not provide for data integration 
B)  provides for data integration but does not permit the data to be stored non-redundantly 
C)  permits data to be stored non-redundantly and provides for data integration 
D)  does not permit data to be stored non-redundantly and also does not provide for data integration 
E)  provides for data integration only when the data is stored redundantly

Question 13

An attribute is an entity.

Accepted Answer

A) True 
 B)False

Question 14

Retrieving a single record of a file based on a field value is an example of _____.

Accepted Answer

A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval 
A)  immediate sequential retrieval 
B)  logical sequential retrieval 
C)  physical sequential retrieval 
D)  direct retrieval 
E)  indirect retrieval

Question 15

Prior to the development of the database concept, there was no data redundancy within individual files.

Accepted Answer

A) True 
 B)False

Question 16

Assume that the records of the Airplane file are physically stored in the order shown.
a. Retrieve all of the records of the file physically sequentially.
b. Retrieve all of the records of the file logically sequentially based on the Manufacturer field.
c. Retrieve all of the records of the file logically sequentially based on the Airplane Number field.
d. Retrieve all of the records of the file logically sequentially based on the Year Built field.
e. Perform a direct retrieval of the records with an Airplane Number field value of 22663.
f. Perform a direct retrieval of the records with a Manufacturer field value of Boeing.

Accepted Answer

Answer
a. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10.

Question 17

Consider the following Animal and Enclosure files from the Central Zoo. The left-hand column of relative record numbers is there to facilitate answering some of the questions.
 $\begin{array}{ll}&\text { Enclosure }\
&\text { Number }\quad\text { Type }\quad\quad\quad\text { Size }\
\begin{array}{lr}
1\2\3\4
\end{array}&
\begin{array}{|r|l|r|}
\hline 0347 & \text { Glass Cage } & 400 \
\hline 0636 & \text { Fenced Yard } & 1500 \
\hline 0912 & \text { Natural Area } & 2000 \
\hline 1483 & \text { Fenced Yard } & 1650 \
\hline
\end{array}\end{array}$ Enclosure file
 $\begin{array}{ll}
&\text { Animal } \quad\quad\quad\quad\quad\quad \quad \text { Animal } \quad \text { Enclosure }\
&\text { Number\quad Species\quad\quad\quad Name\quad\quad\quad Number }\
\begin{array}{ll}
1\2\3\4\5\6\7\8\9\10
\end{array}&\begin{array}{|c|l|l|r|}
\hline 13648\quad & \text { Elephant } & \text { Jumbo } & 1483 \
\hline 15273 & \text { Giraffe } & \text { Stretch } & 0912 \
\hline 17543 & \text { Elephant } & \text { Shirley } & 0636 \
\hline 20165 & \text { Giraffe } & \text { Necky } & 0912 \
\hline 23743 & \text { Giraffe } & \text { High Top } & 0912 \
\hline 27579 & \text { Panda } & \text { Fluffy } & 0347 \
\hline 32565 & \text { Elephant } & \text { Large Louie } & 1483 \
\hline 33837 & \text { Elephant } & \text { Charley } & 0636 \
\hline 36340 & \text { Panda } & \text { Huggy } & 0347 \
\hline 40436 & \text { Giraffe } & \text { Sarah } & 0912 \
\hline
\end{array}
\end{array}$
 Animal file 
a. 0912 appears as an enclosure number in record 3 of the Enclosure file and in records 2, 4, 5, and 10 of the Animal file. Does this constitute redundant data? Explain.
b. Why does the Enclosure Number field appear in both files?
c. What would you have to do to find the type of enclosure in which animal number 33837 is kept?
d. Merge the two files into one based on which records of one file are related to which records of the other file.
e. How does merging the two files into one affect data integration?
f. How does merging the two files into one affect data redundancy?

Accepted Answer

a. No, because each appearance of enclos

Question 18

The deletion anomaly can cause a loss of data.

Accepted Answer

A) True 
 B)False

Question 19

All of the following are true about data redundancy across multiple files, except _____.

Accepted Answer

A)  it speeds updates when the redundant data must be updated 
B)  it is a managerial problem when the company does not encourage data sharing 
C)  it is a technical problem when the company's software systems do not support data sharing 
D)  it wastes disk space 
E)  it can potentially cause data integrity problems 
A)  it speeds updates when the redundant data must be updated 
B)  it is a managerial problem when the company does not encourage data sharing 
C)  it is a technical problem when the company's software systems do not support data sharing 
D)  it wastes disk space 
E)  it can potentially cause data integrity problems

Question 20

Data integration _____.

Accepted Answer

A)  refers to the compatibility between data and the hardware on which it is stored 
B)  is the ability to tie together pieces of related data in an information system 
C)  is the ease with which data can be accessed by an application program that requires it 
D)  refers to the linkage between data and its related information 
E)  is undesirable in any information system 
A)  refers to the compatibility between data and the hardware on which it is stored 
B)  is the ability to tie together pieces of related data in an information system 
C)  is the ease with which data can be accessed by an application program that requires it 
D)  refers to the linkage between data and its related information 
E)  is undesirable in any information system

Which of the following is the unique identifier of an entity?

A file is a collection of records of the same structure.

Records and fields in the Airplane file. a. Describe the file's record type. b. Show a record occurrence. c. Describe the set or range of values that the Airplane Number field can take. d. Describe the set or range of values that the Manufacturer field can take.

A simple linear file is structured in a tree-like manner.

The problems caused by redundant data within individual files are the same problems caused by redundant data across multiple files.

Prior to the development of the database concept, programs usually had to be modified if the file structures that they accessed were modified.

Which of the following is true?

In an automobile manufacturing company, an object about which we might want to maintain data could be any of the following, except _____.

Retrieving the records of a file in order based on a set of field values is referred to as _____.

When different kinds of data (data about different entities) are merged in one file, which of the following anomalies can occur?

Retrieving the records of a file in order based on the order in which they are stored on a disk is referred to as _____.

By definition, a database management system _____.

An attribute is an entity.

Retrieving a single record of a file based on a field value is an example of _____.

Prior to the development of the database concept, there was no data redundancy within individual files.

The deletion anomaly can cause a loss of data.

All of the following are true about data redundancy across multiple files, except _____.

Data integration _____.

Data: the New Corporate Resource

Data Modeling

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 3: The Database Management System Concept

Which of the following is the unique identifier of an entity?

A file is a collection of records of the same structure.

Records and fields in the Airplane file. a. Describe the file's record type. b. Show a record occurrence. c. Describe the set or range of values that the Airplane Number field can take. d. Describe the set or range of values that the Manufacturer field can take.

A simple linear file is structured in a tree-like manner.

The problems caused by redundant data within individual files are the same problems caused by redundant data across multiple files.

Prior to the development of the database concept, programs usually had to be modified if the file structures that they accessed were modified.

Which of the following is true?

In an automobile manufacturing company, an object about which we might want to maintain data could be any of the following, except _____.

Retrieving the records of a file in order based on a set of field values is referred to as _____.

When different kinds of data (data about different entities) are merged in one file, which of the following anomalies can occur?

Retrieving the records of a file in order based on the order in which they are stored on a disk is referred to as _____.

By definition, a database management system _____.

An attribute is an entity.

Retrieving a single record of a file based on a field value is an example of _____.

Prior to the development of the database concept, there was no data redundancy within individual files.

The deletion anomaly can cause a loss of data.

All of the following are true about data redundancy across multiple files, except _____.

Data integration _____.

Data: the New Corporate Resource

Data Modeling

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters