Question 1

The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.

Accepted Answer

The answer of The ___________ database model is a type...

Question 2

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

Accepted Answer

A)  Entity 
B)  Logical view 
C)  Attribute 
D)  Physical view 
A)  Entity 
B)  Logical view 
C)  Attribute 
D)  Physical view

Question 3

Compare relational integrity constraints and business-critical integrity constraints.

Accepted Answer

Relational integrity constraints are rul

Question 4

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 5

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 6

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 7

______________ integrity constraints enforce business rules vital to an organization's success.

Accepted Answer

The answer of ______________ integrity constraints enforce business rules vital...

Question 8

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 9

What type of website is best to build for a continually changing information,including press releases,new product information,and updated pricing?

Accepted Answer

A)  Data-driven website 
B)  Static website 
C)  Relational website 
D)  All of these 
A)  Data-driven website 
B)  Static website 
C)  Relational website 
D)  All of these

Question 10

______________ is the duplication of information,or storing the same information in multiple places.

Accepted Answer

The answer of ______________ is the duplication of information,or storing...

Question 11

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 12

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 13

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 14

What is the primary problem with redundant information?

Accepted Answer

A)  It is difficult to determine which values are the most current. 
B)  It is often inconsistent. 
C)  It is difficult to determine which values are the most accurate. 
D)  All of these. 
A)  It is difficult to determine which values are the most current. 
B)  It is often inconsistent. 
C)  It is difficult to determine which values are the most accurate. 
D)  All of these.

Question 15

What type of website is best to build for a general informational website with static information?

Accepted Answer

A)  Data-driven website 
B)  Static website 
C)  Relational website 
D)  All of these 
A)  Data-driven website 
B)  Static website 
C)  Relational website 
D)  All of these

Question 16

All of the following are business-critical integrity constraints except:

Accepted Answer

A)  The system will not allow an entry for an order for a nonexistent customer. 
B)  The system will not allow returns of fresh produce after 15 days past delivery. 
C)  The system will not allow shipping a product to a customer who does not have a valid address. 
D)  The system will not allow shipping a nonexistent product to a customer. 
A)  The system will not allow an entry for an order for a nonexistent customer. 
B)  The system will not allow returns of fresh produce after 15 days past delivery. 
C)  The system will not allow shipping a product to a customer who does not have a valid address. 
D)  The system will not allow shipping a nonexistent product to a customer.

Question 17

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

Question 18

What refers to how well a system can adapt to increased demands?

Accepted Answer

A)  Scalability 
B)  Performance 
C)  Redundancy 
D)  Information integrity 
A)  Scalability 
B)  Performance 
C)  Redundancy 
D)  Information integrity

Question 19

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 20

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

Accepted Answer

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

Exam 7: Storing Organizational Information-Databases

The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.

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

Compare relational integrity constraints and business-critical integrity constraints.

What is the physical view of information?

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

What is a forward integration?

______________ integrity constraints enforce business rules vital to an organization's success.

What is information redundancy?

What type of website is best to build for a continually changing information,including press releases,new product information,and updated pricing?

______________ is the duplication of information,or storing the same information in multiple places.

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.

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

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

What is the primary problem with redundant information?

What type of website is best to build for a general informational website with static information?

All of the following are business-critical integrity constraints except:

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

What refers to how well a system can adapt to increased demands?

What is a backward integration?

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

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

Ebusiness

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

Developing a 21st-Century Organization

Business Basics

Business Process

Hardware and Software Basics

Mis Infrastructures

Networks and Telecommunications

Information Security

Ethics

Operations Management

Sustainable Mis Infrastructures

Business Intelligence

Global Information Systems

Global Trends

Filters