Content Frame
Note for screen reader users: There is text between the form elements on this page. To be sure that you do not miss any text, use item by item navigation methods, rather than tabbing from form element to form element.
Skip Breadcrumb Navigation
Home arrow Chapter 11 arrow Online Study Guide

Online Study Guide



 This activity contains 42 questions.

Question 1.
Properly designed databases cut down on ____________ by ensuring that relevant data is recorded in only one place.
 
End of Question 1


Question 2.
A category of information in a database is stored in a:
 
End of Question 2


Question 3.
In a database, an object field is used for storing:
 
End of Question 3


Question 4.
The ___________ uniquely identifies a record in a database.
 
End of Question 4


Question 5.
____________ databases are characterized by logical linkages between tables via primary and foreign keys.
 
End of Question 5


Question 6.
The purpose of a data dictionary in a database is to:
 
End of Question 6


Question 7.
____________ are set up in the student database to alert the user if clearly wrong entries are entered in a field.
 
End of Question 7


Question 8.
SQL is a(n):
 
End of Question 8


Question 9.
When you want to extract data that is in two or more tables, you use a:
 
End of Question 9


Question 10.
The process of eliminating data redundancy by ensuring that tables pertain to a single topic is called:
 
End of Question 10


Question 11.
Data warehouses contain:
 
End of Question 11


Question 12.
All of the following are part of the process of data staging for a data warehouse EXCEPT:
 
End of Question 12


Question 13.
Which of the following applications is considered an office support system?
 
End of Question 13


Question 14.
A characteristic of decision support systems is that they assist decision makers via interaction with analysis tools called:
 
End of Question 14


Question 15.
Which of the following is NOT a data-mining technique?
 
End of Question 15


Question 16.
Databases that contain not only data but also methods for processing or manipulating that data are called:
 
End of Question 16


Question 17.
To extract data from a database, you use:
 
End of Question 17


Question 18.
Which of the following is NOT an information systems category?
 
End of Question 18


Question 19.
A(n) ____________ check ensures that all database fields defined as "required" have data entered into them.
 
End of Question 19


Question 20.
It is widely accepted that the average business doubles the amount of data it accumulates every:
 
End of Question 20


Question 21.
Object-oriented databases can store more types of data than relational databases and access that data faster.
   
 
End of Question 21


Question 22.
Online transaction processing (OLTP) ensures that data in the TPS is as up to date as possible.
   
 
End of Question 22


Question 23.
Fuzzy logic involves application of deterministic rules for classification of data.
   
 
End of Question 23


Question 24.
Model management systems and knowledge-based systems are important components of a decision support system.
   
 
End of Question 24


Question 25.
Summary and exception reports are the typical outputs of transaction processing systems.
   
 
End of Question 25


Question 26.
Databases, data warehouses, and data marts are integral parts of information systems because they store the information that makes information systems functional.
   
 
End of Question 26


Question 27.
Data integrity means that the data contained in the database is accurate and reliable.
   
 
End of Question 27


Question 28.
There are no disadvantages associated with databases.
   
 
End of Question 28


Question 29.
Text fields can contain numbers.
   
 
End of Question 29


Question 30.
Primary keys have to be numbers that are already contained in the database.
   
 
End of Question 30


Question 31.
Almost all relational and object-relational databases today use structured query language, or SQL.
   
 
End of Question 31


Question 32.
A consistency check compares the values of data in two or more fields in a database to see if these values are reasonable.
   
 
End of Question 32


Question 33.
A database select query displays a subset of data from a table based on the criteria you specify.
   
 
End of Question 33


Question 34.
Small slices of a data warehouse are called data mines.
   
 
End of Question 34


Question 35.
Office support systems are designed to assist employees in accomplishing their day-to-day tasks.
   
 
End of Question 35


Question 36.
Batch processing means that the database is queried and updated each time a transaction takes place.
   
 
End of Question 36


Question 37.
Data mining is the process by which large amounts of data are analyzed to spot otherwise hidden trends.
   
 
End of Question 37


Question 38.
Information systems are hardware-based solutions that are used to gather and analyze information.
   
 
End of Question 38


Question 39.
A summary report provides a list of all the transactions that occurred during a certain time period.
   
 
End of Question 39


Question 40.
A group of related database fields is called a record.
   
 
End of Question 40


Question 41.
Match the following to their appropriate descriptions.
A matching question presents 6 answer choices and 6 items. The answer choices are lettered A through F. The items are numbered 41.1 through 41.6. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A a technique for understanding spoken or written language
B database query language
C information system that produces management reports
D transaction processing done in real time
E supports order processing, payroll, and other routine transactions
F large object data in binary form
 
 
 
 
 
 
End of Question 41


Question 42.
Match the following terms to their appropriate descriptions.
A matching question presents 6 answer choices and 6 items. The answer choices are lettered A through F. The items are numbered 42.1 through 42.6. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A data contained in the database is accurate and reliable
B criteria used to ensure that data entered into the database is correct (or at least reasonable) and complete
C ensures that the data entered into the database falls within a certain span of numbers
D compares the values of data in two or more fields to see if these values are reasonable
E ensures that all fields defined as "required" have data entered into them
F confirms that only numbers are entered in the field
 
 
 
 
 
 
End of Question 42





Pearson Copyright © 1995 - 2010 Pearson Education . All rights reserved. Pearson Prentice Hall is an imprint of Pearson .
Legal Notice | Privacy Policy | Permissions

Return to the Top of this Page