Chapter 6 - Multiple Choice

An alternative to using application server software for interfacing between a Web server and back-end databases is

CGI

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

D) classification

Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name?

D) data inconsistency

Microsoft SQL Server is a(n)

DBMS for midrange computers.

Oracle Database Lite is a(n)

DBMS for small handheld computing devices.

DBMS for midrange computers include all of the following EXCEPT

Microsoft Access.

The tool that enables users to view the same data in different ways using multiple dimensions is

OLAP

The most prominent data manipulation language today is

SQL

_____ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.

Text mining

The specialized language programmers use to add and change data in the database is called A) a data access language B) a data manipulation language C) Structured Query Language D) 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

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

airport code

A characteristic or quality describing an entity is called a(n)

attribute

Tools for analyzing data to help users find patterns, relationships, and insights and make better business decisions are known as

business intelligence

The /join/ operation

combines relational tables to provide the user with more information than is otherwise available.

The /select/ operation

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

The project operation

creates a subset consisting of columns in a table.

The data dictionary serves as an important data management tool by

creating an inventory of the data elements contained in the database

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

The confusion created by _____ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

data redundancy

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

data scrubbing

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

database administration

DBMSs typically include report-generating tools in order to

display data in an easier-to-read format

Data cleansing not only corrects errors but also

enforces consistency among different sets of data

A schematic for the entire database that describes the relationships in a database is called a(n)

entity-relationship diagram

Data mining is a tool for allowing users to

find hidden relationships in data

A data warehouse is composed of

historic and current internal data

You work for a retail chain whose primary outlets are in shopping mall 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 the data mining software that is capable of.

identifying sequences

The organizations rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

information policy

A field identified in a record as holding the unique identifier for that record is called the

key field

Which of the following non-digital data storage items is most similar to a database?

library card catalog

A DBMS reduces data redundancy and inconsistency by

minimizing isolated files with repeated data

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

normalization

The type of database management approach that can handle multimedia is the

object-oriented DBMS

You are creating a video and animation sharing Web sit whose content will be supplied by content, video, and applets stored in a database and you anticipate very high loads on the server. Which of the following DBMSs will most likely serve your needs?

object-relational DBMS

In terms of data relationships, /associations/ refers to

occurrences linked to a single event

A DBMS makes the

physical database available for different logical views

The logical view

presents data as they would be perceived by end users.

A field identified in a table as holding the unique identifier of the table's records is called the

primary key

Which of the following is /not/ one of the main problems with a traditional file environment?

program-data independence

Duplicate data in multiple data files is called data ______ A) redundancy B) repetition C) independence D) partition

redundancy

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

relational DBMS

In a table for customers, the information about a single customer would reside in a single

row

In a relational database, the three basic operations used to develop useful sets of data are

select, project, and join

Which of the following is not a method for performing a data quality audit?

surveying data definition and query files

Which of the following best illustrates the relationship between entities and attributes?

the entity CUSTOMER with the attribute PURCHASE

In a relational database, a record is referred to in technical terms as a(n)

tuple

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends with

two short marks

Which of the following is not one of the techniques used in Web mining?

user mining

OLAP is a tool for enabling

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