Question 1

Which of the following uses a DBMS to interact with a database?

Accepted Answer

A)  Users of accounting programs 
B)  Users of human resource programs 
C)  Users of marketing programs 
D)  All of these choices are correct. 
A)  Users of accounting programs 
B)  Users of human resource programs 
C)  Users of marketing programs 
D)  All of these choices are correct.

Question 2

In the relational database model, what are characteristics or properties of an entity class?

Accepted Answer

A)  Entity 
B)  Entity class 
C)  Attribute 
D)  Attribute class 
A)  Entity 
B)  Entity class 
C)  Attribute 
D)  Attribute class

Question 3

Which of the following determines values for an unknown continuous variable behaviour?

Accepted Answer

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

Question 4

The primary purpose of a data warehouse is to aggregate transactional data into analytical information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

Accepted Answer

A) True 
 B)False

Question 5

Data warehousing is about extending the transformation of transactional data into ______ information.

Accepted Answer

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

Question 6

The trade-off for perfect information lies in accuracy versus _____.

Accepted Answer

The answer of The trade-off for perfect information lies in...

Question 7

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 of these choices 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 of these choices are correct.

Question 8

Customer ID, Customer Name, Contact Name, and Customer Phone are all types of ____________.

Accepted Answer

The answer of Customer ID, Customer Name, Contact Name, and...

Question 9

Data-mining tools apply algorithms to information sets to uncover inherent trends and patterns in the information, which analysts use to develop new business strategies.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following occurs during data (or information) cleansing?

Accepted Answer

A)  Clean missing records 
B)  Clean redundant records 
C)  Clean inaccurate data 
D)  All of these choices are correct. 
A)  Clean missing records 
B)  Clean redundant records 
C)  Clean inaccurate data 
D)  All of these choices are correct.

Question 11

Identify the importance of ensuring the cleanliness of information throughout an organization.

Accepted Answer

An organization must maintain high quali

Question 12

The central concept of a database is that of a collection of records.

Accepted Answer

A) True 
 B)False

Question 13

What is a primary 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 14

To manage and organize various tables within the relational database model, developers must identify primary keys and foreign keys and use them to create _____.

Accepted Answer

logical re

Question 15

Explain why an organization cannot achieve 100 percent accurate and complete information.

Accepted Answer

Achieving perfect information is almost

Question 16

All of the following are reasons why operational systems are not appropriate for business analysis, except:

Accepted Answer

A)  Does not include information from other operational applications 
B)  Operational systems are integrated 
C)  Operational information is mainly current 
D)  Operational information frequently has quality issues 
A)  Does not include information from other operational applications 
B)  Operational systems are integrated 
C)  Operational information is mainly current 
D)  Operational information frequently has quality issues

Question 17

All of the following are advantages of database-stored information, except:

Accepted Answer

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

Question 18

Which of the following measures how quickly a system performs a certain process or transaction?

Accepted Answer

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

Question 19

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

Accepted Answer

A)  Uses additional hard disk space 
B)  Makes performing information updates harder 
C)  Improves information quality 
D)  All of these choices are correct. 
A)  Uses additional hard disk space 
B)  Makes performing information updates harder 
C)  Improves information quality 
D)  All of these choices are correct.

Question 20

Segment customers based on postal codes is a kind of:

Accepted Answer

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

Which of the following uses a DBMS to interact with a database?

In the relational database model, what are characteristics or properties of an entity class?

Which of the following determines values for an unknown continuous variable behaviour?

The primary purpose of a data warehouse is to aggregate transactional data into analytical information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

Data warehousing is about extending the transformation of transactional data into ______ information.

The trade-off for perfect information lies in accuracy versus _____.

Which of the following describes ETL?

Customer ID, Customer Name, Contact Name, and Customer Phone are all types of ____________.

Data-mining tools apply algorithms to information sets to uncover inherent trends and patterns in the information, which analysts use to develop new business strategies.

Which of the following occurs during data (or information) cleansing?

Identify the importance of ensuring the cleanliness of information throughout an organization.

The central concept of a database is that of a collection of records.

What is a primary key?

To manage and organize various tables within the relational database model, developers must identify primary keys and foreign keys and use them to create _____.

Explain why an organization cannot achieve 100 percent accurate and complete information.

All of the following are reasons why operational systems are not appropriate for business analysis, except:

All of the following are advantages of database-stored information, except:

Which of the following measures how quickly a system performs a certain process or transaction?

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

Segment customers based on postal codes is a kind of:

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

Which of the following uses a DBMS to interact with a database?

In the relational database model, what are characteristics or properties of an entity class?

Which of the following determines values for an unknown continuous variable behaviour?

The primary purpose of a data warehouse is to aggregate transactional data into analytical information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.

Data warehousing is about extending the transformation of transactional data into ______ information.

The trade-off for perfect information lies in accuracy versus _____.

Which of the following describes ETL?

Customer ID, Customer Name, Contact Name, and Customer Phone are all types of ____________.

Data-mining tools apply algorithms to information sets to uncover inherent trends and patterns in the information, which analysts use to develop new business strategies.

Which of the following occurs during data (or information) cleansing?

Identify the importance of ensuring the cleanliness of information throughout an organization.

The central concept of a database is that of a collection of records.

What is a primary key?

To manage and organize various tables within the relational database model, developers must identify primary keys and foreign keys and use them to create _____.

Explain why an organization cannot achieve 100 percent accurate and complete information.

All of the following are reasons why operational systems are not appropriate for business analysis, except:

All of the following are advantages of database-stored information, except:

Which of the following measures how quickly a system performs a certain process or transaction?

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

Segment customers based on postal codes is a kind of:

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