Quiz 6 MIS

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

false

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

false

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

Data inconsistency

Which of the following technologies would you use to analyze the social media data collected by a major online retailer? Data warehouse DBMS OLAP Data mart Hadoop

Hadoop

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

a crow's foot topped by a short mark

true or false? Data scrubbing is a more intensive corrective process than data cleansing.

false

A ________ is an example of pre-digital data storage that is comparable to a database. library card catalog cash register receipt list of sales totals on a spreadsheet schedule of due dates on a project outline doctor's office invoice

library card catalog

True or False? You can manipulate data on a web server by using a CGI script.

true

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

true

true or false? Every record in a file should contain at least one key field

true

true or false? DBMS have a data definition capability to specify the structure of the content of the database.

true

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

true

true or false? In-memory computing relies primarily on a computer (RAM) for data storage.

true

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

true

true or false? Program-data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data

true

In a relational database, a record is referred to in technical terms as a(n): entity. tuple. table. key. field.

tuple

You are creating a database to store temperature and wind data from various airports. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table? State Day City Airport code Address

Airport code

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? Sequences Clustering Forecasting Classifications Associations

Classifications

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? Classify data Create a forecast Identify clusters Identify sequences Identify associations

Classify data

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? Data definition diagram Entity-relationship diagram Data dictionary Relationship dictionary Data table

Data dictionary

_______ creates confusion that hampers the creation of information systems that integrate data from different sources. Online processing Data independence Batch processing Data redundancy Data quality

Data redundancy

In a large organization, which of the following functions would be responsible for physical database design and maintenance? Database management Information policy administration Data administration Database administration Data auditing

Database administration

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems? Lack of flexibility Data redundancy Poor security Program-data dependence Lack of data sharing

Lack of flexibility

Which of the following tools enables users to view the same data in different ways using multiple dimensions? Hadoop SQL OLAP Predictive analysis Data mining

OLAP

Which of the following is the most prominent data manipulation language today? NoSQL Crystal Reports Access SQL DB2

SQL

A household appliances manufacturer has hired you to help analyze its social media datasets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data? Text mining tools Sentiment analysis software Data mining software Web mining technologies Data governance software

Sentiment analysis software

In data mining, which of the following involves events linked over time? Associations Clustering Forecasting Classifications Sequences

Sequences

Which of the following is not one of the techniques used in web mining? Server mining Content mining Data mining Structure mining Usage mining

Server mining

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

Text mining

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

The entity CUSTOMER with the attribute PURCHASE

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

Web usage mining

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

attribute

The join operation: combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of rows in a table. organizes elements into segments. identifies the table from which the columns will be selected. creates a subset consisting of columns in a table.

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

The select operation: creates a subset consisting of columns in a table. creates a subset consisting of all records in the file that meet stated criteria. identifies the table from which the columns will be selected. combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of rows in a table.

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

The project operation: organizes elements into segments. combines relational tables to provide the user with more information than is otherwise available. creates a subset consisting of rows in a table. identifies the table from which the columns will be selected. creates a subset consisting of columns in a table.

creates a subset consisting of columns in a table.

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

data scrubbing.

The term big data refers to all of the following except: machine-generated data (i.e. from sensors). data from Web traffic. data created by social media (i.e. tweets, Facebook Likes). datasets with fewer than a billion records. datasets with unstructured data.

datasets with fewer than a billion records.

DBMSs typically include report generating tools in order to display data in graphs. retrieve and display data. analyze the database's performance. perform predictive analysis. display data in an easier-to-read format.

display data in an easier-to-read format.

Data cleansing not only corrects errors but also: establishes logical relationships between data. removes duplicate data. enforces consistency among different sets of data. structures data. normalizes data.

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. intersection relationship diagram. data definition diagram. data dictionary. data analysis table.

entity-relationship diagram.

true or false? A record is a characteristic or quality used to describe a particular entity.

false

true or false? Associations are occurrences linked to multiple events.

false

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

false

true or false? OLAP is unable to manage and handle queries with very large sets of data.

false

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

false

Data mining allows users to: summarize massive amounts of data into much smaller, traditional reports. quickly compare transaction data gathered over many years. obtain online answers to ad-hoc questions in a rapid amount of time. access the vast amounts of data in a data warehouse. find hidden relationships in data.

find hidden relationships in data.

In data mining, which of the following involves using a series of existing values to determine what other future values will be? Clustering Forecasting Classifications Associations Sequences

forecasting

A data warehouse is composed of: historical data from legacy systems. internal and external data sources. current data. historic and current internal data. historic external data.

historic and current internal data.

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

in two short marks

All of the following are issues with the traditional file environment except: inability to develop specialized applications for functional areas. data inconsistency. data sharing. poor security. lack of flexibility in creating ad-hoc reports.

inability to develop specialized applications for functional areas.

A field identified in a record as holding the unique identifier for that record is called the: primary field. key field. unique ID. primary key. key attribute.

key field

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

normalization.

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

occurrences linked to a single event.

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

physical database available for different logical views.

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

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: key field. primary entity. unique ID. primary field. primary key.

primary key.

Data ________ occurs when the same data is duplicated in multiple files of a database. partitions discrepancy independence repetition redundancy

redundancy

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

row.

Microsoft Access's data dictionary displays all of the following information about a field except the: the organization within the organization that is responsible for maintaining the data. format of the field. description of the field. type of the field. size of the field.

the organization within the organization that is responsible for maintaining the data.

true or false? The logical and physical views of data are separated in a DBMS.

true

true or false? The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

true

true or false? You can use OLAP to perform multidimensional data analysis.

true

true or false? You can use text mining tools to analyze unstructured data, such as memos and legal cases.

true