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