Question 1

A schematic of the entire database that describes the relationships in a database is called a(n)

Accepted Answer

A)  data dictionary. 
B)  intersection relationship diagram. 
C)  entity-relationship diagram. 
D)  data definition diagram. 
E)  data analysis table. 
A)  data dictionary. 
B)  intersection relationship diagram. 
C)  entity-relationship diagram. 
D)  data definition diagram. 
E)  data analysis table. C

Question 2

The logical view of a database

Accepted Answer

A)  displays the organization and structure of data on the physical storage media. 
B)  includes a digital dashboard. 
C)  allows the creation of supplementary reports. 
D)  enables users to manipulate the logical structure of the database. 
E)  presents data as they would be perceived by end users. 
A)  displays the organization and structure of data on the physical storage media. 
B)  includes a digital dashboard. 
C)  allows the creation of supplementary reports. 
D)  enables users to manipulate the logical structure of the database. 
E)  presents data as they would be perceived by end users. E

Question 3

An attribute is a characteristic or quality used to describe a particular entity.

Accepted Answer

A) True 
 B)False  True

Question 4

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

Accepted Answer

A)  data auditing. 
B)  defragmentation. 
C)  data scrubbing. 
D)  data optimization. 
E)  data normalization. 
A)  data auditing. 
B)  defragmentation. 
C)  data scrubbing. 
D)  data optimization. 
E)  data normalization.

Question 5

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

Data redundancy occurs when different di

Question 6

The relationship between entities and attributes is best illustrated by

Accepted Answer

A)  the entity CUSTOMER with the attribute PRODUCT. 
B)  the entity CUSTOMER with the attribute PURCHASE. 
C)  the entity PRODUCT with the attribute PURCHASE. 
D)  the entity PRODUCT with the attribute CUSTOMER. 
E)  the entity PURCHASE with the attribute CUSTOMER. 
A)  the entity CUSTOMER with the attribute PRODUCT. 
B)  the entity CUSTOMER with the attribute PURCHASE. 
C)  the entity PRODUCT with the attribute PURCHASE. 
D)  the entity PRODUCT with the attribute CUSTOMER. 
E)  the entity PURCHASE with the attribute CUSTOMER.

Question 7

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

Accepted Answer

A) True 
 B)False

Question 8

A(n) ________ is an example of non-digital data storage that is comparable to a database.

Accepted Answer

A)  library card catalog 
B)  cash register receipt 
C)  doctor's office invoice 
D)  list of sales totals on a spreadsheet 
E)  schedule of due dates on a project outline 
A)  library card catalog 
B)  cash register receipt 
C)  doctor's office invoice 
D)  list of sales totals on a spreadsheet 
E)  schedule of due dates on a project outline

Question 9

When the same attribute in related data files has different values, this is called data

Accepted Answer

A)  redundancy. 
B)  duplication. 
C)  dependence. 
D)  discrepancy. 
E)  inconsistency. 
A)  redundancy. 
B)  duplication. 
C)  dependence. 
D)  discrepancy. 
E)  inconsistency.

Question 10

Data ________ occurs when the same data is duplicated in multiple files of a database.

Accepted Answer

A)  redundancy 
B)  repetition 
C)  independence 
D)  partitions 
E)  discrepancy 
A)  redundancy 
B)  repetition 
C)  independence 
D)  partitions 
E)  discrepancy

Question 11

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Accepted Answer

Sales databases could be used to make th

Question 12

What are the differences between data mining and OLAP?
 When would you advise a company to use OLAP?

Accepted Answer

Data mining uncovers hidden relationship

Question 13

The data dictionary serves as an important data management tool by

Accepted Answer

A)  assigning attributes to the data. 
B)  creating an inventory of the data elements contained in the database. 
C)  presenting data as end users or business specialists would perceive them. 
D)  maintaining data in updated form. 
E)  providing a guide to database terms and settings. 
A)  assigning attributes to the data. 
B)  creating an inventory of the data elements contained in the database. 
C)  presenting data as end users or business specialists would perceive them. 
D)  maintaining data in updated form. 
E)  providing a guide to database terms and settings.

Question 14

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

Accepted Answer

A)  information policy. 
B)  data definition file. 
C)  data quality audit. 
D)  data governance policy. 
E)  data policy. 
A)  information policy. 
B)  data definition file. 
C)  data quality audit. 
D)  data governance policy. 
E)  data policy.

Question 15

In terms of data relationships, associations refers to

Accepted Answer

A)  events linked over time. 
B)  patterns that describe a group to which an item belongs. 
C)  occurrences linked to a single event. 
D)  undiscovered groupings. 
E)  relationships between different customers. 
A)  events linked over time. 
B)  patterns that describe a group to which an item belongs. 
C)  occurrences linked to a single event. 
D)  undiscovered groupings. 
E)  relationships between different customers.

Question 16

DBMS have a data definition capability to specify the structure of the content of the database.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not one of the techniques used in Web mining?

Accepted Answer

A)  content mining 
B)  structure mining 
C)  server mining 
D)  usage mining 
E)  data mining 
A)  content mining 
B)  structure mining 
C)  server mining 
D)  usage mining 
E)  data mining

Question 18

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

A data definition capability to specify

Question 19

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Accepted Answer

A)  OLAP 
B)  data warehouse 
C)  data mart 
D)  Hadoop 
E)  DBMS 
A)  OLAP 
B)  data warehouse 
C)  data mart 
D)  Hadoop 
E)  DBMS

Question 20

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

Accepted Answer

A)  data normalization 
B)  data accuracy 
C)  data redundancy 
D)  data inconsistency 
E)  data duplication 
A)  data normalization 
B)  data accuracy 
C)  data redundancy 
D)  data inconsistency 
E)  data duplication

A schematic of the entire database that describes the relationships in a database is called a(n)

The logical view of a database

An attribute is a characteristic or quality used to describe a particular entity.

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

List at least three conditions that contribute to data redundancy and inconsistency.

The relationship between entities and attributes is best illustrated by

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

A(n) ________ is an example of non-digital data storage that is comparable to a database.

When the same attribute in related data files has different values, this is called data

Data ________ occurs when the same data is duplicated in multiple files of a database.

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

The data dictionary serves as an important data management tool by

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

In terms of data relationships, associations refers to

DBMS have a data definition capability to specify the structure of the content of the database.

Which of the following is not one of the techniques used in Web mining?

List and describe three main capabilities or tools of a DBMS.

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence: Databases and Information Management

A schematic of the entire database that describes the relationships in a database is called a(n)

The logical view of a database

An attribute is a characteristic or quality used to describe a particular entity.

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

List at least three conditions that contribute to data redundancy and inconsistency.

The relationship between entities and attributes is best illustrated by

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

A(n) ________ is an example of non-digital data storage that is comparable to a database.

When the same attribute in related data files has different values, this is called data

Data ________ occurs when the same data is duplicated in multiple files of a database.

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

The data dictionary serves as an important data management tool by

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

In terms of data relationships, associations refers to

DBMS have a data definition capability to specify the structure of the content of the database.

Which of the following is not one of the techniques used in Web mining?

List and describe three main capabilities or tools of a DBMS.

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters