SOLVED

21) Which of the following statements is true about query by example capabilities in a database? A) It helps to create a query quickly and easily. B) It refers to immediate automated responses to the requests of users. C) It is designed to handle multiple concurrent transactions from customers. D) Its primary use is gathering new information. E) It prevents illegal entries into a database. 22) The systems that are used to interact with customers and run a business in real time are called ________. A) tactical systems B) strategic systems C) operational systems D) informational systems E) executive systems 23) ________ is the data that is deemed most important in the operation of a business. A) Metadata B) Master data C) Reference data D) Query data E) Tactical data 24) Which of the following statements is true about an operational system? A) Its primary purpose is to support managerial decision making. B) It consists of historical or point-in-time data. C) Its goal is to enhance ease of access and use. D) It consists of narrow and simple updates and queries. E) It is primarily used by managers. 25) Which of the following statements is true about informational systems? A) Its primary purpose is to run the business on a current basis. B) It is primarily used by online customers, clerks, salespersons, and administrators. C) It consists of narrow and simple updates and queries. D) Its goal is to enhance performance. E) Its goal is to enhance ease of access and use. 26) ________ integrates data from various operational systems. A) Data warehouse B) Metadata repository C) Data modeling D) Master data E) Data mining 27) The purpose of a data warehouse is to ________. A) standardize the format of data retrieved from different systems B) allow managers to run queries and reports themselves without having to know query languages or the structure of the underlying data C) provide capabilities for discovering “hidden” predictive relationships in the data D) put key business information into the hands of more decision makers E) reduce the complexity of the data to be analyzed 28) ________ refers to the process of standardizing the format of data retrieved from different systems. A) Data cleansing B) Data mining C) Normalization D) Content mining E) Clustering 29) A ________ is a data warehouse that is limited in scope. A) metadata repository B) master data C) data model D) data reduction E) data mart 30) Which of the following statements is true about a data mart? A) It standardizes the format of data retrieved from different systems. B) It contains selected information from the data warehouse. C) It stores master data only. D) It is is a compilation of data from the database that is organized and produced in printed format. E) It helps to eliminate data duplication.