Question 1

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

Accepted Answer

A) optimization 
B) allocation 
C) encapsulation 
D) normalization 
A) optimization 
B) allocation 
C) encapsulation 
D) normalization

Question 2

In contrast to data in a database,data in a data warehouse is described as subject oriented,which means that it _____.

Accepted Answer

A) captures aggregated data 
B) manages data transactions 
C) focuses on a specific area 
D) categorizes based on time 
A) captures aggregated data 
B) manages data transactions 
C) focuses on a specific area 
D) categorizes based on time

Question 3

In a data warehouse,_____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Accepted Answer

A) extraction 
B) transformation 
C) optimization 
D) aggregation 
A) extraction 
B) transformation 
C) optimization 
D) aggregation

Question 4

Describe the tasks performed in the first normal form (1NF)stage of normalization to improve database efficiency.

Accepted Answer

Answers will vary.To improve database ef

Question 5

In comparison with a flat file system,_____ in a database.

Accepted Answer

A) storage space is reduced 
B) programs and data are interdependent 
C) complex requests cannot be handled easily 
D) data redundancy is introduced 
A) storage space is reduced 
B) programs and data are interdependent 
C) complex requests cannot be handled easily 
D) data redundancy is introduced

Question 6

In the context of data warehouses,briefly explain extraction,transformation,and loading (ETL).

Accepted Answer

Answers will vary.ETL refers to the proc

Question 7

Describe how data stored in a relational model is retrieved from tables.

Accepted Answer

Answers will vary.Data stored in a relat

Question 8

In the context of the types of data in a database,which is a source of external data?

Accepted Answer

A) Tax records 
B) Sales records 
C) Transaction records 
D) Personnel records 
A) Tax records 
B) Sales records 
C) Transaction records 
D) Personnel records

Question 9

Which is a key factor that has contributed to the growth and popularity of big data?

Accepted Answer

A) Implosion in data growth 
B) Brick and mortar businesses 
C) Mobile and wireless technology 
D) Exponential decay of organizational data 
A) Implosion in data growth 
B) Brick and mortar businesses 
C) Mobile and wireless technology 
D) Exponential decay of organizational data

Question 10

_____ tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

Accepted Answer

A) Online analytical processing 
B) Online transaction processing 
C) Extraction,transformation,and loading 
D) Business analytics 
A) Online analytical processing 
B) Online transaction processing 
C) Extraction,transformation,and loading 
D) Business analytics

Question 11

Which statement is true of big data?

Accepted Answer

A) It eliminates unethical actions based on interpretations. 
B) It can be efficiently processed and managed by conventional computing methods. 
C) It has three dimensions,which are value,density,and uniformity. 
D) It is the result of the exponential growth of data in both public and private organizations. 
A) It eliminates unethical actions based on interpretations. 
B) It can be efficiently processed and managed by conventional computing methods. 
C) It has three dimensions,which are value,density,and uniformity. 
D) It is the result of the exponential growth of data in both public and private organizations.

Question 12

Which statement is true of a flat file system?

Accepted Answer

A) Same data can be stored in more than one file. 
B) Programs and data are independent. 
C) Complex requests can be handled easily. 
D) It requires very less storage space. 
A) Same data can be stored in more than one file. 
B) Programs and data are independent. 
C) Complex requests can be handled easily. 
D) It requires very less storage space.

Question 13

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Accepted Answer

A) True 
 B)False

Question 14

In a(n)_____,each record can have multiple parent and child records.

Accepted Answer

A) network model 
B) hierarchical model 
C) object-oriented model 
D) relational model 
A) network model 
B) hierarchical model 
C) object-oriented model 
D) relational model

Question 15

In a(n)_____,records in files are organized and processed in numerical order.

Accepted Answer

A) sequential access file structure 
B) random access file structure 
C) indexed access file structure 
D) direct access file structure 
A) sequential access file structure 
B) random access file structure 
C) indexed access file structure 
D) direct access file structure

Question 16

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

Accepted Answer

A) dictionary 
B) pattern 
C) mine 
D) warehouse 
A) dictionary 
B) pattern 
C) mine 
D) warehouse

Question 17

In a(n)_____,nodes with the same parents are called twins or siblings.

Accepted Answer

A) hierarchical model 
B) network model 
C) relational model 
D) object-based model 
A) hierarchical model 
B) network model 
C) relational model 
D) object-based model

Question 18

The use of the OR operator in a query form,when using query by example (QBE),means that all conditions must be met.

Accepted Answer

A) True 
 B)False

Question 19

Disks are sequential access devices,whereas tapes are random access devices.

Accepted Answer

A) True 
 B)False

Question 20

The data _____ component of a database management system (DBMS)is used for tasks such as backup and recovery,security,and change management.

Accepted Answer

A) manipulation 
B) generation 
C) definition 
D) administration 
A) manipulation 
B) generation 
C) definition 
D) administration

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

In contrast to data in a database,data in a data warehouse is described as subject oriented,which means that it _____.

In a data warehouse,_____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Describe the tasks performed in the first normal form (1NF)stage of normalization to improve database efficiency.

In comparison with a flat file system,_____ in a database.

In the context of data warehouses,briefly explain extraction,transformation,and loading (ETL).

Describe how data stored in a relational model is retrieved from tables.

In the context of the types of data in a database,which is a source of external data?

Which is a key factor that has contributed to the growth and popularity of big data?

_____ tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

Which statement is true of big data?

Which statement is true of a flat file system?

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

In a(n)_____,each record can have multiple parent and child records.

In a(n)_____,records in files are organized and processed in numerical order.

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

In a(n)_____,nodes with the same parents are called twins or siblings.

The use of the OR operator in a query form,when using query by example (QBE),means that all conditions must be met.

Disks are sequential access devices,whereas tapes are random access devices.

The data _____ component of a database management system (DBMS)is used for tasks such as backup and recovery,security,and change management.

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal,Legal,Ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,Intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,Technologies,and Applications

Filters

Exam 3: Database Systems,Data Warehouses,and Data Marts

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

In contrast to data in a database,data in a data warehouse is described as subject oriented,which means that it _____.

In a data warehouse,_____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

Describe the tasks performed in the first normal form (1NF)stage of normalization to improve database efficiency.

In comparison with a flat file system,_____ in a database.

In the context of data warehouses,briefly explain extraction,transformation,and loading (ETL).

Describe how data stored in a relational model is retrieved from tables.

In the context of the types of data in a database,which is a source of external data?

Which is a key factor that has contributed to the growth and popularity of big data?

_____ tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

Which statement is true of big data?

Which statement is true of a flat file system?

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

In a(n)_____,each record can have multiple parent and child records.

In a(n)_____,records in files are organized and processed in numerical order.

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

In a(n)_____,nodes with the same parents are called twins or siblings.

The use of the OR operator in a query form,when using query by example (QBE),means that all conditions must be met.

Disks are sequential access devices,whereas tapes are random access devices.

The data _____ component of a database management system (DBMS)is used for tasks such as backup and recovery,security,and change management.

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal,Legal,Ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,Intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,Technologies,and Applications

Filters