CIS Test 6

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

??

Microsoft SQL Server is a(n)

DBMS for midrange computers.

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

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

False

Data scrubbing is a more intensive corrective process than data cleansing.

False

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

False

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

False

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

False

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

False

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

False

OLAP is unable to manage and handle queries with very large sets of data.

False

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

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 is not a DBMS for midrange computers?

Microsoft access

A(n) ________ is a characteristic or quality that describes a database entity.

Not attribute

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

OLAP

A(n) ________ organizes data in two-dimensional tables.

Relational Table

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

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

True

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

Every record in a file should contain at least one key field.

True

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

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 coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

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

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

True

To analyze unstructured data, such as memos and legal cases, you would use text mining tools.

True

To perform multidimensional data analysis, you would use OLAP.

True

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

True

You can manipulate data on a Web server by using a CGI script.

True

OLAP is a tool for enabling

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

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

a data manipulation language.

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

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?

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 state criteria

The project operation

creates a subset consisting of columns in a table.

The a dictionary serves as an important data management tool by

creating an inventory of data contained in the database.

The data dictionary serves as an important data management tool by

creating an inventory of the data elements contained in the database.

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

crows feet preceeded by a short mark-

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 inconsitency

________ creates confusion that hampers the creation of information 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

Big data does not refer to

data with less than a billion records

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

database administration

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

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

entity-relationship diagram.

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

forecasting. classification.-- no identifying sequences.-- wrong identifying associations.--- no identifying clusters. no

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

hadoop

When the same attribute in related data files has different values, this is called data

inconsistency

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

information policy

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 catalog

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

minimizing isolated files with repeated data

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

normalization

Which of the following is not one of the techniques used in Web mining?

not usage, structure, or content

In terms of data relationships, associations refers to

occurrences linked to a single event.

A DBMS makes the

physical database available for different logical views.

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

The traditional file environment does not typically have a problem with

program-data independence

Data ________ occurs when the same data is duplicated in multiple files of a database.

redundancy

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

row

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

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

true