Question 1

In comparison with flat file systems, databases:

Accepted Answer

A) minimize data redundancy. 
B) are easier to design. 
C) have less sophisticated security measures. 
D) require more storage space. 
A) minimize data redundancy. 
B) are easier to design. 
C) have less sophisticated security measures. 
D) require more storage space.

Question 2

_____  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 3

Conventional computing methods are able to efficiently process and manage big data.

Accepted Answer

A) True 
 B)False

Question 4

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

Accepted Answer

A) project operation 
B) join operation 
C) find operation 
D) insert operation 
A) project operation 
B) join operation 
C) find operation 
D) insert operation

Question 5

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

Accepted Answer

A) velocity 
B) volume 
C) area 
D) time 
A) velocity 
B) volume 
C) area 
D) time

Question 6

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 7

In the context of business analytics, prescriptive analytics recommends a precise course of action that a decision maker should follow and shows the likely outcome of each decision.

Accepted Answer

A) True 
 B)False

Question 8

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

Accepted Answer

A) sequential access file structure 
B) random access file structure 
C) indexed sequential access 
D) physical view access 
A) sequential access file structure 
B) random access file structure 
C) indexed sequential access 
D) physical view access

Question 9

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

Accepted Answer

Answers will vary. Data in a data wareho

Question 10

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Accepted Answer

A) True 
 B)False

Question 11

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Accepted Answer

A) Data structure 
B) Schema diagrams 
C) Integrity rules 
D) File procedure 
A) Data structure 
B) Schema diagrams 
C) Integrity rules 
D) File procedure

Question 12

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

Accepted Answer

Answers will vary. BA uses data and stat

Question 13

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

Accepted Answer

A) secondary key 
B) foreign key 
C) serial key 
D) domain key 
A) secondary key 
B) foreign key 
C) serial key 
D) domain key

Question 14

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

Accepted Answer

A) create, read, update, and delete 
B) copy, revise, undo, and define 
C) create, repeat, undo, and develop 
D) copy, read, update, and define 
A) create, read, update, and delete 
B) copy, revise, undo, and define 
C) create, repeat, undo, and develop 
D) copy, read, update, and define

Question 15

For each database, there:

Accepted Answer

A) is only one physical view of data. 
B) are only two logical views of data. 
C) are multiple physical views of data. 
D) is only one logical view of data. 
A) is only one physical view of data. 
B) are only two logical views of data. 
C) are multiple physical views of data. 
D) is only one logical view of data.

Question 16

Discuss the advantages of a database over a flat file system.

Accepted Answer

Answers will vary. A database has the fo

Question 17

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

Accepted Answer

A) database engine 
B) data-driven site 
C) static site 
D) database mine 
A) database engine 
B) data-driven site 
C) static site 
D) database mine

Question 18

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Accepted Answer

A) True 
 B)False

Question 19

Unlike data in databases, data in data warehouses is:

Accepted Answer

A) function oriented. 
B) raw transaction data. 
C) collected from a single source. 
D) used for analytical purposes. 
A) function oriented. 
B) raw transaction data. 
C) collected from a single source. 
D) used for analytical purposes.

Question 20

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.

In comparison with flat file systems, databases:

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

Conventional computing methods are able to efficiently process and manage big data.

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

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

In the context of business analytics, prescriptive analytics recommends a precise course of action that a decision maker should follow and shows the likely outcome of each decision.

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

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

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

For each database, there:

Discuss the advantages of a database over a flat file system.

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

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Unlike data in databases, data in data warehouses is:

Which statement is true of big data?

Information Systems in Business

Computers and Their Business Applications

Personal, Legal, Ethical, and Organizational Issues

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

A Connected World

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Supporting Decisions and Processes

Artificial Intelligence and Automation

Emerging Trends, Technologies, and Applications

Filters

Exam 3: Data and Business Intelligence

In comparison with flat file systems, databases:

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

Conventional computing methods are able to efficiently process and manage big data.

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

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

In the context of business analytics, prescriptive analytics recommends a precise course of action that a decision maker should follow and shows the likely outcome of each decision.

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

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

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Briefly explain the role of business analytics (BA)in decision making and compare it to business intelligence (BI).

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

For each database, there:

Discuss the advantages of a database over a flat file system.

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

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Unlike data in databases, data in data warehouses is:

Which statement is true of big data?

Information Systems in Business

Computers and Their Business Applications

Personal, Legal, Ethical, and Organizational Issues

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

A Connected World

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Supporting Decisions and Processes

Artificial Intelligence and Automation

Emerging Trends, Technologies, and Applications

Filters