Question 1

There are, to date, many legal requirements for protecting privacy while using big data analytics.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

Answers will vary. ETL refers to the pro

Question 3

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____ .

Accepted Answer

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

Question 4

Although a database can consist of only a single file, it is usually a group of files.

Accepted Answer

A) True 
 B)False

Question 5

Data warehouses are sometimes called hypercubes because they _____.

Accepted Answer

A) are function oriented 
B) store multidimensional data 
C) capture raw transaction data 
D) manage transactions 
A) are function oriented 
B) store multidimensional data 
C) capture raw transaction data 
D) manage transactions

Question 6

_____ , used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

Accepted Answer

A) Fragmentation 
B) Encapsulation 
C) Inheritance 
D) Counterbalance 
A) Fragmentation 
B) Encapsulation 
C) Inheritance 
D) Counterbalance

Question 7

Briefly explain a relational model.

Accepted Answer

Answers will vary. A relational model us

Question 8

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 9

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

Question 10

In the context of segmentation of customers in database marketing, _____ is a variable that includes gender, age, income, and marital status.

Accepted Answer

A) strategical information 
B) geographical information 
C) psychographic information 
D) demographic information 
A) strategical information 
B) geographical information 
C) psychographic information 
D) demographic information

Question 11

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

Accepted Answer

A) physical view 
B) logical view 
C) rational view 
D) analytical view 
A) physical view 
B) logical view 
C) rational view 
D) analytical view

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

Accepted Answer

A) data-driven Web site 
B) flat Web page 
C) stationary Web page 
D) static Web site 
A) data-driven Web site 
B) flat Web page 
C) stationary Web page 
D) static Web site

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Describe the features and benefits of an object-oriented database.

Accepted Answer

Answers will vary. Like object-oriented

Question 16

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

Accepted Answer

Answers will vary. In a random access fi

Question 17

To begin designing a relational database, you 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 18

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

Accepted Answer

A) why the buyer buys a product or service 
B) who the buyer is 
C) how the buyer buys a product or service 
D) where the buyer is 
A) why the buyer buys a product or service 
B) who the buyer is 
C) how the buyer buys a product or service 
D) where the buyer is

Question 19

Briefly discuss the advantages and disadvantages of database marketing.

Accepted Answer

Answers will vary. Database marketing of

Question 20

_____ analysis  is used to discover patterns and relationships.

Accepted Answer

A) Data mart 
B) Data-mining 
C) Data pattern 
D) Data-toggling 
A) Data mart 
B) Data-mining 
C) Data pattern 
D) Data-toggling

There are, to date, many legal requirements for protecting privacy while using big data analytics.

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

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____ .

Although a database can consist of only a single file, it is usually a group of files.

Data warehouses are sometimes called hypercubes because they _____.

_____ , used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

Briefly explain a relational model.

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

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

In the context of segmentation of customers in database marketing, _____ is a variable that includes gender, age, income, and marital status.

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

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

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

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

Describe the features and benefits of an object-oriented database.

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

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

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

Briefly discuss the advantages and disadvantages of database marketing.

_____ analysis is used to discover patterns and relationships.

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

There are, to date, many legal requirements for protecting privacy while using big data analytics.

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

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____ .

Although a database can consist of only a single file, it is usually a group of files.

Data warehouses are sometimes called hypercubes because they _____.

_____ , used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

Briefly explain a relational model.

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

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

In the context of segmentation of customers in database marketing, _____ is a variable that includes gender, age, income, and marital status.

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

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

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

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

Describe the features and benefits of an object-oriented database.

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

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

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

Briefly discuss the advantages and disadvantages of database marketing.

_____ analysis is used to discover patterns and relationships.

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