MIS ch 6

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

true

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

true

Legacy systems are used to populate and update data warehouses.

true

To perform multidimensional data analysis, you would use OLAP.

true

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

true

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

Correct Data redundancy

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

Correct minimizes isolated files with repeated data

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

Correct surveying data definition and query files

The relationship between entities and attributes is best illustrated by

Correct the entity CUSTOMER with the attribute PURCHASE.

Microsoft SQL Server is a(n)

DBMS for midrange computers.

The most prominent data manipulation language today is

SQL

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

True

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.

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.

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

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 physical database design and maintenance is called

database administration.

Big data does not refer to

datasets with fewer than a billion records

DBMSs typically include report-generating tools in order to

display data in easier-to-read format

Data cleansing not only corrects errors but also

enforces consistency among different sets of data.

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

entity-relationship diagram.

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

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.

false

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

false

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

false

Data mining is a tool for allowing users to

find hidden relationships in 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.

When the same attribute in related data files has different values, this is called data

inconstancy

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

library card

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 of a database

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

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

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.

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

sentiment analysis software

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

server mining

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

text mining

In place of application server software to allow a Web server to communicate with a back-end database, you can use

CGI

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

OLAP

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.

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

a data manipulation language

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

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

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

false

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

hadoop

A data warehouse is composed of

historic and current internal data.

The organization's 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

The traditional file environment does not typically have a problem with

program-data independence.

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

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

false

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

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

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

false

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

true

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

true

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

true

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

true

To analyze unstructured data, such as memos and legal cases, you would use text mining tools.

true

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

tuple

OLAP is a tool for enabling

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

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

true

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

true

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

true