Question 1

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 action 
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 action

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 interchange 
A)  Forward integration 
B)  Forward data interchange 
C)  Backward integration 
D)  Backward data interchange

Question 5

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 key 
A)  Foreign key 
B)  Primary key 
C)  Data mining key 
D)  DBMS key

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 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 customer 
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 customer

Question 9

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 10

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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. 
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.

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 gaps 
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 gaps

Question 18

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 systems 
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 systems

Question 19

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 integration 
A)  Eintegration 
B)  Application integration 
C)  Data integration 
D)  Forward integration

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 6: Valuing and Storing Organizational Informationdatabases

What is dynamic information?

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

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

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

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

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

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

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

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

A foreign key provides details about data.

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

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

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

What is the role of a foreign key?

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.

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

What is data latency?

What is a backward integration?

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?

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

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Accessing Organizational Informationdata Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organizationdecision Making

Extending the Organizationsupply Chain Management

Building a Customer-Centric Organizationcustomer Relationship Management

Integrating the Organization From End to Endenterprise Resource Planning

Creating Innovative Organizations

Ebusiness

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing and Storing Organizational Informationdatabases

Accessing Organizational Informationdata Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organizationdecision Making

Extending the Organizationsupply Chain Management

Building a Customer-Centric Organizationcustomer Relationship Management

Integrating the Organization From End to Endenterprise Resource Planning

Filters