Question 1

Data within the data warehouse is:
A)Volatile - its release is restricted and potentially hazardous to the organization.
B)Volatile - it may be deleted by specific users.
C)Nonvolatile - it does not change rapidly.
D)Nonvolatile - is protected against deletion.

Accepted Answer

Nonvolatile - it does not change rapidly.

Question 2

The additive characteristic means:
A)The linked tables are synergetic within themselves - linked they are more powerful than alone.
B)The values in the preceding fields must total into a following field.
C)That if the preceding rules are met, the rule can be met.
D)That if the preceding rules are not met, the rule must be met.

Accepted Answer

That if the preceding rules are met, the rule can be met.

Question 3

With structured query language SQL):
A)One-to-one relationships can be determined.
B)One-to-many relationships can be determined.
C)Many-to-one relationships can be determined.
D)All of the possibilities, A, B, and C, are correct.

Accepted Answer

All of the possibilities, A, B, and C, are correct.

Question 4

In today's IT environment:
A)Processing speed is compromised for query capability with relational databases.
B)Query capability is compromised for processing speed with relational databases.
C)Neither querying nor processing speed need be compromised with relational databases.
D)Both querying and processing speed are compromised with relational databases.

Accepted Answer

Processing speed is compromised for query capability with relational databases.

Question 5

Data normalization:
A)Requires repeated groups to be deleted from the same row.
B)Requires repeated groups to be deleted from the same column.
C)Allows repeated groups if contained within the column.
D)Allows repeated rows of information within two or more tables.

Accepted Answer

Requires repeated groups to be deleted from the same column.

Question 6

Select the correct statement from those provided.
A)The hierarchal and relational database models are both extremely flexible in their queries.
B)The hierarchal model is better suited to queries than the relational database model.
C)The relational database model is more flexible in its queries than the hierarchal mode.
D)The relational database model has better processing of large volumes of transactions.

Accepted Answer

The relational database model is more flexible in its queries than the hierarchal mode.

Question 7

Which of the following terms is most closely related to data redundancy?
A)Relational database
B)Concurrency
C)Batch processing
D)One-to-many relationships

Accepted Answer

Concurrency

Question 8

High-impact processes HIPs):
A)Determine the structure of the data in the data warehouse.
B)Address the short-term goals of the organization.
C)Must compromise user requirements for organizational needs.
D)Determine the structure of the data in the operational database.

Accepted Answer

Determine the structure of the data in the data warehouse.

Question 9

Select the correct statement from the following.
A)Data redundancy and concurrency are features of well-designed database management systems.
B)Data redundancy, not concurrency, is a feature of a well-designed database management system.
C)Concurrency not, data redundancy, is a feature of a well-designed database management system.
D)Data redundancy and concurrency are not features of well-designed database management systems.

Accepted Answer

Data redundancy and concu rrency are not features of well- designed database management systems.

Question 10

Data reveal relationships between records.These can be thought of as:
A)One-to-one relationships.
B)Many-to-many relationships.
C)One-to-many relationships.
D)All of the above are examples of relationships.

Accepted Answer

All of the above are examples of relationships.

Question 11

A "Where" condition within a structured query of a relational database:
A)Must be limited to a location such as "Warehouse #1."
B)May establish a requirement where the results are equal to a specific value.
C)May establish a requirement where the results are not equal to a specific value.
D)Both B and C are correct.

Accepted Answer

Both B and C are correct.

Question 12

Data redundancy occurs:
A)When shared databases are utilized.
B)When inventory has the same data in its files as sales has in its files.
C)When customer addresses are needed by both shipping and billing.
D)In all properly designed database management systems.

Accepted Answer

When inventory has the same data in its files as sales has in its files.

Question 13

Select the true statement from those provided below.
A)The data warehouse has five to ten years of data while the operational database has current year data.
B)The data warehouse has current year data while the operational database has five to ten years of data.
C)The data warehouse archives both current and long-term, five to ten years of data, within its storage.
D)The data warehouse contains only general ledger type information while the operational database has detail.

Accepted Answer

The data warehouse has five to ten years of data while the operational database has current year data.

Question 14

Which of the following is NOT one of the three rules of data normalization?
A)Eliminate repeating groups
B)Eliminate redundant data
C)Eliminate blank fields
D)Eliminate columns not dependent on the primary keys

Accepted Answer

Eliminate blank fields

Question 15

Select the true statement from those provided below.
A)Managers use much the same data as operational departments to manage the organization.
B)All users, managers, sales, production, utilize the features of a data warehouse equally.
C)Data warehouses are isolated to protect operational information from unauthorized access.
D)Managers require access to historical data this is generally not available to other individuals.

Accepted Answer

Managers require access to historical data this is generally not available to other individuals.

Question 16

Database management systems, DBMS, is are):
A)Software that manages a database and controls access and use of data
B)Printed policies about the use and access to data.
C)Systems which require each user to create his own master data file.
D)Systems that allow unlimited access to the data files by all users.

Accepted Answer

Software that manages a database and controls access and use of data

Question 17

Which of the following statements is true regarding an operational database?
A)An operational database is an integrated collection of enterprise-wide data that includes 5 to 10 years of nonvolatile data.
B)An operational database includes data for the current fiscal year and supports day-to-day operations and record keeping for the transaction processing system.
C)An operational database includes data from the past 5 to 10 years and supports day-to-day operations and record keeping for the transaction processing system.
D)None of the above statements are true.

Accepted Answer

An operational database includes data for the current fiscal year and supports day-to-day operations and record keeping for the transaction processing system.

Question 18

The loss of transaction processing efficiency:
A)Is substantial but a necessary trade-off with relational databases.
B)Is minimized because of the increased computing power available.
C)Is a primary reason why relational databases are not utilized.
D)Both B and C are correct.

Accepted Answer

Is minimized because of the increased computing power available.

Question 19

The data warehouse:
A)Contains five to ten years of historical data in detail for planning and analysis.
B)Contains the current fiscal year in detail for planning, analysis, and reporting.
C)Contains the historical information needed for planning and analysis.
D)Is not utilized for planning and analysis, this information is extracted from the operational database.

Accepted Answer

Contains the historical information needed for planning and analysis.

Question 20

High-impact processes HIPs) are:
A)Critical to the short-term objectives of the organization.
B)Only associated with events such as sales and collections.
C)Identified and established by single-functional teams.
D)Critical to the long-term objectives of the organization.

Accepted Answer

Critical to the long-term objectives of the organization.

Quiz 13: Data and Databases

Data within the data warehouse is:

The additive characteristic means:

With structured query language SQL) :

In today's IT environment:

Data normalization:

Select the correct statement from those provided.

Which of the following terms is most closely related to data redundancy?

High-impact processes HIPs) :

Select the correct statement from the following.

Data reveal relationships between records.These can be thought of as:

A "Where" condition within a structured query of a relational database:

Data redundancy occurs:

Select the true statement from those provided below.

Which of the following is NOT one of the three rules of data normalization?

Select the true statement from those provided below.

Database management systems, DBMS, is are) :

Which of the following statements is true regarding an operational database?

The loss of transaction processing efficiency:

The data warehouse:

High-impact processes HIPs) are: