ESS_E_testbank_CH05.docVIP

Chapter 5 Foundations of Business Intelligence: Databases and Information Management True-False Questions Each characteristic or quality describing a particular entity is called an attribute. Answer: True Difficulty: Easy Reference: p. 152 A grouping of characters into a word, a group of words, or a complete number is called a record. Answer: False Difficulty: Easy Reference: p. 153 Every record in a file should contain at least one key field. Answer: True Difficulty: Easy Reference: p. 153 In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships. Answer: True Difficulty: Easy Reference: p. 155 DBMS separate the logical and physical views of the data. Answer: True Difficulty: Medium Reference: p. 157 Many applications today require databases that can store and retrieve multimedia. Answer: True Difficulty: Easy Reference: p. 162 One of the drawbacks to OODBMS is that they cannot work with applets. Answer: False Difficulty: Medium Reference: p. 162 OODBMS are slower than relational DBMS. Answer: True Difficulty: Medium Reference: p.162 A data warehouse may include a legacy system. Answer: True Difficulty: Easy Reference: p. 162 A data warehouse is typically comprised of several smaller data marts. Answer: False Difficulty: Easy Reference: p. 162 OLAP is a key tool of BI. Answer: True Difficulty: Easy Reference: p. 163 OLAP enables users to obtain online answers to ad hoc questions in a fairly rapid amount of time, except when the data are stored in very large databases. Answer: False Difficulty: Easy Reference: p. 164 Data mining can be a challenge to individual privacy. Answer: True Difficulty: Easy Reference: p. 166 Predictive analysis is a technique of data mining. Answer: False Difficulty: Medium Reference: pp. 166 Middleware is used to transfer information from the organization’s internal database back to the Web server for delivery in the form of a Web page to the user. Answer: True Difficul