Question 1

What is the use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources?

Accepted Answer

A)   Eintegration
B)   Application integration
C)   Data integration
D)   Forward integrationE) All of the above
F) C) and D)

Question 2

What is the role of a foreign key?

Accepted Answer

A)   It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
B)   It is a unique way to identify each record.
C)   It is a field that uniquely identifies a given record in a table.
D)   All of these.E) A) and C)
F) A) and D)

Question 3

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 4

What is a field that uniquely identifies a given record in a table?

Accepted Answer

A)   Foreign key
B)   Primary key
C)   Data mining key
D)   DBMS keyE) A) and B)
F) A) and C)

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Unique information asks if each transaction and event is represented only once in the information.

Accepted Answer

A) True 
 B)False

Question 7

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 constraintE) C) and D)
F) A) and B)

Question 8

Which of the following is a business-critical integrity constraint?

Accepted Answer

A)   System will not allow an entry of an order for a nonexistent customer
B)   System will not allow returns of fresh produce after 15 days past delivery
C)   System will not allow shipping a product to a customer who does not have a valid address
D)   Systems will not allow shipping of a nonexistent product to a customerE) A) and B)
F) None of the above

Question 9

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 KeyE) A) and D)
F) A) and C)

Question 10

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Accepted Answer

A) True 
 B)False

Question 11

Consistent information asks if the aggregate or summary information is in agreement with detailed information.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

What takes information entered into a given system and sends it automatically to all downstream systems and processes?

Accepted Answer

A)   Forward integration
B)   Forward data interchange
C)   Backward integration
D)   Backward data interchangeE) A) and C)
F) B) and C)

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What is dynamic information?

Accepted Answer

A)   The person responsible for creating the original website content
B)   The person responsible for updating and maintaining website content
C)   Includes fixed data incapable of change in the event of a user action
D)   Includes data that change based on user actionE) A) and C)
F) C) and D)

Question 16

What is data latency?

Accepted Answer

A)   The time it takes for data to be stored or retrieved
B)   The management and oversight of an organization's data assets
C)   The person responsible for ensuring policies and procedures are implemented across the organization
D)   When a company examines its data to determine if it can meet business expectations, while identifying possible data gapsE) A) and B)
F) A) and D)

Question 17

Eintegration is the use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.

Accepted Answer

A) True 
 B)False

Question 18

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 19

Data latency is the time it takes for data to be stored or retrieved.

Accepted Answer

A) True 
 B)False

Question 20

What is a backward integration?

Accepted Answer

A)   The integration of data from multiple sources, which provides a unified view of all data
B)   Taking information entered into a given system and sending it automatically to all downstream systems and processes
C)   Taking information entered into a given system and sending it automatically to all upstream systems and processes
D)   The integration of a company's existing management information systemsE) A) and B)
F) A) and C)

Exam 6: Valuing and Storing Organizational Informationdatabases

A foreign key provides details about data.

Correct AnswerverifiedShow Answer

Unique information asks if each transaction and event is represented only once in the information.

Correct AnswerverifiedShow Answer

What is data latency?

Correct AnswerverifiedShow Answer

Consistent information asks if the aggregate or summary information is in agreement with detailed information.

Correct AnswerverifiedShow Answer

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Correct AnswerverifiedShow Answer

What takes information entered into a given system and sends it automatically to all downstream systems and processes?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Data latency is the time it takes for data to be stored or retrieved.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the role of a foreign key?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources?

Correct AnswerverifiedShow Answer

What is a backward integration?

Correct AnswerverifiedShow Answer

What is dynamic information?

Correct AnswerverifiedShow Answer

Eintegration is the use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a business-critical integrity constraint?

Correct AnswerverifiedShow Answer

What is a field that uniquely identifies a given record in a table?

Correct AnswerverifiedShow Answer

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified