CHAPTER 6 MGMT
87. What is a primary key? A. A field (or group of fields) that uniquely identifies a given entity in a table B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables C. Characteristics or properties of an entity D. A field (or group of fields) that uniquely identifies a given attribute in a table
A. A field (or group of fields) that uniquely identifies a given entity in a table
68. Which of the following are examples of transactional information? A. Airline ticket, sales receipts, and packing slips B. Trends and sales statistics C. Product sales results, grocery receipts, and growth projections D. Airline tickets and sales growth spreadsheets
A. Airline ticket, sales receipts, and packing slips
60. Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks? A. Analytical information B. Transactional information C. Statistical information D. Targeted information
A. Analytical information
97. What is a logical data structure that details the relationship among data elements using graphics or pictures? A. Data model B. Data element C. Data mining tool D. Data mart tool
A. Data model
83. What maintains information about various types of objects, events, people, and places? A. Database B. Data model C. Data mining D. Data intelligence
A. Database
91. What is the physical view of information? A. Deals with the physical storage of information on a storage device such as a hard disk B. Deals with the logical storage of information on a storage device such as a hard disk C. Focuses on how users logically access information to meet their particular business needs D. Focuses on how users physically access information to meet their particular business needs
A. Deals with the physical storage of information on a storage device such as a hard disk
44. Which of the following represents the different information granularities? A. Detail, summary, aggregate B. Document, presentation, spreadsheet, database C. Individual, department, enterprise D. None of the above
A. Detail, summary, aggregate
85. In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? A. Entity B. Relationships C. Attribute D. Foreign Key
A. Entity
63. Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing individual and departmental goals, and generating financial analysis across departments and the enterprise as a whole for the executive team to review. Ben's duties provide value-added to his company and would be categorized as occurring at the different ____________. A. Information levels B. Information formats C. Information granularities D. Information focus
A. Information levels
57. Which of the following represent the four primary traits that help determine the value of information? A. Information type, information timeliness, information quality, and information governance B. Information statistics, information tracking, information quality, and information governance C. Information type, information chance, information analytics, and information policy D. Information timeliness, information quality, information quantity, and information governance policy
A. Information type, information timeliness, information quality, and information governance
75. Which of the following would not be considered part of the timely characteristic of high-quality information? A. Is the zip code missing in the address? B. Is the information current with respect to business needs? C. Is the customer address current? D. Is the information updated weekly or hourly?
A. Is the zip code missing in the address?
48. What is immediate, up-to-date information? A. Real-time information B. Real-time systems C. Information granularity D. All of the above
A. Real-time information
94. Which of the following asks users to write lines of code to answer questions against a database? A. Structured query language B. Relational query language C. Structured elements D. Data mining tools
A. Structured query language
46. What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks? A. Transactional information B. Analytical information C. Timeliness D. Quality
A. Transactional information
55. What is it called when each transaction, entity, and event is represented only once in the information? A. Uniqueness B. Accuracy C. Consistency D. Timeliness
A. Uniqueness
88. What is a foreign key? A. A field (or group of fields) that uniquely identifies a given entity in a table B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables C. Characteristics or properties of an entity D. A field (or group of fields) that uniquely identifies a given attribute in a table
B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
47. What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks? A. Transactional information B. Analytical information C. Timeliness D. Quality
B. Analytical information
70. Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls. A. Improvements B. Change C. Clustering D. Cleansing
B. Change
96. What is the smallest or basic unit of information? A. Database management element B. Data element C. Data model D. Data integrity issue
B. Data element
82. What is the overall management of the availability, usability, integrity, and security of company data? A. Data Intelligence B. Data governance C. Data forbearance D. Data forecasting
B. Data governance
72. Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data? A. Data inconsistency issue B. Data integrity issue C. Data control issue D. Data mining issue
B. Data integrity issue
93. Which of the following creates, reads, updates, and deletes data in a database while controlling access and security? A. Database element B. Database management system C. Data governance D. Data File
B. Database management system
43. Which of the following represents the different information formats? A. Detail, summary, aggregate B. Document, presentation, spreadsheet, database C. Individual, department, enterprise D. None of the above
B. Document, presentation, spreadsheet, database
100. Which of the following illustrates the primary concepts of the relational database model? A. Ethics, applications, keys, and relationships B. Entities, attributes, keys, and relationships C. Endeavor, aspire, control, and regulate D. Early, after, before, and future
B. Entities, attributes, keys, and relationships
62. Ben works at a top accounting firm in Salt Lake City and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products. Ben's duties provide value-added to his company and would be categorized as occurring at the different ____________. A. Information levels B. Information formats C. Information granularities D. Information focus
B. Information formats
56. Which of the following refers to the extent of detail within the information? A. Knowledge information B. Information granularity C. Chance information D. Information analytics
B. Information granularity
74. Which of the following would not be considered part of the complete characteristic of high-quality information? A. Is a value missing from the personal information? B. Is each transaction represented only once in the information? C. Is the address incomplete? D. Is the area code missing for the phone information?
B. Is each transaction represented only once in the information?
78. Which of the following would not be considered part of the consistent characteristic of high-quality information? A. Do all sales columns equal the total for the revenue column? B. Is the two digit state code missing in the information? C. Is all summary information in agreement with detailed information? D. Does the order number match the item and the color options available?
B. Is the two digit state code missing in the information?
52. What is a real-time system? A. Provides immediate, up-to-date information B. Provides real-time information in response to query requests C. Encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks D. Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks
B. Provides real-time information in response to query requests
49. What provides real-time information in response to query requests? A. Real-time information B. Real-time systems C. Information level D. All of the above
B. Real-time systems
92. Which of the following is correct in reference to a database? A. A database can support only one logical view B. A database can support many physical views C. A database can support many logical views D. A database can support up to 3 logical views
C. A database can support many logical views
53. Which of the following implies that aggregate or summary information is in agreement with detailed information? A. Uniqueness B. Completeness C. Consistency D. Accuracy
C. Consistency
90. Which of the following is incorrect in reference to a database? A. A database can be relational or network B. Database information is accessed by logical structure C. Database information is accessed by physical structure D. Database users can have different views of information
C. Database information is accessed by physical structure
69. Which of the following are examples of analytical information? A. Airline ticket, sales receipts, and packing slips B. Hotel reservation, sales receipts, and packing slips C. Future growth analysis, sales projections, and product statistics D. Packing slips, grocery receipt, and competitor information
C. Future growth analysis, sales projections, and product statistics
89. Which of the following is a disadvantage of database-stored information? A. Increased flexibility B. Increased performance C. Increased data redundancy D. Increased data integrity
C. Increased data redundancy
42. Which of the following represents the different information levels? A. Detail, summary, aggregate B. Document, presentation, spreadsheet, database C. Individual, department, enterprise D. None of the above
C. Individual, department, enterprise
64. Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson, product, and part as well as departmental-wide sales reports by salesperson, product, and part. Ben's duties provide value-added to his company and would be categorized as occurring at the different ____________. A. Information levels B. Information formats C. Information granularities D. Information focus
C. Information granularities
77. Which of the following would not be considered part of the unique characteristic of high-quality information? A. Are there any duplicate orders? B. Are there any duplicate customers? C. Is aggregate information in agreement with detailed information? D. Is each transaction and event represented only once in the information?
C. Is aggregate information in agreement with detailed information?
50. What is one of the biggest pitfalls associated with real-time information? A. It is only available to high-level executives due to the expense B. It is only available in aggregate levels of granularity C. It continually changes D. It rarely changes
C. It continually changes
41. Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the below represents the three common types of information found throughout an organization? A. Levels, forms, granularities B. Levels, forms, data C. Levels, formats, granularities D. Data, formats, granularities
C. Levels, formats, granularities
The 38 primary purpose of a data warehouse is to perform transactional processes.
FALSE
51. Which of the following is not one of the five characteristics common to high-quality information? A. Accuracy B. Completeness C. Quantity D. Consistency
C. Quantity
95. What is the primary tool that retrieves information and helps users graphically design the answer to a question? A. Data mining tools B. Structured example language C. Query-by-example tool D. Relational query tool
C. Query-by-example tool
65. Which of the following refers to immediate, up-to-date information? A. Daily information B. Strategic information C. Real-time information D. Crisis information
C. Real-time information
67. Which of the following provides real-time information in response to requests? A. Sales system B. Transactional system C. Real-time system D. Salary system
C. Real-time system
99. Which of the following systems allow users to create, read, update, and delete data in a relational database? A. Business intelligence system B. Informational database system C. Relational database management system D. Data mining system
C. Relational database management system
81. Some of the serious business consequences that occur due to using low-quality information to make decisions are all of the following except: A. Inability to accurately track customers B. Inability to identify selling opportunities C. The success of the organization depends on appreciating and leveraging the low-quality information D. Lost revenue opportunities from marketing to nonexistent customers
C. The success of the organization depends on appreciating and leveraging the low-quality information
86. Why do relational databases use primary keys and foreign keys? A. To create an entity B. To create physical relationships C. To create logical relationships D. To create an attribute
C. To create logical relationships
58. What are the two different categories for information type? A. Analytical and productive B. Analytical and analysis C. Transactional and analytical D. Transactional and analysis
C. Transactional and analytical
73. Which of the following lists include all of the five characteristics common to high-quality information? A. Accuracy, completeness, strength, support, and positive feedback B. Accuracy, association, referral, sales, and marketing C. Accuracy, competition, support, customer service, and visibility D. Accuracy, completeness, consistency, timeliness, and uniqueness
D. Accuracy, completeness, consistency, timeliness, and uniqueness
79. Which of the following represents a reason for low-quality information? A. Online customers intentionally enter inaccurate information to protect the privacy B. Different systems have different information entry standards and formats C. Third-party and external information contains inaccuracies and errors D. All of the above
D. All of the above
80. Nestle is one of the companies shown as an example of low-quality information causing problems for the company. Which of the following are some of the errors they found in the data or information? A. They had 550,000 actual vendors, yet the information reports showed over 9 million due to duplication and abbreviation inaccuracies B. Some of the vendor names were abbreviated where others were not C. They had too many inaccuracies and duplications to be able to identify customer profitability D. All of the above
D. All of the above
84. A database maintains information on __________. A. Inventory B. Transactions C. Employees D. All of the above
D. All of the above
66. Which of the below does not represent a company that requires up-to-the-second information? A. 911 response B. Stock traders C. Banks D. Construction companies
D. Construction companies
98. What compiles all of the metadata about the data elements in the data model? A. Data entity B. Data element C. Data attribute D. Data dictionary
D. Data dictionary
71. Which of the following occurs when the same data element has different values? A. Data modeling issue B. Data mining issue C. Data governance issue D. Data inconsistency issue
D. Data inconsistency issue
76. Which of the following would not be considered part of the accurate characteristic of high-quality information? A. Is the name spelled correctly? B. Is the email address invalid? C. Does the name and the phone values have the exact same information? D. Is aggregate information in agreement with detailed information?
D. Is aggregate information in agreement with detailed information?
45. Which of the following is not a primary trait of information? A. Transactional B. Analytical C. Timeliness D. Quantity
D. Quantity
54. Which of the following implies that information is current with respect to the business requirement? A. Uniqueness B. Accuracy C. Consistency D. Timeliness
D. Timeliness
59. Which of the following encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks? A. Targeted information B. Analytical information C. Productive information D. Transactional information
D. Transactional information
61. Which of the following companies used analytical analysis to identify a correlation between storms and the increased sale of Pop-Tarts? A. 7-Eleven B. Burger King C. McDonalds D. Walmart
D. Walmart
1. Today's Chief Information Officers are finding that business intelligence software is unnecessary and a financial burden for most companies.
FALSE
10. The three primary data models for organizing information in a DBMS are 1-hierarchical, 2-network, and 3-metadata.
FALSE
12. Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.
FALSE
14. Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.
FALSE
20. A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.
FALSE
22. A data miner contains a subset of data warehouse information.
FALSE
23. ETL, within a data warehouse model, stands for exit, track, and load.
FALSE
25. A data mart is the process of analyzing data to extract information not offered by the raw data alone.
FALSE
27. Text mining analyzes structured data to find trends and patterns in words and sentences.
FALSE
28. The financial industry uses business intelligence to predict hardware failures.
FALSE
3. Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).
FALSE
32. Timely information must be up-to-the-second to be accurate.
FALSE
35. A foreign key is a fie (ldor group of fields) that uniquely identifies a given entity in a table.
FALSE
36. One of the advantages found in a relational database is increased information redundancy.
FALSE
39. Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.
FALSE
4. There are two main primary traits that help you determine the value of information including timeliness and quality.
FALSE
40. The data warehouse is a location for all of business information.
FALSE
7. MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.
FALSE
8. A foreign key provides details about data.
FALSE
13. Data redundancy is the duplication of data, or the storage of the same data in multiple places.
TRUE
15. A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.
TRUE
16. Data-driven website offer several advantages as it is far easier to manage content and store large amounts of data.
TRUE
17. Zappos is an online shoe retailer, built its data-driven website catering to a specific niche market: consumers who were tired of finding that their most-desired items were always out of stock at traditional retailers.
TRUE
18. A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
TRUE
19. Data warehouses struggle with combining too much standardized information.
TRUE
2. Information can tell an organization how it's currently performing and help it estimate and strategize for future plans and performance.
TRUE
21. Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.
TRUE
24. Within the data warehouse model, the external databases could include competitor information, industry information and stock market analysis.
TRUE
26. Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.
TRUE
29. The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.
TRUE
30. Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.
TRUE
31. Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.
TRUE
33. Organizational information comes at different levels and in different formats and granularities.
TRUE
34. Reports for each sales person, product, and part are examples of detail or fine information granularities.
TRUE
37. Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.
TRUE
5. If a manager identifies numerous data integrity issues he should consider the reports generated from that data as invalid and not use them when making decisions.
TRUE
6. The core component of any system, regardless of size, is a database and a database management system.
TRUE
9. There are three primary data models for organizing information including the hierarchical, network, and relational database models.
TRUE
11. Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.
TRUE`