MIS Chapter 6

Microsoft SQL Server is a(n)

DBMS for midrange computers

Oracle Database Lite is a(n)

DBMS for small handheld computing devices.

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

False

A DBMS separates the logical and physical views of data.

True

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

True

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

attribute.

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

tuple.

The most prominent data manipulation language today is

SQL.

The join operation

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

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

Duplicate data in multiple data files is called data ________.

redundancy

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

relational DBMS.

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

user mining

A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

False

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

False

A grouping of characters into a word, a group of words, or a complete number is called a record.

False

Because HTML was designed as a cross-platform language, it is the preferred method of communicating with back-end databases.

False

OLAP enables users to obtain online answers to ad-hoc questions in a fairly rapid amount of time, except when the data are stored in very large databases.

False

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.

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

Text mining

A data warehouse may be updated by a legacy system

True

Common Gateway Interface is a specification for processing data on a Web server.

True

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

True

Data cleansing is the same process as data scrubbing.

True

Data governance deals with the policies and processes for managing the integrity and security of data in a firm.

True

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

True

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

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.

True

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

True

OLAP is used for multidimensional data analysis.

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

With in-memory computing, a computer's primary memory (RAM) is used for processing.

True

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

a data manipulation language.

You work for a 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

classification.

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.

DBMSs typically include report-generating tools in order to

display data in an easier-to-read format.

A schematic of 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 clothing chain whose primary outlets are in shopping malls, and you 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 sequences.

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.

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

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 best illustrates the relationship between entities and attributes?

the entity CUSTOMER with the attribute PURCHASE

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

two short marks.

OLAP is a tool for enabling

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