Chapter 4

Question 1

Which of the following statements about managing data is true?

Answer 1

Reconciling inconsistent data can require a significant amount of time and money.

Question 2

Data that unambiguously describes other data for enterprise use are called:

Answer 2

metadata.

Question 3

A top-down data modeling approach to describe the data structure and other requirements of an organization, independent of any particular reports or screens, is called:

Answer 3

enterprise modeling

Question 4

All of the following are true about using a pre-existing (packaged) data model

Answer 4

the modeling projects require less time and money.
it may be easier to share data with other organizations in the industry.
it is likely to work well with other applications from the same vendor.

Question 5

The data modeling guideline that specifies the functional, business division, and/or corporate coverage is called the:

Answer 5

scope

Question 6

An example of a query language used for posing queries to a database is:

Answer 6

SQL.

Question 7

An example of a data exchange language to pass data between computers for e-business is:

Answer 7

XML.

Question 8

Which of the following is not true about managing data in today’s large organizations?

Answer 8

Data is captured more than once to ensure accuracy.

Question 9

The following statements about information processing with application independence

Answer 9

Data are captured and stored in an operational database.
processing is automatically deleted from the database.
Subsets and aggregated operational data may be periodically transferred to a long-term data warehouse.

Question 10

An application that moves data from one database to another and permits one source of data to serve many localized systems within an organization is called a:

Answer 10

data transfer application

Question 11

An application that distributes data to authorized users and manipulates data to create useful information from established data sources is called a:

Answer 11

data analysis and presentation application

Question 12

The following statements is true about the retention of data?

Answer 12

Some national laws require that certain types of data must be retained for certain periods of time.

Question 13

An unambiguous description of each type of data that applies to all business circumstances and users is called a(n):

Answer 13

definition.

Question 14

A characteristic of a business entity that uniquely distinguishes it from other instances of the entity for the long term is called a(n):

Answer 14

identifier

Question 15

A data dictionary/directory, or DD/D, contains each of the following?

Answer 15

entity definitions.
data element definitions.
data standards.

Question 16

What organizational role or unit is responsible for functions such as physical database design, database interfaces with other technologies, and database recovery methods?

Answer 16

database administrator

Question 17

Determining the physical arrangement of data based on the data currently required by the business and expected to be required in the future is part of which of the following data resource management functions?

Answer 17

organize and make accessible

Question 18

What organizational role or unit is responsible for functions such as maintaining metadata, reducing redundant data, and improving data quality across an organization?

Answer 18

data administration

Question 19

What organizational role or unit is responsible for the quality of the data in a particular subject database or departmental area?

Answer 19

data steward

Question 20

Which of the following is a rationale for data ownership?

Answer 20

A) the need to protect the privacy of personal data
B) the need to protect trade secrets
C) the need to share data with those who “need to know”

Question 21

Which of the following is a justification given for laws that control data flows across national borders?

Answer 21

protect a domestic industry

protect individual privacy

Question 22

Data warehouses provide a method for making historical and current data accessible for queries by many people throughout an organization.

Answer 22

TRUE

Question 23

For legal reasons, all data should be stored indefinitely.

Answer 23

FALSE
Explanation: Some data should be retained, while other data should be disposed of at regular intervals, based on legal requirements and organizational policies.

Question 24

The permissible range or set of values for each data element is defined by integrity rules.

Answer 24

TRUE

Question 25

Databases for managerial control and other decision-making are often subsets, summaries, or aggregations of ________________ databases with external data supplements.

Answer 25

operational