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 5  arrow Study Guide

Study Guide

Student Objectives

After completing this chapter, you will be able to:

  1. Describe how a relational database organizes data and compare its approach to an object-oriented database.
  2. Identify and describe the principles of a database management system.
  3. Evaluate tools and technologies for providing information from databases to improve business performance and decision making.
  4. Assess the role of information policy and data administration in the management of organizational data resources.
  5. Assess the importance of data quality assurance for the business.


This activity contains 35 questions.

Question 1.
Generalized categories of data on which we store and maintain information in a database is called a(n)


Open Hint for Question 1 in a new window.
 
End of Question 1


Question 2.
The most common type of database is


Open Hint for Question 2 in a new window.
 
End of Question 2


Question 3.
The technical term for records in a database is


Open Hint for Question 3 in a new window.
 
End of Question 3


Question 4.
You use a ________ to clarify table relationships in a relational database.


Open Hint for Question 4 in a new window.
 
End of Question 4


Question 5.
Which of the following is not a database management system software program?


Open Hint for Question 5 in a new window.
 
End of Question 5


Question 6.
Which of the following is not a basic operation in a relational database?


Open Hint for Question 6 in a new window.
 
End of Question 6


Question 7.
A DBMS capability that specifies the structure of its database content is


Open Hint for Question 7 in a new window.
 
End of Question 7


Question 8.
A type of DBMS that stores audio and video files is


Open Hint for Question 8 in a new window.
 
End of Question 8


Question 9.
A database that stores current and historical data and is available to decision makers throughout a company is called


Open Hint for Question 9 in a new window.
 
End of Question 9


Question 10.
A subset of a data warehouse that focuses on a single subject area is called a(n)


Open Hint for Question 10 in a new window.
 
End of Question 10


Question 11.
Which of the following helps develop knowledge about competitors and change decision-making behavior?


Open Hint for Question 11 in a new window.
 
End of Question 11


Question 12.
Which of the following enables users to view data using multiple dimensions?


Open Hint for Question 12 in a new window.
 
End of Question 12


Question 13.
A type of data mining that recognizes patterns that describe a group to which an item belongs is


Open Hint for Question 13 in a new window.
 
End of Question 13


Question 14.
A(n) ________ is used to identify which users and organizational units can share information.


Open Hint for Question 14 in a new window.
 
End of Question 14


Question 15.
Analysis of data quality often begins with a(n)


Open Hint for Question 15 in a new window.
 
End of Question 15


Question 16.
While paper-based databases may be inefficient, they are still cost effective to maintain.


Open Hint for Question 16 in a new window.
   
 
End of Question 16


Question 17.
Attributes describe specific characteristics of entities.


Open Hint for Question 17 in a new window.
   
 
End of Question 17


Question 18.
Attributes for a particular entity can apply to numerous other entities in a relational database.


Open Hint for Question 18 in a new window.
   
 
End of Question 18


Question 19.
Tables in a relational database can have a many-to-many relationship.


Open Hint for Question 19 in a new window.
   
 
End of Question 19


Question 20.
A database that has been normalized will minimize duplicate data.


Open Hint for Question 20 in a new window.
   
 
End of Question 20


Question 21.
A logical view of data in a DBMS shows how data are actually organized and structured on storage devices.


Open Hint for Question 21 in a new window.
   
 
End of Question 21


Question 22.
The project operation in a relational DBMS permits the user to create new tables.


Open Hint for Question 22 in a new window.
   
 
End of Question 22


Question 23.
A DBMS data definition language is used to retrieve data in a database.


Open Hint for Question 23 in a new window.
   
 
End of Question 23


Question 24.
The most prominent data manipulation language used in businesses today is the Structured Query Language (SQL).


Open Hint for Question 24 in a new window.
   
 
End of Question 24


Question 25.
Object-oriented DBMS are becoming popular because they can be used to manage Java applets in Web applications.


Open Hint for Question 25 in a new window.
   
 
End of Question 25


Question 26.
You typically will not find historical data in a data warehouse.


Open Hint for Question 26 in a new window.
   
 
End of Question 26


Question 27.
Data mining is used to find hidden patterns and relationships in databases and help predict future customer behavior.


Open Hint for Question 27 in a new window.
   
 
End of Question 27


Question 28.
Data mining poses challenges to individual privacy protection.


Open Hint for Question 28 in a new window.
   
 
End of Question 28


Question 29.
Even though accessing corporate databases through the Web is creating new efficiencies, it is not changing the way many businesses operate.


Open Hint for Question 29 in a new window.
   
 
End of Question 29


Question 30.
Data cleansing helps a business enforce consistency among different sets of data that originated in separate information systems.


Open Hint for Question 30 in a new window.
   
 
End of Question 30


Question 31.




Open Hint for Question 31 in a new window.
 
To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

End of Question 31


Question 32.




Open Hint for Question 32 in a new window.
 
To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

End of Question 32


Question 33.




Open Hint for Question 33 in a new window.
 
To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

End of Question 33


Question 34.




Open Hint for Question 34 in a new window.
 
To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

End of Question 34


Question 35.




Open Hint for Question 35 in a new window.
 
To create paragraphs in your essay response, type <p> at the beginning of the paragraph, and </p> at the end.

End of Question 35





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