Question 1

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

Accepted Answer

A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  None of the answers is correct 
A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  None of the answers is correct

Question 2

Which of the following are examples of transactional information?

Accepted Answer

A)  Airline ticket,sales receipts and packing slips 
B)  Trends and sales statistics 
C)  Product sales results,grocery receipts and growth projections 
D)  Airline tickets and sales growth spreadsheets 
A)  Airline ticket,sales receipts and packing slips 
B)  Trends and sales statistics 
C)  Product sales results,grocery receipts and growth projections 
D)  Airline tickets and sales growth spreadsheets

Question 3

Which of the following techniques performs such functions as information correlations,distributions,calculations and variance analysis?

Accepted Answer

A)  Clustering objective analysis 
B)  Statistical analysis 
C)  Entity modelling 
D)  Market basket analysis 
A)  Clustering objective analysis 
B)  Statistical analysis 
C)  Entity modelling 
D)  Market basket analysis

Question 4

The primary purpose of a data ___________ is to combine information (specifically,strategic information)throughout an organisation into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

Accepted Answer

The answer of The primary purpose of a data ___________...

Question 5

What is a field that uniquely identifies a given record in a table?

Accepted Answer

A)  Foreign key 
B)  Primary key 
C)  Data mining key 
D)  DBMS key 
A)  Foreign key 
B)  Primary key 
C)  Data mining key 
D)  DBMS key

Question 6

Which of the below is not an example of an advantage of using a relational database?

Accepted Answer

A)  Increased information quality 
B)  Increased flexibility 
C)  Decreased information redundancy 
D)  Decreased information security 
A)  Increased information quality 
B)  Increased flexibility 
C)  Decreased information redundancy 
D)  Decreased information security

Question 7

What are the three common forms for mining structured and unstructured data?

Accepted Answer

A)  Cluster analysis,association detection,statistical analysis 
B)  Cluster analysis,association detection,disassociation detection 
C)  Cluster analysis statistical detection,statistical analysis 
D)  Association detection,market-basket analysis,market-basket association 
A)  Cluster analysis,association detection,statistical analysis 
B)  Cluster analysis,association detection,disassociation detection 
C)  Cluster analysis statistical detection,statistical analysis 
D)  Association detection,market-basket analysis,market-basket association

Question 8

There are two main primary traits that help you determine the value of information including timeliness and quality.

Accepted Answer

A) True 
 B)False

Question 9

Many organisations find themselves in the position of being data ___________ and information poor.Even in today's electronic world,managers struggle with the challenge of turning their business data into business intelligence.

Accepted Answer

The answer of Many organisations find themselves in the position...

Question 10

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

Accepted Answer

The answer of Relational ____________ constraints are rules that enforce...

Question 11

Which of the following are examples of analytical information?

Accepted Answer

A)  Airline ticket,sales receipts and packing slips 
B)  Hotel reservation,sales receipts and packing slips 
C)  Trends,future growth analysis,sales projections and product statistics 
D)  Packing slips,grocery receipt and competitor information 
A)  Airline ticket,sales receipts and packing slips 
B)  Hotel reservation,sales receipts and packing slips 
C)  Trends,future growth analysis,sales projections and product statistics 
D)  Packing slips,grocery receipt and competitor information

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

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

Accepted Answer

A) True 
 B)False

Question 14

Broadly defined,a __________ maintains information about various types of objects,events,people and places.

Accepted Answer

The answer of Broadly defined,a __________ maintains information about various...

Question 15

The primary purpose of a data warehouse is to ____________.

Accepted Answer

A)  Combine strategic information 
B)  Organise departments 
C)  Interface between the computer and employees 
D)  All the answers are correct 
A)  Combine strategic information 
B)  Organise departments 
C)  Interface between the computer and employees 
D)  All the answers are correct

Question 16

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following describes ETL?

Accepted Answer

A)  A process that extracts information from internal and external databases 
B)  A process that transforms information using a common set of enterprise definitions 
C)  A process that loads information into a data warehouse 
D)  All the answers are correct 
A)  A process that extracts information from internal and external databases 
B)  A process that transforms information using a common set of enterprise definitions 
C)  A process that loads information into a data warehouse 
D)  All the answers are correct

Question 18

Which of the below statements means the same as easy to manage content?

Accepted Answer

A)  Website owners can make changes only with the aid of MIS professionals 
B)  The website cannot organise customer data 
C)  Users can update data-driven website with little or no training 
D)  Users with extensive training can update data-driven websites 
A)  Website owners can make changes only with the aid of MIS professionals 
B)  The website cannot organise customer data 
C)  Users can update data-driven website with little or no training 
D)  Users with extensive training can update data-driven websites

Question 19

What is it called when managers have so much data and information that they cannot make a decision?

Accepted Answer

A)  Data rich,information poor 
B)  Data rich,content poor 
C)  Data rich,communication poor 
D)  Data rich,intelligence 
A)  Data rich,information poor 
B)  Data rich,content poor 
C)  Data rich,communication poor 
D)  Data rich,intelligence

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

Which of the following are examples of transactional information?

Which of the following techniques performs such functions as information correlations,distributions,calculations and variance analysis?

The primary purpose of a data ___________ is to combine information (specifically,strategic information)throughout an organisation into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

What is a field that uniquely identifies a given record in a table?

Which of the below is not an example of an advantage of using a relational database?

What are the three common forms for mining structured and unstructured data?

There are two main primary traits that help you determine the value of information including timeliness and quality.

Many organisations find themselves in the position of being data ___________ and information poor.Even in today's electronic world,managers struggle with the challenge of turning their business data into business intelligence.

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

Which of the following are examples of analytical information?

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

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

Broadly defined,a __________ maintains information about various types of objects,events,people and places.

The primary purpose of a data warehouse is to ____________.

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Which of the following describes ETL?

Which of the below statements means the same as easy to manage content?

What is it called when managers have so much data and information that they cannot make a decision?

Competing in the Information Age

Connectivity

E-Business Mobile Business

Decisions-Processes

Technical Fundamentals

Systems Development Project Management

Managing Enterprise Architecture

Supply Chain Management and Customer Relationship Management

Enterprise Resource Planning Collaboration Systems

Ethics, Privacy-Information Security

Future Trends

Filters

Exam 8: Databases-Business Intelligence

What type of integrity constraint does not allow someone to create an order for a non-existent customer?

Which of the following are examples of transactional information?

Which of the following techniques performs such functions as information correlations,distributions,calculations and variance analysis?

The primary purpose of a data ___________ is to combine information (specifically,strategic information)throughout an organisation into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

What is a field that uniquely identifies a given record in a table?

Which of the below is not an example of an advantage of using a relational database?

What are the three common forms for mining structured and unstructured data?

There are two main primary traits that help you determine the value of information including timeliness and quality.

Many organisations find themselves in the position of being data ___________ and information poor.Even in today's electronic world,managers struggle with the challenge of turning their business data into business intelligence.

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

Which of the following are examples of analytical information?

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

Information can tell an organisation how it is currently performing and help it estimate and strategise for future plans and performance.

Broadly defined,a __________ maintains information about various types of objects,events,people and places.

The primary purpose of a data warehouse is to ____________.

Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.

Which of the following describes ETL?

Which of the below statements means the same as easy to manage content?

What is it called when managers have so much data and information that they cannot make a decision?

Competing in the Information Age

Connectivity

E-Business Mobile Business

Decisions-Processes

Technical Fundamentals

Systems Development Project Management

Managing Enterprise Architecture

Supply Chain Management and Customer Relationship Management

Enterprise Resource Planning Collaboration Systems

Ethics, Privacy-Information Security

Future Trends

Filters