MIS Chapter 6

Which of the following enables a DBMS to reduce data redundancy and inconsistency Use of a data dictionary Ability to minimize isolated files with repeated data Ability to couple program and data Ability to create two-dimensional tables Ability to enforce referential integrity

Ability to minimize isolated files with repeated data

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

Classify data

Which of the following occurs when the same attribute in related data files has different values? Data discrepancy Data inconsistency Data redundancy Data dependence Data duplication

Data inconsistency

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

Data redundancy

Which of the following statements about Hadoop is not true? Hadoop is proprietary software sold by the Apache Software Foundation. Hadoop breaks a big data problem down into subproblems. Hadoop consists of several key services. Companies use Hadoop as for a staging area for unstructured and semistructured data before they are loaded into a data warehouse. Hadoop runs on a cluster of inexpensive servers.

Hadoop is proprietary software sold by the Apache Software Foundation.

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? Program-data dependence Poor security Lack of data sharing Data redundancy Lack of flexibility

Lack of flexibility

Which of the following is a DBMS for desktop computers? Microsoft Exchange Microsoft SQL Server Oracle Database DB2 Microsoft Access

Microsoft Access

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

Sequences

A data governance policy specifies all of the following except: where information can be distributed. which users and organizational units can share information. how data resources should be secured. who is responsible for updating and maintaining information. which type of business intelligence tool should be used.

Which type of business intelligence tool should be used.

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

creates a subset consisting of rows in a table that meet stated criteria.

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

data cleansing

DBMSs typically include report generating tools in order to: display data in a more structured and polished format than would be possible just by querying. perform predictive analysis. retrieve and display data. display data in graphs. analyze the database's performance.

display data in a more structured and polished format than would be possible just by querying.

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

entity-relationship diagram.

A common field that links two different tables and serves as a primary key to one of these tables is called the: primary field. primary entity. secondary key foreign key. unique ID.

foreign key

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

normalization.

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

occurrences linked to a single event.

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

physical database available for different logical views

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

row

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

select, project, and join

OLAP enables: users to view both logical and physical views of data. 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 reports using multidimensional views of data. programmers to normalize data.

users to quickly generate reports using multidimensional views of data.