MIS 352 Test 2

In place of application server software to allow a Web server to communicate with a back-end database, you can use

CGI

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

False

The DBMS programming language that end users and programmers use to manipulate data in the database is called CGI

False

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Hadoop

You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of

Identifying sequences

Which of the following is not a DBMS for midrange computers?

Microsoft Access

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

OLAP

The most prominent data manipulation language today is

SQL

________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.

Text mining

An attribute is a characteristic or quality used to describe a particular entity

True

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

True

Databases record information about general categories of information referred to as entities.

True

Legacy systems are used to populate and update data warehouses

True

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

True

The logical and physical views of data are separated in a DBMS

True

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration

True

With in-memory computing, a computer's primary memory (RAM) is used for processing

True

The specialized language programmers use to add and change data in the database is called

a data manipulation language

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

airport code

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

classification

All of the following are technologies used to analyze and manage big data except

cloud computing

The join operation

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

The select operation

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

The project operation

creates a subset consisting of columns in a table

The data dictionary serves as an important data management tool by

creating an inventory of the data elements contained in the database

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

data dictionary

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

data scrubbing

The special organizational function whose responsibilities include physical database design and maintenance is called

database administration

Big data does not refer to

datasets with fewer than a billion records

DBMSs typically include report-generating tools in order to

display data in an easier-to-read format

Data cleansing not only corrects errors but also

enforces consistency among different sets of data

In a client/server environment, a DBMS is located on a dedicated computer called a Web server.

false

Multiple data marts are combined and streamlined to create a data warehouse.

false

Data mining is a tool for allowing users to

find hidden relationships in data

A data warehouse is composed of

historic and current internal data

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

key field

A(n) ________ is an example of non-digital data storage that is comparable to a database.

library card catalog

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

minimizes isolated files with repeated data

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

normalization

The logical view of a database

presents data as they would be perceived by end users

The traditional file environment does not typically have a problem with

program-data independence

in a relational database, the three basic operations used to develop useful sets of data are

select, project, and join

Which of the following is not a method for performing a data quality audit?

surveying data definition and query files

The relationship between entities and attributes is best illustrated by

the entity CUSTOMER with the attribute PURCHASE

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

true

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

true

In a relational database, a record is referred to in technical terms as a(n)

tuple

OLAP is a tool for enabling

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