SOLVED

11) To finalize the data model in order to actually build the database, a process called ________ is used to make sure the database will operate efficiently. A) slicing and dicing B) normalization C) clustering D) visualization E) inferencing 12) In DBMS, normalization helps to ________. A) eliminate data duplication B) retrieve information C) format data D) present the data in a useful format E) allocate storage space 13) Once the data model is created, the format of the data is documented in a(n) ________. A) data warehouse B) data mart C) expert system D) data type E) data dictionary 14) A data dictionary is also known as ________. A) data mart B) data warehouse C) metadata repository D) entity-relationship diagram E) clickstream data 15) Bringes, a retail chain, has retail stores across three states. With its current legacy system, Bringes is having problems tracking the inventory levels for its stores. It is planning to implement Oracle database systems to replace this legacy system. Which of the following most supports Bringes’ decision to replace its legacy system with an Oracle database system? A) Implementing Oracle database system means hiring additional specialized personnel to manage it. B) Partial implementation of the Oracle database system can create more problems than it solves. C) Conversion cost required for the implementation of Oracle database system is supported by IT budgets. D) Bringes’ channel partners use a database system that supports the Oracle database system. E) Maintenance cost of an Oracle database system is more than the legacy system presently in use. 16) Treston, an automobile manufacturer, has recently implemented a new database system. It is confident that this system will help enhance the company’s internal (employees) and external (customers and channel partners) communication. Treston is planning to pursue a just-in-time inventory system soon after the database system is implemented. After the implementation of the database system, however, Treston realized that the database system was not effective. Which of the following, if true, can be cited as a reason for the failure of Treston’s database system? A) Microsoft launched a new version of Enterprise Microsoft Access which is better than Treston’s database system. B) The maintenance cost of Treston’s new database system was three times more than the one it was previously using. C) Treston’s new database system was not supported by the database system of its suppliers and distributors. D) Treston’s competitors implemented its database a few days prior to Treston’s implementation date. E) Treston had to hire specialized personnel to manage its new database system, which added to its costs. 17) Business rules are captured by the designers of the database and included in the data dictionary to ________. A) organize and sort the data, complete calculations, and allocate storage space B) prevent illegal or illogical entries from entering the database C) eliminate data duplication D) make sure that each table contains only attributes that are related to the entity E) capture the structure of the database 18) ________ are used to capture data to be added, modified, or deleted from the database. A) Forms B) Reports C) Queries D) Bots E) Layers 19) A(n) ________ is a compilation of data from the database that is organized and produced in printed format. A) form B) attribute C) field D) entity E) report 20) A query is used to ________. A) organize and sort the data in a database B) allocate storage space for a database C) eliminate data duplication D) retrieve information from a database E) prevent illegal or illogical entries from entering the database