Chapter 6 CIS Questions

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 inconsistency

________ creates confusion that hampers the creation of information systems that integrate data from different sources

Data redundancy

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

False

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

False

What is the first step you should take in managing data for a firm? A) Cleanse the data before importing it to any database B) Identify the data needed to run the business C) Normalize the data before importing to a database D) Audit your data quality

Identify the data needed to run the business

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

Microsoft Access

Which of the following tools enables users to view the same data in different ways using multiple dimensions?

OLAP

The most prominent data manipulation language today is

SQL.

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

True

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

True

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

True

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

True

You can use OLAP to perform multidimensional data analysis.

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

A characteristic or quality describing an entity is called a(n): A) tuple. B) key field. C) field. D) attribute.

attribute

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

attribute

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: A) data definition diagram. B) data dictionary. C) entity-relationship diagram. D) relationship dictionary.

data dictionary

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

data scrubbing

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function. A) data administration B) server administration C) database administration D) data modeling

database administration

DBMSs typically include report-generating tools in order to

display data in an easier-to-read format.

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

entity-relationship diagram

Data mining allows users to:

find hidden relationships in data.

A data warehouse is composed of:

historic and current internal data.

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

inconsistency.

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.

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table? A) one-to-many B) many-to-many C) one-to-one D) many-to-one

one-to-one

A DBMS makes the: A) physical database available for different relational views. B) logical database available for different analytical views. C) relational database available for different physical views. D) physical database available for different logical views.

physical database available for different logical views

The logical view of a database: A) shows how data are organized and structured on the storage media. B) allows the creation of supplementary reports. C) presents data as they would be perceived by end users. D) presents an entry screen to the user.

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: A) key field. B) foreign key. C) primary field. D) primary key.

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

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

relational DBMS

The type of logical database model that treats data as if they were stored in two-dimensional tables is the: A) relational DBMS. B) hierarchical DBMS. C) pre-digital DBMS. D) two-tiered DBMS

relational DBMS

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

row