Chapter 03 Databases and Data Warehouses: Supporting the
Analytics-Driven Organization Answer Key
Multiple Choice Questions
1.
_____ refers to collective information that gives you the ability to make
effective, important, and often strategic business decisions.
2.
_____ is the science of fact-based decision making.
3.
_____ is the gathering of input information, processing that information, and
updating existing information to reflect the gathered and processed
information.
4.
_____ are the technology tools that directly support OLTP.
5.
Databases that support OLTP are most often referred to as ____.
6.
Which application supports the manipulation of information to support
decision making?
7.
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?
8.
A _____ is a special form of a database that contains information gathered
from operational databases for the purpose of supporting decision-making
tasks.
9.
What is the most popular model for creating databases?
10.
A _____ is a collection of information that you organize and access
according to the logical structure of that information.
11.
Which term refers to a specific piece of information that is stored in a
database file?
12.
Your student ID is an example of a(n) ____.
13.
Which type of database model organizes and accesses information
according to its logical structure rather than its physical structure?
14.
Which part of a relational database contains the logical structure for the
information?
15.
A(n) _____ is a field or group of fields that uniquely describes each record.
16.
Which type of application requires that you know the physical location of
information before you are able to access it?
17.
If your phone number was used in a clothing store to uniquely identify you
as a customer, the phone number would be considered a(n) ____.
18.
A(n) _____ key is a primary key of one file that appears in another file.
19.
Which type of constraint ensures the quality of information in a relational
database?
20.
A(n) _____ helps you specify the logical organization for a database and
access and use the information within a database.
21.
A database management system contains five important software
components. Which of the following components accepts and processes
requests from the other four database components?
22.
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?
23.
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?