MBA 5670 Management of Information technologiesDatabase and Data WarehouseReview QuestionsQ.1 In a table the primary key is A) the first record in the tableB) a field, or group of fields, that uniquely identifies an individual recordC) a group of fields with the same contentD) None of the aboveQ.2 Usually, which of the following is not included in a database management system? A) Database B) Database engine/1C) Database manipulation languageD) Database operating systemQ.3 Which of the following can be considered desktop database software?A) Microsoft Excel B) Oracle/1C) Microsoft AccessD) None of the aboveQ.4 In a DBMS, the logical view is:A) The way that data is actually stored on a secondary storage deviceB) The way that data is actually displayed to the user/1C) The way that data is indexed on a secondary storage deviceD) The way that data is publishedQ.5 Which of the following types of DBMS is more convenient for multimedia applications?A) Flat FileB) Relational/1C) Object-OrientedD) None of the aboveQ.56 Which of the following could define a composite key:A) the first record in the tableB) a group of fields that uniquely identify an individual recordC) a group of fields with the same contentD) None of the aboveQ.7 In a table a primary key is … (Circle all correct answers)A) the first record in table 1/4B) a group of field with the same contentC) a field that uniquely identifies an individual recordD) a group of fields that uniquely identify an individual recordQ.8 Which of the following DBMS seen in class would not be classified as a desktop DBMS? A) Microsoft's AccessB) Corel's Paradox/1C) FileMaker ProD) Oracle 9i EnterpriseQ.9 A primary key made up of multiple fields is called: A) Multi keyB) Multiprimary key/1C) Composite keyD) None of the aboveQ.10 In this database model, multiple tables can be linked to each other, by using a common field in each table: A) Linking modelB) Network model/1C) Relational modelD) Hierarchical modelQ.11 Data mining tools include … A) query toolsB) statistical analysis tools/1C) intelligent agentsD) All of the aboveQ.12 A record is a set of ______________ that describe an entity in a table: A) columnsB) rows/1C) fieldsD) None of the aboveQ.13 Which of the following is true about warehouse?A) It, typically, contains both internal and external dataB) It, typically, contains both current and historical data/IC) Its content is used to support business analysis activities as well as decision- making tasks.D) All of the above 2/4Q.14 In a table, the field values represent A) the name assigned to the fieldB) the actual data for the field`/IC) a group of fields with the same contentD) None of the aboveQ.15 Which of the following relationships cannot be handled by the relational database model? A) One-to-One (1:1)B) One-to-Many (1:M)C) Many-to-Many (M:M)D) None of the aboveQ.16 In data warehouse design, Extraction, Transformation, and Loading refers to …A) the process of extracting data from a data warehouse, transforming it, and adding it to internal and external databases.B) the process of extracting data from data marts, transforming it, and adding it to a data warehouse./IC) the process of extracting data from internal and external databases, transforming it, and adding it to the data warehouse.D) None of the aboveQ.17 In a data mart, information appears in two-dimensional tables. T FQ.18 In the Flat File database model, you can create relationship between two tables by using a foreign key.T FQ.19 Traditional File systems are not easier to maintain than database systems T FQ.20 In a data warehouse, information appears in multidimensional containers. T FQ.21 Tables in a Flat file database model are not linked T FQ.22 In the relational database model, you need to allow for a little bit of redundancy in order to create relationships between tables.T FQ.23 Flat file model and Relational model are among the most common database models used today.T FQ.24 Flat File database model is usually used in PDAs T FQ.25 In designing and developing a data warehouse, Information Cleansing occurs during Extraction, Transformation, and Loading.T FQ.26 In designing and developing a data warehouse, Information Cleansing occurs oncethe data in the data warehouse.T F 3/4Q.27 In the sixties and seventies, most business applications use what is called Traditional File system for handling and the applications’ data. Explain what the Traditional File system is and what are the main issues associated with that system.Q.28 Since the late seventies, businesses turned to database management systems – DBMS -for handling and managing data. Discuss the main functions of today’s DBMS.Q.29 Information Cleansing or Scrubbing is used to get and maintain high quality data in datawarehouse. Explain what is Information Cleansing or Scrubbing and when is it done in the process of designing a data warehouse.