Question 1

In physical sequential access, the records of a file are retrieved in order based on the values of one or a combination of the fields.

Accepted Answer

A) True 
 B)False

Question 2

An entity set is _____.

Accepted Answer

A)  a file 
B)  a collection of records of the same type 
C)  all of the attributes in a record 
D)  a collection of characteristics of an entity 
E)  a collection of entities of the same type 
A)  a file 
B)  a collection of records of the same type 
C)  all of the attributes in a record 
D)  a collection of characteristics of an entity 
E)  a collection of entities of the same type

Question 3

When data structures can be modified without affecting the programs that use the data, we say that the environment is highly _____.

Accepted Answer

A)  secure 
B)  recoverable 
C)  data structured 
D)  data independent 
E)  data dependent 
A)  secure 
B)  recoverable 
C)  data structured 
D)  data independent 
E)  data dependent

Question 4

Each of the following is one of the fundamental operations that can be performed on stored data, except _____.

Accepted Answer

A)  converge 
B)  retrieve 
C)  insert 
D)  delete 
E)  update 
A)  converge 
B)  retrieve 
C)  insert 
D)  delete 
E)  update

Question 5

In a data independent environment, changes to data structures necessitate little or no changes to the programs that use the data.

Accepted Answer

A) True 
 B)False

Question 6

All of the following are corporate resources, except _____.

Accepted Answer

A)  money 
B)  inventory 
C)  data 
D)  plant and equipment 
E)  competitors 
A)  money 
B)  inventory 
C)  data 
D)  plant and equipment 
E)  competitors

Question 7

Today, data is considered to be a manageable resource along with money, personnel, and plant and equipment.

Accepted Answer

A) True 
 B)False

Question 8

When different kinds of data (data about different entities) are merged in one file, a deletion anomaly _____.

Accepted Answer

A)  cannot occur 
B)  causes a loss of data that may not be stored anywhere else 
C)  is helpful in reducing the amount of redundant data present 
D)  causes additional redundant data to appear 
E)  occurs as the result of an insertion anomaly 
A)  cannot occur 
B)  causes a loss of data that may not be stored anywhere else 
C)  is helpful in reducing the amount of redundant data present 
D)  causes additional redundant data to appear 
E)  occurs as the result of an insertion anomaly

Question 9

Which of the following is a collection of descriptions of the entities in an entity set?

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 10

A particular data value appearing multiple times in a column of a file always indicates redundant data.

Accepted Answer

A) True 
 B)False

Question 11

The navigational approaches to database management are _____.

Accepted Answer

A)  relational and object-oriented 
B)  hierarchical and object-oriented 
C)  hierarchical and network 
D)  relational and network 
E)  network and object-oriented 
A)  relational and object-oriented 
B)  hierarchical and object-oriented 
C)  hierarchical and network 
D)  relational and network 
E)  network and object-oriented

Question 12

Because of how critical the database concept is, several hundred approaches to the problem of providing both non-redundant data storage and a data integration capability have been devised.

Accepted Answer

A) True 
 B)False

Question 13

Integrating data in a set of non-redundant files requires a multi-file access.

Accepted Answer

A) True 
 B)False

Question 14

A database management system is a software utility that stresses the storage of non-redundant data without the expectation of providing a data integration capability.

Accepted Answer

A) True 
 B)False

Question 15

Redundant data can occur across multiple files but not within individual files.

Accepted Answer

A) True 
 B)False

Question 16

Problems
The following Animal File from the Central Zoo will be used in several of the following questions. The left-hand column of relative record numbers is there to facilitate answering the questions.
 \(\begin{array}{lr}
&\text { Animal } \quad\quad\quad\quad\quad\quad\quad\quad \text { Animal } \quad\quad\quad\quad\quad \text { Country of } \quad\quad\quad\quad\
&\text { Number } \quad\quad \text { Species }\quad\quad\quad  \text { Name }\quad\quad \text { Gender }  \quad\text { Birth }\quad\quad\text { Weight }\
\begin{array}{lr}
1\2\3\4\5\6\7\8\9\10
\end{array}&
\begin{array}{|r|l|l|l|l|r|}
\hline 13648 & \text { Elephant } & \text { Jumbo } & \text { M }\quad\quad & \text { Uganda } & 6,000 \
\hline 14990 & \text { Kangaroo } & \text { Fred } & \text { M } & \text { Australia } & 200 \
\hline 17543 & \text { Elephant } & \text { Shirley } & \text { F } & \text { Nigeria } & 5,500 \
\hline 20165 & \text { Giraffe } & \text { Necky } & \text { F } & \text { USA } & 500 \
\hline 23743 & \text { Giraffe } & \text { High Top } & \text { F } & \text { USA } & 600 \
\hline 27579 & \text { Panda } & \text { Fluffy } & \text { M } & \text { China } & 250 \
\hline 32565 & \text { Elephant } & \text { Large Louie } & \text { M } & \text { India } & 7,000 \
\hline 34871 & \text { Grizzly Bear } & \text { Doris } & \text { F } & \text { Canada } & 1,500 \
\hline 35993 & \text { Lion } & \text { King } & \text { M } & \text { USA } & 580 \
\hline 38578 & \text { Tiger } & \text { Stripes } & \text { F } & \text { India } & 470\\hline
\end{array}\end{array}\) Animal file
-Assume that the records of the Animal 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 Animal Name field.
c. Retrieve all of the records of the file logically sequentially based on the Animal Number field.
d. Retrieve all of the records of the file logically sequentially based on the Weight field.
e. Perform a direct retrieval of the records with an Animal Number field value of 34871.
f. Perform a direct retrieval of the records with a Country of Birth field value of USA.

Accepted Answer

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

Question 17

An attribute is _____.

Accepted Answer

A)  a collection of objects of the same type 
B)  a characteristic of an entity 
C)  a record of a file 
D)  a collection of records of the same type 
E)  an event 
A)  a collection of objects of the same type 
B)  a characteristic of an entity 
C)  a record of a file 
D)  a collection of records of the same type 
E)  an event

Question 18

Security, backup and recovery, and concurrency are issues that are common to all databases and so should be handled by the DBMS.

Accepted Answer

A) True 
 B)False

Question 19

Combining files to achieve data integration can introduce data redundancy.

Accepted Answer

A) True 
 B)False

Question 20

Data redundancy _____.

Accepted Answer

A)  can occur across multiple files but not within a single file 
B)  can occur within a single file but not across multiple files 
C)  is a positive feature in the simple linear file environment but is a negative feature in the database environment 
D)  is a negative feature in the simple linear file environment but is a positive feature in the database environment 
E)  None of the above. 
A)  can occur across multiple files but not within a single file 
B)  can occur within a single file but not across multiple files 
C)  is a positive feature in the simple linear file environment but is a negative feature in the database environment 
D)  is a negative feature in the simple linear file environment but is a positive feature in the database environment 
E)  None of the above.

In physical sequential access, the records of a file are retrieved in order based on the values of one or a combination of the fields.

An entity set is _____.

When data structures can be modified without affecting the programs that use the data, we say that the environment is highly _____.

Each of the following is one of the fundamental operations that can be performed on stored data, except _____.

In a data independent environment, changes to data structures necessitate little or no changes to the programs that use the data.

All of the following are corporate resources, except _____.

Today, data is considered to be a manageable resource along with money, personnel, and plant and equipment.

When different kinds of data (data about different entities) are merged in one file, a deletion anomaly _____.

Which of the following is a collection of descriptions of the entities in an entity set?

A particular data value appearing multiple times in a column of a file always indicates redundant data.

The navigational approaches to database management are _____.

Because of how critical the database concept is, several hundred approaches to the problem of providing both non-redundant data storage and a data integration capability have been devised.

Integrating data in a set of non-redundant files requires a multi-file access.

A database management system is a software utility that stresses the storage of non-redundant data without the expectation of providing a data integration capability.

Redundant data can occur across multiple files but not within individual files.

An attribute is _____.

Security, backup and recovery, and concurrency are issues that are common to all databases and so should be handled by the DBMS.

Combining files to achieve data integration can introduce data redundancy.

Data redundancy _____.

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

In physical sequential access, the records of a file are retrieved in order based on the values of one or a combination of the fields.

An entity set is _____.

When data structures can be modified without affecting the programs that use the data, we say that the environment is highly _____.

Each of the following is one of the fundamental operations that can be performed on stored data, except _____.

In a data independent environment, changes to data structures necessitate little or no changes to the programs that use the data.

All of the following are corporate resources, except _____.

Today, data is considered to be a manageable resource along with money, personnel, and plant and equipment.

When different kinds of data (data about different entities) are merged in one file, a deletion anomaly _____.

Which of the following is a collection of descriptions of the entities in an entity set?

A particular data value appearing multiple times in a column of a file always indicates redundant data.

The navigational approaches to database management are _____.

Because of how critical the database concept is, several hundred approaches to the problem of providing both non-redundant data storage and a data integration capability have been devised.

Integrating data in a set of non-redundant files requires a multi-file access.

A database management system is a software utility that stresses the storage of non-redundant data without the expectation of providing a data integration capability.

Redundant data can occur across multiple files but not within individual files.

An attribute is _____.

Security, backup and recovery, and concurrency are issues that are common to all databases and so should be handled by the DBMS.

Combining files to achieve data integration can introduce data redundancy.

Data redundancy _____.

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