Question 1

A _______________ key is a field that uniquely identifies a given entity in a table.

Accepted Answer

The answer of A _______________ key is a field that...

Question 2

What is a backward integration?

Accepted Answer

A)  Takes information entered into a given system and sends it to the application-generation component. 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes. 
C)  Takes information entered into a given system and sends it automatically to all upstream systems and processes. 
D)  Takes information entered into a given system and sends it to the DBMS. 
A)  Takes information entered into a given system and sends it to the application-generation component. 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes. 
C)  Takes information entered into a given system and sends it automatically to all upstream systems and processes. 
D)  Takes information entered into a given system and sends it to the DBMS.

Question 3

Ideally,an organization wants to build only forward integrations.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of The ________ view of information focuses on...

Question 5

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 6

Describe the role and purpose of a database management system.

Accepted Answer

A database management system (DBMS)is so

Question 7

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Which of the following is not an advantage of building a data-driven website?

Accepted Answer

A)  Minimizes human error. 
B)  Cuts production and update costs. 
C)  Improves or maximizes stability. 
D)  Minimizes or reduces efficiency. 
A)  Minimizes human error. 
B)  Cuts production and update costs. 
C)  Improves or maximizes stability. 
D)  Minimizes or reduces efficiency.

Question 10

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

Accepted Answer

A)  Can be relational or network. 
B)  Information is accessed by logical structure. 
C)  Information is accessed by physical structure. 
D)  Users can access different views of information. 
A)  Can be relational or network. 
B)  Information is accessed by logical structure. 
C)  Information is accessed by physical structure. 
D)  Users can access different views of information.

Question 11

What is a forward integration?

Accepted Answer

A)  Takes information entered into a given system and sends it to the application-generation component. 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes. 
C)  Takes information entered into a given system and sends it automatically to all upstream systems and processes. 
D)  Takes information entered into a given system and sends it to the DBMS. 
A)  Takes information entered into a given system and sends it to the application-generation component. 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes. 
C)  Takes information entered into a given system and sends it automatically to all upstream systems and processes. 
D)  Takes information entered into a given system and sends it to the DBMS.

Question 12

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

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 14

What are the rules that enforce basic and fundamental information-based constraints?

Accepted Answer

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

Question 15

Which of the following is true in regard to eliminating redundant information?

Accepted Answer

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

Question 16

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  A database can support only one logical view. 
B)  A database can support many physical views. 
C)  A database can support many logical views. 
D)  A database can support up to three logical views. 
A)  A database can support only one logical view. 
B)  A database can support many physical views. 
C)  A database can support many logical views. 
D)  A database can support up to three logical views.

Question 18

A(n)___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

Accepted Answer

The answer of A(n)___________ key in the relational database model...

Question 19

What is information redundancy?

Accepted Answer

A)  Duplication of information. 
B)  Storing the same information in multiple places. 
C)  Storing duplicate information in multiple places. 
D)  All of these. 
A)  Duplication of information. 
B)  Storing the same information in multiple places. 
C)  Storing duplicate information in multiple places. 
D)  All of these.

Question 20

Which of the following types of information can be found in a database?

Accepted Answer

A)  Inventory 
B)  Transactions 
C)  Employees 
D)  All of these 
A)  Inventory 
B)  Transactions 
C)  Employees 
D)  All of these

A _______________ key is a field that uniquely identifies a given entity in a table.

What is a backward integration?

Ideally,an organization wants to build only forward integrations.

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

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

Describe the role and purpose of a database management system.

One of the advantages found in a relational database is increased information redundancy.

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

Which of the following is not an advantage of building a data-driven website?

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

What is a forward integration?

What is a foreign key?

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

What are the rules that enforce basic and fundamental information-based constraints?

Which of the following is true in regard to eliminating redundant information?

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.

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

A(n)___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

What is information redundancy?

Which of the following types of information can be found in a database?

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 Organizational Information

Accessing Organizational Information Data Warehouse

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End-To-End Enterprise Resource Planning

Creating Innovative Organizations

E-Business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Building Software to Support an Agile Organization

Managing Organizational Projects

Outsourcing in the 21st Century

Developing a 21st-Century Organization

Filters

Exam 7: Storing Organizational Information Databases

A _______________ key is a field that uniquely identifies a given entity in a table.

What is a backward integration?

Ideally,an organization wants to build only forward integrations.

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

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

Describe the role and purpose of a database management system.

One of the advantages found in a relational database is increased information redundancy.

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

Which of the following is not an advantage of building a data-driven website?

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

What is a forward integration?

What is a foreign key?

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

What are the rules that enforce basic and fundamental information-based constraints?

Which of the following is true in regard to eliminating redundant information?

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.

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

A(n)___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

What is information redundancy?

Which of the following types of information can be found in a database?

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 Organizational Information

Accessing Organizational Information Data Warehouse

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End-To-End Enterprise Resource Planning

Creating Innovative Organizations

E-Business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Building Software to Support an Agile Organization

Managing Organizational Projects

Outsourcing in the 21st Century

Developing a 21st-Century Organization

Filters