MIS Week 4 Chp 6

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?

Data inconsistency

Which of the following occurs when the same attribute in related data files has different values?

Data inconsistency

What creates confusion that hampers the creation of information systems that integrate data from different...

Data redundancy

Which of the following is a grouping of characters into a word, a group of words, or a complete number?

Field

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Hadoop

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

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

Information policy

In terms of data relationships, associations refer to

Occurrences linked to a single event

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

Row

The most prominent data manipulation language today is

SQL

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

Surveying data definition and query files

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

TRUE

An attribute is a characteristic or quality used to describe a particular entity. T/F

True

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

normalization.

A(n) ________ is a characteristic or quality that describes a database entity.a

ttribute

OLAP is a tool for enabling

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

The special organizational function whose responsibilities include database design and maintenance, is called

Database administration

Data ________ occurs when the same data is duplicated in multiple files of a database.

redundancy

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

rimary key.

The traditional file environment does not typically have a problem withp

rogram-data independence

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

select, project, and join

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?

Airport code

The data dictionary serves as an important data management tool by

Creating an inventory of the data elements contained in the database

Microsoft SQL Server is a(n):

DBMS for midrange computers.

A physical view shows data as it is actually organized and structured on the data storage media.

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

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance. T/F

True

________ creates confusion that hampers the creation of information systems that integrate data from different sourcesD

ata redundancy

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

All of the following are technologies used to analyze and manage big data except:

cloud computing.

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 enables a DBMS to reduce data redundancy and inconsistency?

Ability to minimize isolated files with repeated data

You can manipulate data on a web server by using a CGI script.

TRUE

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

Tuple

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

a crow's foot topped by a short mark.

Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

CGI

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

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

True

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration. T/F

True

To perform multidimensional data analysis, you would use OLAP. T/F

True

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

True

The project operation:

creates a subset consisting of columns in a table.

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

data manipulation language.

A(n) ________ organizes data in two-dimensional tables.r

elational DBMS

Data cleansing not only corrects errors but also:

enforces consistency among different sets of data

Databases record information about general categories of information referred to as ________.

entities

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

A DBMS makes thep

hysical database available for different logical views.

a(n) ________ is an example of non-digital data storage that is comparable to a databasel

ibrary card catalog

Which of the following is not a DBMS for midrange computers?M

icrosoft Access

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

key field.

In data mining, the technique of ________ uses a series of existing values to predict what other values will be.f

orecasting

The logical view of a database:

presents data as they would be perceived by end users.

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

TRUE

DBMS have a data definition capability to specify the structure of the content of the database.

TRUE

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

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

Legacy systems are used to populate and update data warehouses.

TRUE

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

TRUE

The logical and physical views of data are separated in a DBMS.

TRUE

You can use OLAP to perform multidimensional data analysis.

TRUE

Big data does not refer to

Datasets with fewer then a billion records

Data scrubbing is a more intensive corrective process than data cleansing.

FALSE

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

FALSE

In a client/server environment, a DBMS is located on a dedicated computer called a web server.

FALSE

Multiple data marts are combined and streamlined to create a data warehouse.

FALSE

OLAP is unable to manage and handle queries with very large sets of data.

FALSE

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

FALSE

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases. T/F

False

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language. T/F

False

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards. T/F

False

The DBMS programming language that end users and programmers use to manipulate data in the database is called CGI. T/F

False

The select operation:

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

All of the following are issues with the traditional file environment except:

inability to develop specialized applications for functional areas.

The relationship between entities and attributes is best illustrated by

the entity CUSTOMER with the attribute PURCHASE.

DBMSs typically include report-generating tools in order to

Display data in an easier-to-read format