Question 1

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 
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 
D) A field (or group of fields) that uniquely identifies a given attribute in a table

Question 2

Data-driven websites offer several advantages because it is far easier to manage content and store large amounts of data.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.

Accepted Answer

A) Logical; operational 
B) Physical; operational 
C) Logical; transactional 
D) Physical; transactional 
A) Logical; operational 
B) Physical; operational 
C) Logical; transactional 
D) Physical; transactional

Question 5

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 6

Which of the following is a valid type of integrity constraint?

Accepted Answer

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

Question 7

What maintains information about various types of objects, events, people, and places?

Accepted Answer

A) Database 
B) Data model 
C) Data mining 
D) Data intelligence 
A) Database 
B) Data model 
C) Data mining 
D) Data intelligence

Question 8

Data __________ issues occur when a system produces incorrect, inconsistent, or duplicate data.

Accepted Answer

The answer of Data __________ issues occur when a system...

Question 9

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) 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) Future growth analysis, sales projections, and product statistics 
D) Packing slips, grocery receipt, and competitor information

Question 10

Which of the following would not be considered part of the consistent characteristic of high-quality information?

Accepted Answer

A) Do all sales columns equal the total for the revenue column? 
B) Is the two-digit state code missing in the information? 
C) Is all summary information in agreement with detailed information? 
D) Does the order number match the item and the color options available? 
A) Do all sales columns equal the total for the revenue column? 
B) Is the two-digit state code missing in the information? 
C) Is all summary information in agreement with detailed information? 
D) Does the order number match the item and the color options available?

Question 11

The core component of any system, regardless of size, is a database and a database management system.

Accepted Answer

A) True 
 B)False

Question 12

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 
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 
D) A field (or group of fields) that uniquely identifies a given attribute in a table

Question 13

What is the physical view of information?

Accepted Answer

A) Deals with the physical storage of information on a storage device such as a hard disk 
B) Deals with the logical storage of information on a storage device such as a hard disk 
C) Focuses on how users logically access information to meet their particular business needs 
D) Focuses on how users physically access information to meet their particular business needs 
A) Deals with the physical storage of information on a storage device such as a hard disk 
B) Deals with the logical storage of information on a storage device such as a hard disk 
C) Focuses on how users logically access information to meet their particular business needs 
D) Focuses on how users physically access information to meet their particular business needs

Question 14

What does extraction, transformation, and loading mean?

Accepted Answer

A) It is a process of entering data, tracking data, and loading it into a database. 
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse. 
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube. 
D) It is a process that is performed at the beginning of the data mining model. 
A) It is a process of entering data, tracking data, and loading it into a database. 
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse. 
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube. 
D) It is a process that is performed at the beginning of the data mining model.

Question 15

Which of the following illustrates the primary concepts of the relational database model?

Accepted Answer

A) Ethics, applications, keys, and relationships 
B) Entities, attributes, keys, and relationships 
C) Endeavor, aspire, control, and regulate 
D) Early, after, before, and future 
A) Ethics, applications, keys, and relationships 
B) Entities, attributes, keys, and relationships 
C) Endeavor, aspire, control, and regulate 
D) Early, after, before, and future

Question 16

The three primary data models for organizing information in a DBMS are hierarchical, network, and metadata.

Accepted Answer

A) True 
 B)False

Question 17

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which of the following does not represent a company that requires up-to-the-second information?

Accepted Answer

A) 911 response units 
B) Stock traders 
C) Banks 
D) Construction companies 
A) 911 response units 
B) Stock traders 
C) Banks 
D) Construction companies

Question 20

What is it called when each transaction, entity, and event is represented only once in the information?

Accepted Answer

A) Uniqueness 
B) Accuracy 
C) Consistency 
D) Timeliness 
A) Uniqueness 
B) Accuracy 
C) Consistency 
D) Timeliness

What is a foreign key?

Data-driven websites offer several advantages because it is far easier to manage content and store large amounts of data.

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

A data warehouse is a _ collection of information, gathered from many different ___ databases, that supports business analysis activities and decision-making tasks.

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

Which of the following is a valid type of integrity constraint?

What maintains information about various types of objects, events, people, and places?

Data __________ issues occur when a system produces incorrect, inconsistent, or duplicate data.

Which of the following are examples of analytical information?

Which of the following would not be considered part of the consistent characteristic of high-quality information?

The core component of any system, regardless of size, is a database and a database management system.

What is a primary key?

What is the physical view of information?

What does extraction, transformation, and loading mean?

Which of the following illustrates the primary concepts of the relational database model?

The three primary data models for organizing information in a DBMS are hierarchical, network, and metadata.

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

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

Which of the following does not represent a company that requires up-to-the-second information?

What is it called when each transaction, entity, and event is represented only once in the information?

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters

Exam 6: Data: Business Intelligence

What is a foreign key?

Data-driven websites offer several advantages because it is far easier to manage content and store large amounts of data.

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

A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.

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

Which of the following is a valid type of integrity constraint?

What maintains information about various types of objects, events, people, and places?

Data __________ issues occur when a system produces incorrect, inconsistent, or duplicate data.

Which of the following are examples of analytical information?

Which of the following would not be considered part of the consistent characteristic of high-quality information?

The core component of any system, regardless of size, is a database and a database management system.

What is a primary key?

What is the physical view of information?

What does extraction, transformation, and loading mean?

Which of the following illustrates the primary concepts of the relational database model?

The three primary data models for organizing information in a DBMS are hierarchical, network, and metadata.

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

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

Which of the following does not represent a company that requires up-to-the-second information?

What is it called when each transaction, entity, and event is represented only once in the information?

Management Information Systems: Business Driven MIS

Decision and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructure: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software

Networks and Telecommunications

Designing Databases

Filters

A data warehouse is a _ collection of information, gathered from many different ___ databases, that supports business analysis activities and decision-making tasks.