Info Tech Chapter 5

1) Which of the following is not a true statement about MDM?

It is a quality-of-data concept that is used to identify a company’s most important data.

2) What is the first step you should take in managing data for a firm?

Identify the data needed to run the business

An example of a pre-digital database is a:

An example of a pre-digital database is a:

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

The entity CUSTOMER with the attribute PRODUCT

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

relational DBMS.

What are the relationships that the relational database is named for?

Relationships between entities

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

attribute.

The most basic business database is comprised of:

five tables: for customers, employees, suppliers, products, and sales.

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

row.

In a relational database, a record is also called a(n):

tuple.

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

primary key.

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

key field.

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

entity-relationship diagram.

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

in two short marks.

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

with a crow’s foot preceded by a short mark.

A table that links two tables that have a many-to-many relationship is often called a(n):

intersection relation.

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

normalization.

A DBMS makes the:

physical database available for different logical views.

The logical view of a database:

shows how data are organized and structured on the storage media.

Which of the following is not a typical feature of DBMS?

Query wizard tool

Oracle Database Lite is a:

DBMS for small handheld computing devices.

Access is a:

DBMS for desktop systems.

MySQL is a:

popular open-source DBMS.

Microsoft SQL Server is a(n):

DBMS for midrange computers.

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

select, project, and join.

The select operation:

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

The join operation:

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

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 data definitions 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 specialized language programmers use to add and change data in the database is called:

data manipulation language.

The most prominent data manipulation language today is:

SQL.

DBMS typically include report-generating tools in order to:

display data in an easier-to-read format.

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

object-oriented DBMS.

Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?

Object-relational DBMS

A data warehouse is composed of:

both historical and current data.

Which of the following statements about data warehouses is not true?

Data warehouse systems provide easy-to-use tools for managers to easily update data.

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

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

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:

business intelligence.

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

OLAP.

OLAP is a tool for enabling:

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

Data mining is a tool for allowing users to:

find hidden relationships in data.

In terms of the data relationships found by data mining, associations refers to:

occurrences linked to a single event.

In terms of the data relationships found by data mining, sequences refers to:

events linked over time

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

CGI.

Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos.

text mining

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

Which of the following would you use to find patterns in user interaction data recorded by Web servers?

Web server mining

Which of the following would you use to find out which Web sites with content related to database design were the most often linked to by other Web sites?

Web usage mining