Chapter 6 IS II

DBMS for midrange computers include all of the following EXCEPT A) DB2. B) Oracle. C) Microsoft SQL Server. D) Microsoft Access.

D

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? A) data normalization B) data accuracy C) data redundancy D) data inconsistency

D

Which of the following is not one of the techniques used in Web mining? A) content mining B) structure mining C) server mining D) user mining

D

Which of the following technologies would you use to analyze the social media data collected by a major online retailer? A) OLAP B) data warehouse C) data mart D) Hadoop

D

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 A) identifying associations. B) identifying clusters. C) identifying sequences. D) classification.

D

All of the following are technologies used to analyze and manage big data except A) cloud computing. B) noSQL. C) in-memory computing. D) analytic platforms.

A

Big data does not refer to A) datasets with fewer than a billion records. B) datasets with unstructured data. C) machine-generated data (i.e. from sensors). D) data created by social media (i.e. tweets, Facebook Likes).

A

Oracle Database Lite is a(n) A) DBMS for small handheld computing devices. B) Internet DBMS. C) mainframe relational DBMS. D) DBMS for midrange computers.

A

Which of the following non-digital data storage items is most similar to a database? A) library card catalog B) cash register receipt C) doctor's office invoice D) list of sales totals on a spreadsheet

A

The special organizational function whose responsibilities include physical database design and maintenance, is called A) data administration. B) database administration. C) information policy administration. D) data auditing.

B

The specialized language programmers use to add and change data in the database is called A) a data access language. B) a data manipulation language. C) structured query language. D) a data definition language.

B

In a relational database, the three basic operations used to develop useful sets of data are A) select, project, and where. B) select, join, and where. C) select, project, and join. D) select, from, and join.

C

In terms of data relationships, associations refers to A) events linked over time. B) patterns that describe a group to which an item belongs. C) occurrences linked to a single event. D) undiscovered groupings.

C

Which of the following best describes the importance of creating an accurate data model for your business's database?

Critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve

A DBMS reduces data redundancy and inconsistency by A) enforcing referential integrity. B) uncoupling program and data. C) utilizing a data dictionary. D) minimizing isolated files with repeated data.

D

Data mining is a tool for allowing users to:

Find hidden relationships in data.

Because HTML was designed as a cross-platform language, it is the preferred method of communicating with back-end databases.

False

The use of different terms for identifying data in a firm's various information systems is an example of redundant data.

False

OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to infer future behavior.

False (it is data mining)

What is the first step you should take in managing data for a firm?

Identify the data needed to run the business

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

OLAP (online analytical processing)

The type of logical database model that treats data as if they were stored in two dimensional tables is the:

Relational DBMS.

The most prominent data manipulation language today is:

SQL (structured query language)

Which of the following best illustrates the relationship between entities and attributes?

The entity CUSTOMER with the attribute ADDRESS

A DBMS is special software for creating, storing, organizing, and accessing data from a database

True

A data warehouse may include information from legacy systems.

True

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

True

A foreign key is a field that links to a separate table.

True

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

True

In a relational database, a record is also called a tuple

True

Web mining is the discovery of useful patterns on the Web.

True

Which of the following would you use to find patterns in user interaction data recorded by Web servers?

Web usage mining

A characteristic or quality describing an entity is called a(n):

attribute

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.

data quality audit

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

data redundancy

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

data scrubbing

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function.

database administration

A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.

database server

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

entity-relationship diagram.

In clustering, a data mining tool will

find new groupings within data

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:

in two short marks.

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

it typically focuses on a single subject area or line of business.

A field identified in a record as holding the unique identifier for that record is called the:

key field

MySQL is a

popular open-source DBMS.

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

In a table for customers, the information about a single customer would reside in a single:

row

What is the purpose of a DBMS's data definition function?

structuring the database

Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos.

text-mining

Both Oracle and Microsoft Access use SQL to retrieve information from the database.

true

End users use a data manipulation language to manipulate data in the database.

true

A data ________ stores current and historical data of potential interest to decision makers throughout the company.

warehouse

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

with a crow's foot preceded by a short mark.