MIS - Chapter 6

________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships. OLAP Text mining Web mining Web content mining

Text mining

The specialized language programmers use to add and change data in the database is called a data access language. a data manipulation language. Structured Query Language. a data definition language.

a data manipulation language

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because a data mart typically focuses on a single subject area or line of business. all the information is historical. a data mart uses a Web interface. all of the information belongs to a single company.

a data mart typically focuses on a single subject area or line of business.

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table? address city airport code state

airport code

A characteristic or quality describing an entity is called a(n) field. tuple. key field. attribute.

attribute.

You work for an national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of identifying associations. identifying clusters. identifying sequences. classification.

classification.

The select operation combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of columns in a table. identifies the table from which the columns will be selected. creates a subset consisting of all records in the file that meet stated criteria.

creates a subset consisting of all records in the file that meet stated criteria.

The project operation combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of columns in a table. organizes elements into segments. identifies the table from which the columns will be selected.

creates a subset consisting of columns in a table.

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the data dictionary. data definition diagram. entity-relationship diagram. relationship dictionary.

data dictionary.

The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called data administration. database administration. information policy administration. data auditing.

database administration.

You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of identifying associations. identifying clusters. identifying sequences. classification.

identifying sequences.

A field identified in a record as holding the unique identifier for that record is called the Incorrect Response primary key. Correct Answer key field. primary field. unique ID.

key field.

Which of the following non-digital data storage items is most similar to a database? library card catalog cash register receipt doctor's office invoice list of sales totals on a spreadsheet

library card catalog

Which of the following is not one of the main problems with a traditional file environment? data inconsistency program-data independence lack of flexibility in creating ad-hoc reports poor security

program-data independence

OLAP is a tool for enabling users to obtain online answers to ad-hoc questions in a rapid amount of time. users to view both logical and physical views of data. programmers to quickly diagram data relationships. programmers to normalize data.

users to obtain online answers to ad-hoc questions in a rapid amount of time.