Question 1

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A)  To create a database 
B)  To create physical relationships 
C)  To create logical relationships 
D)  All of these choices are correct. 
A)  To create a database 
B)  To create physical relationships 
C)  To create logical relationships 
D)  All of these choices are correct.

Question 2

The computer program used to manage and query a database is known as a:

Accepted Answer

A)  Database 
B)  Business Intelligence 
C)  Schema 
D)  Database Management System 
A)  Database 
B)  Business Intelligence 
C)  Schema 
D)  Database Management System

Question 3

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

The answer of _____________ cleansing or scrubbing is the process...

Question 4

List the four primary sources of low-quality information.

Accepted Answer

(1) Online customers intentionally enter

Question 5

A(n) _______________ key is a field that uniquely identifies a given entity in a table.

Accepted Answer

The answer of A(n) _______________ key is a field that...

Question 6

______ integrity is a measure of the quality of data.

Accepted Answer

The answer of ______ integrity is a measure of the...

Question 7

_______ are predictions made on the basis of time series information.

Accepted Answer

The answer of _______ are predictions made on the basis...

Question 8

What is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Accepted Answer

A)  Association detection 
B)  Market basket analysis 
C)  Cluster analysis 
D)  Intelligent agent 
A)  Association detection 
B)  Market basket analysis 
C)  Cluster analysis 
D)  Intelligent agent

Question 9

Bill Inmon, who is known as the "Father of Data Warehousing." describes a data warehouse as a subject-oriented, integrated, time-variant, and non-volatile collection of information. What do these terms mean?

Accepted Answer

Subject-oriented means that information

Question 10

Data mining approaches decision making with these different activities in mind:

Accepted Answer

A)  Classification 
B)  Estimation 
C)  Affinity grouping 
D)  All of these choices are correct. 
A)  Classification 
B)  Estimation 
C)  Affinity grouping 
D)  All of these choices are correct.

Question 11

Most professionals consider a collection of data to constitute a database must have the following properties:

Accepted Answer

A)  Data Integrity 
B)  Data Quality 
C)  Data Shared Access 
D)  All of these choices are correct. 
A)  Data Integrity 
B)  Data Quality 
C)  Data Shared Access 
D)  All of these choices are correct.

Question 12

Data warehousing is about extending the transformation of data into _________.

Accepted Answer

The answer of Data warehousing is about extending the transformation...

Question 13

What reveals the degree to which variables are related and the nature and frequency of these relationships in the information?

Accepted Answer

A)  Association detection 
B)  Market basket analysis 
C)  Cluster analysis 
D)  Intelligent agent 
A)  Association detection 
B)  Market basket analysis 
C)  Cluster analysis 
D)  Intelligent agent

Question 14

Which of the following database structures offers a flexible way of representing objects and their relationships?

Accepted Answer

A)  Hierarchical database 
B)  Network database 
C)  Relational database model 
D)  All of these choices are correct. 
A)  Hierarchical database 
B)  Network database 
C)  Relational database model 
D)  All of these choices are correct.

Question 15

A birth date of 31/02/1991 is an example of ______ but _______ information.

Accepted Answer

A)  complete; inaccurate 
B)  accurate; incomplete 
C)  incomplete; accurate 
D)  complete; accurate 
A)  complete; inaccurate 
B)  accurate; incomplete 
C)  incomplete; accurate 
D)  complete; accurate

Question 16

What refers to how well a system can adapt to increased demands?

Accepted Answer

A)  Scalability 
B)  Performance 
C)  Redundancy 
D)  Information integrity 
A)  Scalability 
B)  Performance 
C)  Redundancy 
D)  Information integrity

Question 17

Which of the following is correct in reference to a database?

Accepted Answer

A)  A database can support only one logical view 
B)  A database can support many physical views 
C)  A database can support many logical views 
D)  A database can support up to 3 logical views 
A)  A database can support only one logical view 
B)  A database can support many physical views 
C)  A database can support many logical views 
D)  A database can support up to 3 logical views

Question 18

Having a data-driven website enables the site to grow faster than would be possible with a static site.

Accepted Answer

A) True 
 B)False

Question 19

List and describe the various benefits an organization can expect to receive from BI deployment?

Accepted Answer

Direct quantifiable benefits include wor

Question 20

Which of the following segments a heterogeneous population of records into a number of more homogeneous subgroups?

Accepted Answer

A)  Classification 
B)  Estimation 
C)  Affinity grouping 
D)  Clustering 
A)  Classification 
B)  Estimation 
C)  Affinity grouping 
D)  Clustering

Why do relational databases use primary keys and foreign keys?

The computer program used to manage and query a database is known as a:

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

List the four primary sources of low-quality information.

A(n) _______________ key is a field that uniquely identifies a given entity in a table.

______ integrity is a measure of the quality of data.

_______ are predictions made on the basis of time series information.

What is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Bill Inmon, who is known as the "Father of Data Warehousing." describes a data warehouse as a subject-oriented, integrated, time-variant, and non-volatile collection of information. What do these terms mean?

Data mining approaches decision making with these different activities in mind:

Most professionals consider a collection of data to constitute a database must have the following properties:

Data warehousing is about extending the transformation of data into _________.

What reveals the degree to which variables are related and the nature and frequency of these relationships in the information?

Which of the following database structures offers a flexible way of representing objects and their relationships?

A birth date of 31/02/1991 is an example of but _ information.

What refers to how well a system can adapt to increased demands?

Which of the following is correct in reference to a database?

Having a data-driven website enables the site to grow faster than would be possible with a static site.

List and describe the various benefits an organization can expect to receive from BI deployment?

Which of the following segments a heterogeneous population of records into a number of more homogeneous subgroups?

Information Systems in Business

Strategic Decision Making

E-Business

It Architectures

Databases and Data Warehouses

Networks, Telecommunications, and Wireless Computing

Supply Chain Management

Customer Relationship Management

Enterprise Resource Planning and Collaboration Systems

Business Basics

Business Process

Filters

Exam 4: Ethics and Information Security

Why do relational databases use primary keys and foreign keys?

The computer program used to manage and query a database is known as a:

_____________ cleansing or scrubbing is the process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

List the four primary sources of low-quality information.

A(n) _______________ key is a field that uniquely identifies a given entity in a table.

______ integrity is a measure of the quality of data.

_______ are predictions made on the basis of time series information.

What is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Bill Inmon, who is known as the "Father of Data Warehousing." describes a data warehouse as a subject-oriented, integrated, time-variant, and non-volatile collection of information. What do these terms mean?

Data mining approaches decision making with these different activities in mind:

Most professionals consider a collection of data to constitute a database must have the following properties:

Data warehousing is about extending the transformation of data into _________.

What reveals the degree to which variables are related and the nature and frequency of these relationships in the information?

Which of the following database structures offers a flexible way of representing objects and their relationships?

A birth date of 31/02/1991 is an example of ______ but _______ information.

What refers to how well a system can adapt to increased demands?

Which of the following is correct in reference to a database?

Having a data-driven website enables the site to grow faster than would be possible with a static site.

List and describe the various benefits an organization can expect to receive from BI deployment?

Which of the following segments a heterogeneous population of records into a number of more homogeneous subgroups?

Information Systems in Business

Strategic Decision Making

E-Business

It Architectures

Databases and Data Warehouses

Networks, Telecommunications, and Wireless Computing

Supply Chain Management

Customer Relationship Management

Enterprise Resource Planning and Collaboration Systems

Business Basics

Business Process

Filters

A birth date of 31/02/1991 is an example of but _ information.