IS Exam 3 Ch 3

What is normalization?

(b) A method for analyzing and reducing a relational database to its most streamlined form.

What is an entity?

(b) A person, place, thing, or event about which information is maintained.

What is a data warehouse?

(c) A repository of data that are organized by business dimension or subject to support decision making.

What is a primary key?

(c) A specific, unique representation of a person, place, or thing.

List three of the basic characteristics of data warehouses.

(d) Integration of multiple data, inclusion of nonvolatile data, and multidimensional data.

It is very difficult to manage data for which of the following reasons?

b. Data are scattered throughout organizations.

What is a database management system?

(e) A set of programs that provide users with tools to add, delete, access, modify, and analyze data stored in one location.

Which of the following is not a characteristic of data warehouse and data marts?

d. Instantly updated

Which of the following is not a source of corporate data?

d. Intrinsic motivation.

_____ provide(s) companies with a single version of the truth for their data.

d. Master data management

It is important that data be:

d. Relevant.

Which of the following is not a challenge in managing data?

d. The amount of data is getting smaller each year.

Place the following members of the data hierarchy in the correct order:

d. bit - byte - field - record - file - database

A standardized language used to manipulate data is _____.

d. structured query language

In a database, the primary key field is used to _____.

d. uniquely identify a record

Which of the following is not a reason why managing data is difficult over time?

e. All of these are reasons why managing data is difficult over time.

A(n) _____ represents a single character, such as a letter, number, or symbol.

a. Byte

The first step in creating a database should be:

a. Creating a data model.

Databases minimize which problem?

a. Data isolation

_____ occurs when applications cannot access data associated with other applications.

a. Data isolation

Data dictionaries perform all of the following functions except:

a. Providing information on each record

The cumulative store of subjective or experiential learning is defined as:

a. Tacit knowledge.

The data in a data warehouse have which of the following characteristics?

a. They are organized by subject.

_____ describe the activities of the business, whereas _____ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities.

a. Transaction data, master data

In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n):

a. attribute

Compared to data warehouses, data marts have which one of the following characteristics?

a. cost less

As an individual student in your university's student database, you are a(n) _____ of the STUDENT class.

a. instance

Explicit knowledge has which of the following characteristics?

a. objective

Transaction data are:

b. A record of the activities of the business.

Why is it important for a business to manage data efficiently?

b. Because organized data become information and knowledge that are used in decision making.

In the data hierarchy, the smallest element is the _____.

b. Bit.

Not including alphabetic characters in a Social Security Number field is an example of _____ .

b. Data integrity.

A(n) _____ is a logical grouping of characters into a word, a small group of words, or a complete number.

b. Field

_____ is a method for analyzing and reducing a relational database to its most streamlined form.

b. Normalization

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

b. Secondary keys

Organizations are turning to data governance for which of the following reasons?

b. They are responding to federal regulations.

The most important benefit of knowledge management systems is:

b. they make best practices available to employees.

_____ occurs when various copies of the data agree.

c. Data consistency

Which of the following has (have) the broadest impact on an organization?

c. Decisions about data

Objective, rational, and technical knowledge is defined as:

c. Explicit knowledge.

The most popular language used to request information from a database is:

c. SQL.

When customers access a Web site and make purchases, they generate _____.

c. clickstream data

Which of the following is an example of explicit knowledge?

c. procedural guides

A(n) _____ is a logical grouping of related fields.

c. record

What is a database?

d. A logical grouping of related files.

Which of the following is an example of unstructured data?

d. A video clip on the Internet.

Place the following members of the data hierarchy in their correct order:

d. Bit - byte - field - record - file - database

_____ is a formal approach to managing data consistently across an entire organization.

d. Data governance

_____ occurs when the same data are stored in many places.

d. Data redundancy

A(n) _____ is a logical grouping of related records.

d. File

ER diagrams consist of all of the following except:

d. Files.