Question 1

A(n) __________ is a particular attribute of information.

Accepted Answer

dimension

Question 2

What are rules that enforce basic and fundamental information-based constraints?

Accepted Answer

A)  Information integrity 
B)  Integrity constraint 
C)  Business-critical integrity constraint 
D)  Relational integrity constraint 
A)  Information integrity 
B)  Integrity constraint 
C)  Business-critical integrity constraint 
D)  Relational integrity constraint D

Question 3

Relational integrity constraints are rules that enforce basic and fundamental data constraints.

Accepted Answer

A) True 
 B)False  True

Question 4

Market basket analysis is a kind of:

Accepted Answer

A)  Cluster Analysis 
B)  Association Detection Analysis 
C)  Statistical Analysis 
D)  All of these choices are correct. 
A)  Cluster Analysis 
B)  Association Detection Analysis 
C)  Statistical Analysis 
D)  All of these choices are correct.

Question 5

What is a foreign key?

Accepted Answer

A)  A field (or group of fields) that uniquely identifies a given entity in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity class 
D)  A field (or group of fields) that uniquely identifies a given attribute in a table 
A)  A field (or group of fields) that uniquely identifies a given entity in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity class 
D)  A field (or group of fields) that uniquely identifies a given attribute in a table

Question 6

Which of the following assigns records to one of a predefined set of classes?

Accepted Answer

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

Question 7

_____ is the primary tool used to uncover BI in vast amounts of analytical information stored in data warehouse.

Accepted Answer

A)  Data mining 
B)  Data warehouse 
C)  Data cleanser 
D)  Data guard 
A)  Data mining 
B)  Data warehouse 
C)  Data cleanser 
D)  Data guard

Question 8

The ________ view of information focuses on how users logically access information to meet their particular business needs.

Accepted Answer

The answer of The ________ view of information focuses on...

Question 9

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

The answer of Data _________ is the process of analyzing...

Question 10

A type of database that stores data in the form of logically related two-dimensional tables is:

Accepted Answer

A)  Relational 
B)  Hierarchical 
C)  Network 
D)  None of these choices are correct. 
A)  Relational 
B)  Hierarchical 
C)  Network 
D)  None of these choices are correct.

Question 11

Which one of the following represents the evolution of database models (oldest model first)?

Accepted Answer

A)  Hierarchical, Relational, Network 
B)  Hierarchical, Network, Relational 
C)  Relational, Network, Hierarchical 
D)  Network, Relational, Hierarchical 
A)  Hierarchical, Relational, Network 
B)  Hierarchical, Network, Relational 
C)  Relational, Network, Hierarchical 
D)  Network, Relational, Hierarchical

Question 12

Which of the following is a form of statistical analysis?

Accepted Answer

A)  Forecasting 
B)  Market basket analysis 
C)  Cluster analysis 
D)  All of these choices are correct. 
A)  Forecasting 
B)  Market basket analysis 
C)  Cluster analysis 
D)  All of these choices are correct.

Question 13

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False

Question 14

What is data mining?

Accepted Answer

A)  The common term for the representation of multidimensional information 
B)  A particular attribute of information 
C)  Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behaviour and guide decision making 
D)  Process of analyzing data to extract information not offered by the raw data alone 
A)  The common term for the representation of multidimensional information 
B)  A particular attribute of information 
C)  Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behaviour and guide decision making 
D)  Process of analyzing data to extract information not offered by the raw data alone

Question 15

The ________ is a type of database that stores data in the form of logically related two-dimensional tables.

Accepted Answer

relational

Question 16

Ideally, an organization only wants to build forward integrations.

Accepted Answer

A) True 
 B)False

Question 17

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 18

Which one of the following is not a data (or database) model?

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Relational 
D)  DBMS 
A)  Hierarchical 
B)  Network 
C)  Relational 
D)  DBMS

Question 19

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

Accepted Answer

A)  Can be relational or network 
B)  Information is accessed by logical structure 
C)  Information is accessed by physical structure 
D)  Users can access different views of information 
A)  Can be relational or network 
B)  Information is accessed by logical structure 
C)  Information is accessed by physical structure 
D)  Users can access different views of information

Question 20

Explain the primary difference between a database and a data warehouse.

Accepted Answer

The primary difference between a databas

A(n) __________ is a particular attribute of information.

What are rules that enforce basic and fundamental information-based constraints?

Relational integrity constraints are rules that enforce basic and fundamental data constraints.

Market basket analysis is a kind of:

What is a foreign key?

Which of the following assigns records to one of a predefined set of classes?

_____ is the primary tool used to uncover BI in vast amounts of analytical information stored in data warehouse.

The ________ view of information focuses on how users logically access information to meet their particular business needs.

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

A type of database that stores data in the form of logically related two-dimensional tables is:

Which one of the following represents the evolution of database models (oldest model first)?

Which of the following is a form of statistical analysis?

The primary purpose of a data warehouse is to perform transactional processes.

What is data mining?

The ________ is a type of database that stores data in the form of logically related two-dimensional tables.

Ideally, an organization only wants to build forward integrations.

One of the advantages found in a relational database is increased information redundancy.

Which one of the following is not a data (or database) model?

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

Explain the primary difference between a database and a data warehouse.

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

A(n) __________ is a particular attribute of information.

What are rules that enforce basic and fundamental information-based constraints?

Relational integrity constraints are rules that enforce basic and fundamental data constraints.

Market basket analysis is a kind of:

What is a foreign key?

Which of the following assigns records to one of a predefined set of classes?

_____ is the primary tool used to uncover BI in vast amounts of analytical information stored in data warehouse.

The ________ view of information focuses on how users logically access information to meet their particular business needs.

Data _________ is the process of analyzing data to extract information not offered by the raw data alone.

A type of database that stores data in the form of logically related two-dimensional tables is:

Which one of the following represents the evolution of database models (oldest model first)?

Which of the following is a form of statistical analysis?

The primary purpose of a data warehouse is to perform transactional processes.

What is data mining?

The ________ is a type of database that stores data in the form of logically related two-dimensional tables.

Ideally, an organization only wants to build forward integrations.

One of the advantages found in a relational database is increased information redundancy.

Which one of the following is not a data (or database) model?

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

Explain the primary difference between a database and a data warehouse.

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