Question 1

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 D

Question 2

In a data warehouse,_____ means 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 A

Question 3

In the past,why was data stored in "flat files"?

Accepted Answer

In the past,data was stored in a series of files called "flat files" because they were not arranged in a hierarchy,and there was no relationship among these files.

Question 4

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Accepted Answer

A) True 
 B)False

Question 5

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Accepted Answer

A) True 
 B)False

Question 6

In a _________ model,the relationships among records form a treelike structure.

Accepted Answer

A) hierarchical 
B) relational 
C) network 
D) data 
A) hierarchical 
B) relational 
C) network 
D) data

Question 7

Describe how files are accessed in a random access file structure.

Accepted Answer

In a random access file structure,record

Question 8

In data warehouses,_____ gives users subtotals of various categories,which can be useful.

Accepted Answer

A) summary data 
B) raw data 
C) open data 
D) metadata 
A) summary data 
B) raw data 
C) open data 
D) metadata

Question 9

In a relational database model,the rows are known as _____.

Accepted Answer

A) tuples 
B) attributes 
C) branches 
D) roots 
A) tuples 
B) attributes 
C) branches 
D) roots

Question 10

A distributed database is not limited by the data's physical location.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

To begin designing a relational database,one must define the _____ by defining each table and the fields in it.

Accepted Answer

A) physical structure 
B) logical structure 
C) primary key 
D) foreign key 
A) physical structure 
B) logical structure 
C) primary key 
D) foreign key

Question 13

Fred has been assigned to create a database for a college.What are the types of files and fields he has to include in the college database?

Accepted Answer

A college database might have

Question 14

Which of the following components of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

Accepted Answer

A) Data structure 
B) Operations 
C) Integrity rules 
D) File structure 
A) Data structure 
B) Operations 
C) Integrity rules 
D) File structure

Question 15

The _____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

Accepted Answer

A) data dictionary 
B) data mine 
C) data warehouse 
D) data mart 
A) data dictionary 
B) data mine 
C) data warehouse 
D) data mart

Question 16

In data warehouses,_____ is information in its original form.

Accepted Answer

A) summary data 
B) raw data 
C) paradata 
D) metadata 
A) summary data 
B) raw data 
C) paradata 
D) metadata

Question 17

What is a relational database model?

Accepted Answer

A relational database model us

Question 18

The _____ operator,discussed in data manipulation,is used when all the conditions in a query by example (QBE)form are required to be met.

Accepted Answer

A) NOT 
B) AND 
C) OR 
D) MIS 
A) NOT 
B) AND 
C) OR 
D) MIS

Question 19

A _____ is usually a smaller version of a data warehouse,used by a single department or function.

Accepted Answer

A) data domain 
B) data mine 
C) data dictionary 
D) data mart 
A) data domain 
B) data mine 
C) data dictionary 
D) data mart

Question 20

A select operation pares down a table in a database by eliminating columns according to certain criteria.

Accepted Answer

A) True 
 B)False

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

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

In the past,why was data stored in "flat files"?

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

In a _________ model,the relationships among records form a treelike structure.

Describe how files are accessed in a random access file structure.

In data warehouses,_____ gives users subtotals of various categories,which can be useful.

In a relational database model,the rows are known as _____.

A distributed database is not limited by the data's physical location.

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

To begin designing a relational database,one must define the _____ by defining each table and the fields in it.

Fred has been assigned to create a database for a college.What are the types of files and fields he has to include in the college database?

Which of the following components of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

The _____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

In data warehouses,_____ is information in its original form.

What is a relational database model?

The _____ operator,discussed in data manipulation,is used when all the conditions in a query by example (QBE)form are required to be met.

A _____ is usually a smaller version of a data warehouse,used by a single department or function.

A select operation pares down a table in a database by eliminating columns according to certain criteria.

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

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

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

In the past,why was data stored in "flat files"?

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

In a _________ model,the relationships among records form a treelike structure.

Describe how files are accessed in a random access file structure.

In data warehouses,_____ gives users subtotals of various categories,which can be useful.

In a relational database model,the rows are known as _____.

A distributed database is not limited by the data's physical location.

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

To begin designing a relational database,one must define the _____ by defining each table and the fields in it.

Fred has been assigned to create a database for a college.What are the types of files and fields he has to include in the college database?

Which of the following components of a data model describes methods and calculations that can be performed on data,such as updating and querying data?

The _____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

In data warehouses,_____ is information in its original form.

What is a relational database model?

The _____ operator,discussed in data manipulation,is used when all the conditions in a query by example (QBE)form are required to be met.

A _____ is usually a smaller version of a data warehouse,used by a single department or function.

A select operation pares down a table in a database by eliminating columns according to certain criteria.

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