Question 1

Define data mining,and explain the three common forms for mining structured and unstructured data.

Accepted Answer

Data mining is the process of analyzing

Question 2

Which of the below represents a reason why data warehouses were created?

Accepted Answer

A) Numbers and types of operational databases increased as businesses grew 
B) Many companies had information scattered across multiple systems with different formats 
C) Completing reporting requests from numerous operational systems took days or weeks 
D) All of the above 
A) Numbers and types of operational databases increased as businesses grew 
B) Many companies had information scattered across multiple systems with different formats 
C) Completing reporting requests from numerous operational systems took days or weeks 
D) All of the above

Question 3

What is the role of a foreign key?

Accepted Answer

A) It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables 
B) It is a unique way to identify each record 
C) Is a field that uniquely identifies a give record in a table 
D) All of the above 
A) It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables 
B) It is a unique way to identify each record 
C) Is a field that uniquely identifies a give record in a table 
D) All of the above

Question 4

What is the overall management of the availability,usability,integrity,and security of company data?

Accepted Answer

A) Data Intelligence 
B) Data governance 
C) Data forbearance 
D) Data forecasting 
A) Data Intelligence 
B) Data governance 
C) Data forbearance 
D) Data forecasting

Question 5

Which of the following is true in regards to the elimination of redundant data?

Accepted Answer

A) Uses additional hard disk space 
B) Makes performing information updates harder 
C) Improves information quality 
D) All of the above 
A) Uses additional hard disk space 
B) Makes performing information updates harder 
C) Improves information quality 
D) All of the above

Question 6

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 7

A relational database management system allows users to create,read,update,and delete data in a relational __________________.

Accepted Answer

The answer of A relational database management system allows users...

Question 8

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

Accepted Answer

A) Improvements 
B) Change 
C) Clustering 
D) Cleansing 
A) Improvements 
B) Change 
C) Clustering 
D) Cleansing

Question 9

_________ mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Accepted Answer

The answer of _________ mining analyzes unstructured data associated with...

Question 10

Which of the below questions can be answered using business intelligence?

Accepted Answer

A) Where has the business been? 
B) Where is the business now? 
C) Where is the business going? 
D) All of the above. 
A) Where has the business been? 
B) Where is the business now? 
C) Where is the business going? 
D) All of the above.

Question 11

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

Accepted Answer

A) Quality business constraints 
B) Critical web constraints 
C) Business critical integrity constraints 
D) Web integrity constraints 
A) Quality business constraints 
B) Critical web constraints 
C) Business critical integrity constraints 
D) Web integrity constraints

Question 12

In the relational database model,what is a person,place,thing,transaction,or event about which information is stored?

Accepted Answer

A) Entity 
B) Relationships 
C) Attribute 
D) Foreign Key 
A) Entity 
B) Relationships 
C) Attribute 
D) Foreign Key

Question 13

Web mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following encompasses all organizational information,and its primary purpose is to support the performing of managerial analysis tasks?

Accepted Answer

A) Analytical information 
B) Transactional information 
C) Statistical information 
D) Targeted information 
A) Analytical information 
B) Transactional information 
C) Statistical information 
D) Targeted information

Question 15

A database maintains information on ___________.

Accepted Answer

A) Inventory 
B) Transactions 
C) Employees 
D) All of the above 
A) Inventory 
B) Transactions 
C) Employees 
D) All of the above

Question 16

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A) It is only available to high-level executives due to the expense 
B) It is only available in aggregate levels of granularity 
C) It continually changes 
D) It rarely changes 
A) It is only available to high-level executives due to the expense 
B) It is only available in aggregate levels of granularity 
C) It continually changes 
D) It rarely changes

Question 17

Which of the following is a disadvantage of database-stored information?

Accepted Answer

A) Increased flexibility 
B) Increased performance 
C) Increased data redundancy 
D) Increased data integrity 
A) Increased flexibility 
B) Increased performance 
C) Increased data redundancy 
D) Increased data integrity

Question 18

Data _______________ refers to the overall management of the availability,usability,integrity,and security of company data.

Accepted Answer

The answer of Data _______________ refers to the overall management...

Question 19

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Accepted Answer

A) True 
 B)False

Question 20

______________ is accessing large amounts of data from different management information systems.

Accepted Answer

The answer of ______________ is accessing large amounts of data...

Define data mining,and explain the three common forms for mining structured and unstructured data.

Which of the below represents a reason why data warehouses were created?

What is the role of a foreign key?

What is the overall management of the availability,usability,integrity,and security of company data?

Which of the following is true in regards to the elimination of redundant data?

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

A relational database management system allows users to create,read,update,and delete data in a relational __________________.

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

_________ mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Which of the below questions can be answered using business intelligence?

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

In the relational database model,what is a person,place,thing,transaction,or event about which information is stored?

Web mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Which of the following encompasses all organizational information,and its primary purpose is to support the performing of managerial analysis tasks?

A database maintains information on ___________.

What is one of the biggest pitfalls associated with real-time information?

Which of the following is a disadvantage of database-stored information?

Data _______________ refers to the overall management of the availability,usability,integrity,and security of company data.

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

______________ is accessing large amounts of data from different management information systems.

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: Mis Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Filters

Exam 6: Data: Business Intelligence

Define data mining,and explain the three common forms for mining structured and unstructured data.

Which of the below represents a reason why data warehouses were created?

What is the role of a foreign key?

What is the overall management of the availability,usability,integrity,and security of company data?

Which of the following is true in regards to the elimination of redundant data?

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

A relational database management system allows users to create,read,update,and delete data in a relational __________________.

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

_________ mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Which of the below questions can be answered using business intelligence?

Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?

In the relational database model,what is a person,place,thing,transaction,or event about which information is stored?

Web mining analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Which of the following encompasses all organizational information,and its primary purpose is to support the performing of managerial analysis tasks?

A database maintains information on ___________.

What is one of the biggest pitfalls associated with real-time information?

Which of the following is a disadvantage of database-stored information?

Data _______________ refers to the overall management of the availability,usability,integrity,and security of company data.

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

______________ is accessing large amounts of data from different management information systems.

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: Mis Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Filters