MIS352 chapter 6

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

True

You can use text mining tools to analyze unstructured data, such as memos and legal cases. True False

true

OLAP enables: users to obtain online answers to ad-hoc questions in a rapid amount of time. programmers to quickly diagram data relationships. users to quickly generate summary reports. users to view both logical and physical views of data. programmers to normalize data.

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

Which of the following would you use to find patterns in user interaction data recorded by a web server? Web structure mining Web usage mining Web server mining Web protocol mining Web content mining

web usage mining

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

CGI

Microsoft SQL Server is a(n): Internet DBMS. DBMS for midrange computers. DBMS for mobile devices. DBMS for both desktops and mobile devices. desktop relational DBMS.

DBMS for midrange computers

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use the data mining software you are using to do which of the following? Identify sequences Identify clusters Create a forecast Classify data Identify associations

Identify sequences

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with: three short marks. two short marks. a crow's foot topped by a short mark. one short mark. a crow's foot.

a crows foot

A characteristic or quality that describes a particular database entity is called a(n): attribute. tuple. field. relationship. key field.

attribute

In data mining, which of the following involves recognizing patterns that describe the group to which an item belongs by examining existing items and inferring a set of rules? Associations Clustering Sequences Forecasting Classifications

classifications

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 duplication Data normalization Data redundancy Data accuracy Data inconsistency

data inconsistency

Which of the following is a specialized language that programmers use to add and change data in the database? Structured query language DBMS Data definition language Data access language Data manipulation language

data manipulation language

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called: data auditing. data optimization. defragmentation. data scrubbing. data normalization.

data scrubbing

A schematic of the entire database that describes the relationships in a database is called a(n): intersection relationship diagram. data definition diagram. entity-relationship diagram. data dictionary. data analysis table.

entity-relationship diagram

A record is a characteristic or quality used to describe a particular entity. True False

false

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

false

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

false

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

false

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm. True False

true

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: optimization. data defining. data scrubbing. normalization. data cleansing.

normalization

In the context of data relationships, the term associations refers to: events linked over time. occurrences linked to a single event. undiscovered groupings. relationships between different customers. patterns that describe a group to which an item belongs.

occurrences linked to a single event

A DBMS makes the: relational database available for different analytic views. relational database available for different logical views. physical database available for different logical views. physical database available for different analytic views. logical database available for different analytic views.

physical database available for different logical views

The logical view of a database: enables users to manipulate the logical structure of the database. displays the organization and structure of data on the physical storage media. allows the creation of supplementary reports. includes a digital dashboard. presents data as they would be perceived by end users.

presents data as they would be perceived by end users

In a table for customers, the information about a single customer resides in a single: column. field. entity. table. row.

row

In a relational database, the three basic operations used to develop useful sets of data are: select, project, and join. where, find, and select. select, project, and where. select, join, and where. where, from, and join.

select, project, and join

________ tools are used to analyze large unstructured data sets, such as e-mail, memos, and survey responses to discover patterns and relationships. Classification Text mining In-memory OLAP Clustering

text mining

Which of the following best illustrates the relationship between entities and attributes? The entity PRODUCT with the attribute PURCHASE The entity PURCHASE with the attribute CUSTOMER The entity PRODUCT with the attribute CUSTOMER The entity CUSTOMER with the attribute PRODUCT The entity CUSTOMER with the attribute PURCHASE

the entity CUSTOMER with the attribute PURCHASE

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

true

In-memory computing relies primarily on a computer (RAM) for data storage. True False

true

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page. True False

true