Chapter 3

25 July 2022
4.7 (114 reviews)
53 test answers

Unlock all answers in this set

Unlock answers (49)
question
7. What is a database management system?
answer
A set of programs that provide users with tools to add, delete, access, modify, and analyze data stored in one location.
question
8. What is normalization?
answer
A method for analyzing and reducing a relational database to its most streamlined form.
question
9. What is a data warehouse?
answer
A repository of data that are organized by business dimension or subject to support decision making.
question
10. List three of the basic characteristics of data warehouses.
answer
Integration of multiple data, inclusion of nonvolatile data, and multidimensional data.
question
11. It is very difficult to manage data for which of the following reasons?
answer
Data are scattered throughout organizations.
question
12. When customers access a Web site and make purchases, they generate _____.
answer
clickstream data
question
13. In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n):
answer
attribute
question
14. Place the following members of the data hierarchy in the correct order:
answer
d. bit - byte - field - record - file - database (correct)
question
15. A(n) _____ is a logical grouping of related fields.
answer
c. record (correct)
question
16. In a database, the primary key field is used to _____.
answer
d. uniquely identify a record (correct)
question
18. A standardized language used to manipulate data is _____.
answer
d. structured query language (correct)
question
17. Data dictionaries perform all of the following functions except:
answer
a. Providing information on each record (correct)
question
19. _____ is a method for analyzing and reducing a relational database to its most streamlined form.
answer
b. Normalization (correct)
question
20. The data in a data warehouse have which of the following characteristics?
answer
a. They are organized by subject. (correct)
question
21. Compared to data warehouses, data marts have which one of the following characteristics?
answer
a. cost less (correct)
question
22. Which of the following is an example of explicit knowledge?
answer
c. procedural guides (correct)
question
23. Explicit knowledge has which of the following characteristics?
answer
a. objective (correct)
question
24. The most important benefit of knowledge management systems is:
answer
b. they make best practices available to employees. (correct)
question
25. Which of the following has (have) the broadest impact on an organization?
answer
c. Decisions about data (correct)
question
26. Which of the following is not a reason why managing data is difficult over time?
answer
e. All of these are reasons why managing data is difficult over time. (correct)
question
27. _____ is a formal approach to managing data consistently across an entire organization.
answer
d. Data governance (correct)
question
28. _____ provide(s) companies with a single version of the truth for their data.
answer
d. Master data management (correct)
question
29. Organizations are turning to data governance for which of the following reasons?
answer
b. They are responding to federal regulations. (correct)
question
31. Not including alphabetic characters in a Social Security Number field is an example of _____ . a. Data isolation. b. Data integrity. c. Data consistency. d. Data redundancy. e. Application/data dependence.
answer
b. Data integrity. (correct)
question
30. _____ describe the activities of the business, whereas _____ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities.
answer
Transaction data, master data (correct)
question
32. _____ occurs when applications cannot access data associated with other applications.
answer
a. Data isolation (correct)
question
33. _____ occurs when the same data are stored in many places.
answer
d. Data redundancy (correct)
question
34. _____ occurs when various copies of the data agree.
answer
c. Data consistency (correct)
question
35. Place the following members of the data hierarchy in their correct order:
answer
d. Bit - byte - field - record - file - database (correct)
question
36. In the data hierarchy, the smallest element is the _____.
answer
b. Bit. (correct)
question
37. A(n) _____ is a logical grouping of characters into a word, a small group of words, or a complete number.
answer
b. Field (correct)
question
38. A(n) _____ is a logical grouping of related fields.
answer
c. Record (correct)
question
39. A(n) _____ is a logical grouping of related records.
answer
d. File (correct)
question
40. A(n) _____ represents a single character, such as a letter, number, or symbol.
answer
a. Byte (correct)
question
41. In a database, the primary key field is used to _____.
answer
d. uniquely identify a record (correct)
question
42. _____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.
answer
b. Secondary keys (correct)
question
43. As an individual student in your university's student database, you are a(n) _____ of the STUDENT class.
answer
a. instance (correct)
question
44. Why is it important for a business to manage data efficiently?
answer
b. Because organized data become information and knowledge that are used in decision making. (Correct)
question
45. It is important that data be:
answer
d. Relevant. (Correct)
question
46. Transaction data are:
answer
b. A record of the activities of the business. (Correct)
question
47. Databases minimize which problem?
answer
a. Data isolation (Correct)
question
48. The first step in creating a database should be:
answer
a. Creating a data model. (Correct)
question
49. ER diagrams consist of all of the following except:
answer
d. Files. (Correct)
question
50. The most popular language used to request information from a database is:
answer
c. SQL. (Correct)
question
51. Which of the following is not a characteristic of data warehouse and data marts?
answer
d. Instantly updated (Correct)
question
52. Objective, rational, and technical knowledge is defined as:
answer
c. Explicit knowledge. (Correct)
question
53. The cumulative store of subjective or experiential learning is defined as:
answer
a. Tacit knowledge. (Correct)
question
1. Which of the following is not a challenge in managing data?
answer
d. The amount of data is getting smaller each year. (correct)
question
2. Which of the following is an example of unstructured data?
answer
d. A video clip on the Internet. (correct)
question
3. Which of the following is not a source of corporate data?
answer
d. Intrinsic motivation. (correct)
question
4. What is a database?
answer
d. A logical grouping of related files. (correct)
question
5. What is an entity?
answer
(b) A person, place, thing, or event about which information is maintained. (correct)
question
6. What is a primary key?
answer
(c) A specific, unique representation of a person, place, or thing. (correct)