Question 1

The _____ component of a database management system (DBMS)is used to add,delete,modify,and retrieve records from a database.

Accepted Answer

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

Question 2

The variety dimension of big data refers to a combination of _____.

Accepted Answer

A) data warehouses and data marts 
B) raw data and metadata 
C) structured data and unstructured data 
D) data definition and data manipulation 
A) data warehouses and data marts 
B) raw data and metadata 
C) structured data and unstructured data 
D) data definition and data manipulation

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

Accepted Answer

A) Online analytical processing systems 
B) Online transaction processing systems 
C) Enterprise resource planning systems 
D) Data mining analysis systems 
A) Online analytical processing systems 
B) Online transaction processing systems 
C) Enterprise resource planning systems 
D) Data mining analysis systems

Question 6

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

Accepted Answer

A) True 
 B)False

Question 7

Explain the ways in which information in a database is observed through a physical view.

Accepted Answer

The physical view involves how

Question 8

A _________ is a collection of related data that is stored in a central location or multiple locations.

Accepted Answer

A) database 
B) data mart 
C) data warehouse 
D) data hierarchy​ 
A) database 
B) data mart 
C) data warehouse 
D) data hierarchy​

Question 9

What is the function of a distributed database management system (DDBMS)?

Accepted Answer

A distributed database managem

Question 10

What are the areas in the retail industry that can benefit from big data?

Accepted Answer

The retail industry could benefit from b

Question 11

List and describe the features of data in a data warehouse in contrast to data in a database.

Accepted Answer

Data in a data warehouse is described as

Question 12

_________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

Accepted Answer

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

Question 13

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Accepted Answer

A) True 
 B)False

Question 14

What is a data-driven Web site?

Accepted Answer

A data-driven Web site acts as

Question 15

An advantage that a database has over a flat file system is that more information can be generated from the same data.

Accepted Answer

A) True 
 B)False

Question 16

Identify an advantage of using a database over a flat file system.

Accepted Answer

A) Hardware and software start-up costs are low. 
B) It is simple and easy to design. 
C) Programs and data are interdependent. 
D) It uses more sophisticated security measures. 
A) Hardware and software start-up costs are low. 
B) It is simple and easy to design. 
C) Programs and data are interdependent. 
D) It uses more sophisticated security measures.

Question 17

A database administrator is responsible for _____.

Accepted Answer

A) developing recovery procedures in case data is lost or corrupted 
B) maintaining (keeping)an organization's computer network up to date 
C) writing computer programs that allow the system to perform a specific task 
D) designing and implementing the information systems 
A) developing recovery procedures in case data is lost or corrupted 
B) maintaining (keeping)an organization's computer network up to date 
C) writing computer programs that allow the system to perform a specific task 
D) designing and implementing the information systems

Question 18

Identify a true statement about a flat file system.

Accepted Answer

A) Data in a flat file system may not be updated in all files consistently. 
B) Data in a flat file system can be easily managed. 
C) Data in a flat file system can be updated efficiently. 
D) Data duplication in a flat file system is very efficient. 
A) Data in a flat file system may not be updated in all files consistently. 
B) Data in a flat file system can be easily managed. 
C) Data in a flat file system can be updated efficiently. 
D) Data duplication in a flat file system is very efficient.

Question 19

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Accepted Answer

A) True 
 B)False

Question 20

The use of the OR operator means that only one of the conditions in a structured query language (SQL)statement must be met.

Accepted Answer

A) True 
 B)False

The _____ component of a database management system (DBMS)is used to add,delete,modify,and retrieve records from a database.

The variety dimension of big data refers to a combination of _____.

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

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

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

Explain the ways in which information in a database is observed through a physical view.

A _________ is a collection of related data that is stored in a central location or multiple locations.

What is the function of a distributed database management system (DDBMS)?

What are the areas in the retail industry that can benefit from big data?

List and describe the features of data in a data warehouse in contrast to data in a database.

_________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

What is a data-driven Web site?

An advantage that a database has over a flat file system is that more information can be generated from the same data.

Identify an advantage of using a database over a flat file system.

A database administrator is responsible for _____.

Identify a true statement about a flat file system.

Labor and population statistics are examples of sources for internal data that are accessed by a database.

The use of the OR operator means that only one of the conditions in a structured query language (SQL)statement must be met.

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 _____ component of a database management system (DBMS)is used to add,delete,modify,and retrieve records from a database.

The variety dimension of big data refers to a combination of _____.

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

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

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

Explain the ways in which information in a database is observed through a physical view.

A _________ is a collection of related data that is stored in a central location or multiple locations.

What is the function of a distributed database management system (DDBMS)?

What are the areas in the retail industry that can benefit from big data?

List and describe the features of data in a data warehouse in contrast to data in a database.

_________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

What is a data-driven Web site?

An advantage that a database has over a flat file system is that more information can be generated from the same data.

Identify an advantage of using a database over a flat file system.

A database administrator is responsible for _____.

Identify a true statement about a flat file system.

Labor and population statistics are examples of sources for internal data that are accessed by a database.

The use of the OR operator means that only one of the conditions in a structured query language (SQL)statement must be met.

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