Question 1

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A) To create an entity 
B) To create physical relationships 
C) To create logical relationships 
D) To create an attribute 
A) To create an entity 
B) To create physical relationships 
C) To create logical relationships 
D) To create an attribute

Question 2

A ____________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule.

Accepted Answer

The answer of A ____________ rule defines how a company...

Question 3

What are the rules that help ensure the quality of information?

Accepted Answer

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

Question 4

What are the primary differences between a data warehouse and a data mart?

Accepted Answer

A) Data warehouses make quick decisions,data marts make slow decisions 
B) Data warehouse tackle ethical issues,data marts tackle hypothetical issues 
C) Data warehouses have a more organization-wide focus,data marts have functional focus 
D) Data warehouses have a physical focus,data marts have logical focus 
A) Data warehouses make quick decisions,data marts make slow decisions 
B) Data warehouse tackle ethical issues,data marts tackle hypothetical issues 
C) Data warehouses have a more organization-wide focus,data marts have functional focus 
D) Data warehouses have a physical focus,data marts have logical focus

Question 5

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 behavior 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 behavior and guide decision making 
D) Process of analyzing data to extract information not offered by the raw data alone

Question 6

_____________ provides details about data.

Accepted Answer

The answer of _____________ provides details about data....

Question 7

A data ______________ compiles all of the metadata about the data elements in the data model.

Accepted Answer

The answer of A data ______________ compiles all of the...

Question 8

Within the data warehouse model,the internal databases could include marketing,sales,inventory,and billing.

Accepted Answer

A) True 
 B)False

Question 9

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

Accepted Answer

A) Improvements 
B) Change 
C) Clustering 
D) Cleansing 
A) Improvements 
B) Change 
C) Clustering 
D) Cleansing

Question 10

Real-time ___________ provide real-time information in response to requests.

Accepted Answer

The answer of Real-time ___________ provide real-time information in response...

Question 11

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 12

What is data redundancy?

Accepted Answer

A) Duplication of data 
B) Storing the same data in multiple places 
C) Storing duplicate data in multiple places 
D) All of the above 
A) Duplication of data 
B) Storing the same data in multiple places 
C) Storing duplicate data in multiple places 
D) All of the above

Question 13

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

Accepted Answer

The answer of Association ___________ reveals the relationship between variables...

Question 14

What is stored in a dynamic catalog,or an area of a website that stores information about products in a database?

Accepted Answer

A) Dynamic website 
B) Data-driven website 
C) Static information 
D) Dynamic information 
A) Dynamic website 
B) Data-driven website 
C) Static information 
D) Dynamic information

Question 15

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) None of the above 
A) Relational integrity constraint 
B) Business-critical integrity constraint 
C) Information-critical integrity constraint 
D) None of the above

Question 17

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

Accepted Answer

A) Is the zip code missing in the address? 
B) Is the information current with respect to business needs? 
C) Is the customer address current? 
D) Is the information updated weekly or hourly? 
A) Is the zip code missing in the address? 
B) Is the information current with respect to business needs? 
C) Is the customer address current? 
D) Is the information updated weekly or hourly?

Question 18

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

Accepted Answer

A) A database can be relational or network 
B) Database information is accessed by logical structure 
C) Database information is accessed by physical structure 
D) Database users can have different views of information 
A) A database can be relational or network 
B) Database information is accessed by logical structure 
C) Database information is accessed by physical structure 
D) Database users can have different views of information

Question 19

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 20

Static information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Why do relational databases use primary keys and foreign keys?

A ____________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule.

What are the rules that help ensure the quality of information?

What are the primary differences between a data warehouse and a data mart?

What is data mining?

_____________ provides details about data.

A data ______________ compiles all of the metadata about the data elements in the data model.

Within the data warehouse model,the internal databases could include marketing,sales,inventory,and billing.

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

Real-time ___________ provide real-time information in response to requests.

What is a foreign key?

What is data redundancy?

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

What is stored in a dynamic catalog,or an area of a website that stores information about products in a database?

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

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

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

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

The financial industry uses business intelligence to predict hardware failures.

Static information includes data that change based on user actions.

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Filters

Exam 6: Data: Business Intelligence

Why do relational databases use primary keys and foreign keys?

A ____________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule.

What are the rules that help ensure the quality of information?

What are the primary differences between a data warehouse and a data mart?

What is data mining?

_____________ provides details about data.

A data ______________ compiles all of the metadata about the data elements in the data model.

Within the data warehouse model,the internal databases could include marketing,sales,inventory,and billing.

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.

Real-time ___________ provide real-time information in response to requests.

What is a foreign key?

What is data redundancy?

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

What is stored in a dynamic catalog,or an area of a website that stores information about products in a database?

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

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

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

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

The financial industry uses business intelligence to predict hardware failures.

Static information includes data that change based on user actions.

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Filters