Advertisement Upgrade to remove ads

select, project, and join.

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

True

OLAP is a key tool of BI.

Identifying sequences

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

airport code

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?

CGI

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

classification

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

row

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

True

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

key field

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

False

The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.

data manipulation language

The specialized language programmers use to add and change data in the database is called

true

Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

True

In a Web-based database, middleware is used to transfer information from the organization's internal database back to the Web server for delivery in the form of a Web page to the user.

Microsoft access

DBMS for midrange computers include all of the following EXCEPT

false

Predictive analysis is synonymous with data mining.

true

OODBMS are slower than relational DBMS.

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

The select operation

true

Each characteristic or quality describing a particular entity is called an attribute.

True

In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

data dictionary

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

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

The join operation

OLAP

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

user mining

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

tuple

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

true

Every record in a file should contain at least one key field.

true

A DBMS separates the logical and physical views of data.

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

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because

display data in an easier-to-read format.

DBMSs typically include report-generating tools in order to

the entity CUSTOMER with the attribute PURCHASE

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

False

A data warehouse is typically comprised of several smaller data marts.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set