Question 1

Which statement is true of database marketing?

Accepted Answer

A) It works by using univariate analysis to transform marketing from a proactive to a reactive process. 
B) It works by utilizing information that can be found outside the organizational database. 
C) It makes an organization responsive to the needs of its customers. 
D) It allows an organization to resist changes in the marketplace.

Question 2

In a(n)_____  access file structure , records can be accessed in any order, regardless of their physical locations in storage media.

Accepted Answer

A) sequential 
B) random 
C) indexed 
D) direct

Question 3

The advantage of the _____ access  method   is that both sequential and random access can be used to access records, depending on the number being accessed.

Accepted Answer

A) indexed sequential 
B) progressive 
C) direct random 
D) random-serialized

Question 4

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 5

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

Accepted Answer

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

Question 6

Data markets focus on business functions for the marketing department of an organization.

Accepted Answer

A) True 
 B)False

Question 7

Which component of a database management system (DBMS)is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

Accepted Answer

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

Question 8

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

Question 9

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

Question 10

The data _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

Accepted Answer

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

Question 11

In the context of database marketing, demographics data explains which of the following?

Accepted Answer

A) Why the buyer buys a product or service. 
B) Who the buyer is. 
C) Which product generated the highest sales. 
D) How buyers interact with an app.

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

Which component 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

Question 15

In the context of business analytics, mobile analytics is declining in popularity.

Accepted Answer

A) True 
 B)False

Question 16

Explain how information in a database is observed through the physical view and the logical view.

Accepted Answer

The answer of Explain how information in a database is...

Question 17

A _____  is software for creating, storing, maintaining, and accessing database files.

Accepted Answer

A) database management system 
B) data hierarchical system 
C) database modelling tool 
D) data warehousing tool

Question 18

Explain key features and uses of Power BI in the context of business intelligence and data visualization.

Accepted Answer

The answer of Explain key features and uses of Power...

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

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Accepted Answer

A) predictive modeling 
B) dashboards 
C) query reports 
D) application generators

Exam 3: Data and Business Intelligence

Which statement is true of database marketing?

In a(n) _____ access file structure , records can be accessed in any order, regardless of their physical locations in storage media.

The advantage of the _____ access method is that both sequential and random access can be used to access records, depending on the number being accessed.

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

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

Data markets focus on business functions for the marketing department of an organization.

Which component of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

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

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

The data _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

In the context of database marketing, demographics data explains which of the following?

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

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

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

In the context of business analytics, mobile analytics is declining in popularity.

Explain how information in a database is observed through the physical view and the logical view.

A _____ is software for creating, storing, maintaining, and accessing database files.

Explain key features and uses of Power BI in the context of business intelligence and data visualization.

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

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.