1.
Which data administration facility allows you to control who has access to what information and what type of access those people have?
A. 
Security management facilities
B. 
Query optimization facilities
C. 
Reorganization facilities
D. 
Concurrency control facilities
2.
A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?
A. 
Online analytical processing (OLAP)
B. 
Geographic information systems (GIS)
C. 
Enterprise resource planning (ERP)
D. 
Decision support systems (DSS)
3.
Which type of constraint ensures the quality of information in a relational database?
A. 
B. 
C. 
D. 
4.
Which application supports the manipulation of information to support decision making?
A. 
B. 
C. 
D. 
5.
Which organizational function is responsible for the more technical and operational aspects of managing information repositories?
A. 
B. 
C. 
Information resource planning
D. 
6.
A(n) _____ is a field or group of fields that uniquely describes each record.
A. 
B. 
C. 
D. 
7.
In a data warehouse, which data-mining tool would you use to quickly build reports without having to write programming code?
A. 
Application report generator
B. 
C. 
Multidimensional analysis tools
D. 
Query-and-reporting tools
8.
What type of software tool is used to query information stored in a data warehouse?
A. 
B. 
C. 
D. 
9.
Which term refers to a specific piece of information that is stored in a database file?
A. 
B. 
C. 
D. 
10.
If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?
A. 
B. 
C. 
D. 
11.
_____ refers to collective information that gives you the ability to make effective, important, and often strategic business decisions.
A. 
B. 
C. 
D. 
12.
Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?
A. 
B. 
C. 
D. 
13.
A(n) _____ key is a primary key of one file that appears in another file.
A. 
B. 
C. 
D. 
14.
_____ is the process of reinstalling the backup information in the event the information was lost.
A. 
B. 
C. 
D. 
15.
SQL is:
A. 
A standardized fourth generation language found in most DBMSs.
B. 
A storage tool that holds the data and definitions for a database.
C. 
An administrative tool that allows you to set access rights for database users.
D. 
A programming language that can be used instead of a DBMS.
16.
_____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.
A. 
Online analytical processing (OLAP)
B. 
Business intelligence (BI)
C. 
File management systems (FMS)
D. 
Online transaction processing (OLTP)
17.
What must you define before adding any information to a relational database?
A. 
B. 
The physical hardware structure
C. 
The administrative rights of users
D. 
The logical structure of the database
18.
Data warehouses exist to support:
A. 
B. 
C. 
D. 
19.
_____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.
A. 
B. 
C. 
D. 
20.
If you were to perform a regression analysis, what type of data warehouse tool would it be?
A. 
B. 
Multidimensional analysis
C. 
D. 
21.
If the file containing your student information appears in two different places with two different birth dates, your data would not be considered ____.
A. 
B. 
C. 
D. 
22.
What is the most popular model for creating databases?
A. 
Hierarchical database model
B. 
Object-oriented database model
C. 
Ecological database model
D. 
Relational database model
23.
Which part of a relational database contains the logical structure for the information?
A. 
B. 
C. 
D. 
24.
If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view is it?
A. 
B. 
C. 
D. 
25.
Databases that support OLTP are most often referred to as ____.
A. 
B. 
C. 
D.