61) 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.
62) ________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships.
A) OLAP
B) Text mining
C) In-memory
D) Clustering
63) An alternative to using application server software for interfacing between a Web server and back-end databases is
A) CGI.
B) HTML.
C) Java.
D) SQL.
64) The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)
A) information policy.
B) data definition file.
C) data quality audit.
D) data governance policy.
65) 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.
66) 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
67) Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called
A) data auditing.
B) defragmentation.
C) data scrubbing.
D) data optimization.
68) 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?
A) address
B) city
C) airport code
D) state
69) Data cleansing not only corrects errors but also
A) establishes logical relationships between data.
B) structures data.
C) normalizes data.
D) enforces consistency among different sets of data.
70) Which of the following is not a method for performing a data quality audit?
A) surveying entire data files
B) surveying samples from data files
C) surveying data definition and query files
D) surveying end users about their perceptions of data quality
