Chapter 3 Database Systems, Data Warehouses, and Data Marts Multiple Choice

Chapter 3-Database Systems, Data Warehouses, and Data Marts Multiple Choice 16. Which statement is true of a database? a. It allows more than one program to use the same data. b. It comprises data that cannot be linked. c. It consists of a segregated set of files. d. It is a crucial tool for managing overseas subsidiaries. ANSWER: RATIONALE: POINTS: a Correct. In a database, programs and data are independent, so more than one program can use the same data. See 3-1: Databases 1 Moderate Define a database and a database management system. DIFFICULTY: REFERENCES: QUESTION TYPE: HAS VARIABLES: False Multiple Choice LEARNING OBJECT MIS9.BIDG. 19.03.01 IVES: TOPICS: KEYWORDS: DATE CREATED: DATE MODIFIED: Databases Database defined Understand 17. Which statement is true of a flat file system? a. Same data can be stored in more than one file. b. Programs and data are independent. C. Complex requests can be handled easily. d. It requires very less storage space. ANSWER: RATIONALE: POINTS: DIFFICULTY: a Correct. The problem with a flat file organization is that the same data could be stored in more than one file, creating data redundancy. See 3-1: Databases 1 Moderate REFERENCES: Define a database and a database management system. QUESTION TYPE: Multiple Choice HAS VARIABLES: False LEARNING OBJECMIS9.BIDG.19.03.01 TIVES: TOPICS: KEYWORDS: DATE CREATED: DATE MODIFIED: Databases Database defined Understand 18. What is one advantage of a database over a flat file system? a. Hardware and software start-up costs are low when using a database. b. A database is simple and easy to design. c. Programs and data are interdependent in a database. d. A database uses more sophisticated security measures. Page 8 ANSWER: RATIONALE: POINTS: d Correct. Compared to a flat file system, more sophisticated security measures can be used in a database. See 3-1: Databases 1 Chapter 3-Database Systems, Data Warehouses, and Data Marts DIFFICULTY: Moderate REFERENCES: Define a database and a database management system. QUESTION TYPE: Multiple Choice HAS VARIABLES: False LEARNING OBJECTI MIS9.BIDG.19.03.01 VES: TOPICS: Databases Hierarchical database models KEYWORDS: Understand DATE CREATED: DATE MODIFIED: 19. In comparison with flat file systems, databases: a. minimize data redundancy. b. are easier to design. с. have less sophisticated security measures. d. require more storage space. ANSWER: RATIONALE: POINTS: DIFFICULTY: REFERENCES: QUESTION TYPE: HAS VARIABLES: a Correct. In comparison with flat file systems, databases minimize data redundancy. See 3-1: Databases 1 Moderate Define a database and a database management system. Multiple Choice False LEARNING OBJECTIVE MIS9.BIDG. 19.03.01 S: TOPICS: KEYWORDS: DATE CREATED: DATE MODIFIED: Databases Database defined Understand 20. In comparison with a flat file system, in a database. b. programs and data are interdependent c. complex requests cannot be handled easily d. data redundancy is introduced ANSWER: RATIONALE: storage space is reduced a Correct. In comparison with a flat file system, storage space is reduced in a database. The problem with flat file organization is that the same data could be stored in more than one file, creating data redundancy. See 3-1: Databases Moderate POINTS: 1 DIFFICULTY: REFERENCES: Define a database and a database management system. Chapter 3-Database Systems, Data Warehouses, and Data Marts QUESTION TYPE: Multiple Choice HAS VARIABLES: False LEARNING OBJEC MIS9.BIDG. 19.03.02 Relational database design TIVES: TOPICS: KEYWORDS: Remember DATE CREATED: DATE MODIFIED: 38. table. improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a Triangulation b. Fragmentation C. Normalization d. Encapsulation ANSWER: C RATIONALE: Correct. To improve database efficiency, a process called normalization is used, which eliminates redundant data and ensures that only related data is stored in a table. See 3-2: Logical Database Design POINTS: DIFFICULTY: 1 Easy REFERENCES: Explain logical database design and the relational database model. QUESTION TYPE: Multiple Choice HAS VARIABLES: False LEARNING OBJEC MIS9.BIDG.19.03.02 TIVES: TOPICS: Relational database design KEYWORDS: Remember DATE CREATED: DATE MODIFIED: 39. In a relational database model, which operation searches data in a table and retrieves records based on certain criteria? a. insert operation b. join operation c. find operation d. select operation ANSWER: d RATIONALE: Correct. In a relational database model, a select operation searches data in a table and retrieves records based on certain criteria or conditions. See 3-2: Logical Database Design POINTS: 1 DIFFICULTY: Easy REFERENCES: Explain logical database design and the relational database model. QUESTION TYPE: Multiple Choice HAS VARIABLES: False LEARNING OBJEC MIS9.BIDG.19.03.02 Page 18 Chapter 3-Database Systems, Data Warehouses, and Data Marts TIVES: TOPICS: KEYWORDS: DATE CREATED: DATE MODIFIED: Relational database design Remember 40. In a relational database model, which operation pares down a table by eliminating columns according to certain criteria? project operation b. join operation find operation d. ANSWER: a RATIONALE: POINTS: DIFFICULTY: insert operation Correct. In a relational database model, a project operation pares down a table by eliminating columns according to certain criteria. For example, users may need a list of students but do not want to include their ages. This data can be retrieved using the project operation. See 3-2: Logical Database Design 1 Easy REFERENCES: Explain logical database design and the relational database model. QUESTION TYPE: Multiple Choice HAS VARIABLES: False LEARNING OBJEC MIS9.BIDG. 19.03.02 TIVES: TOPICS: Relational database design KEYWORDS: Remember DATE CREATED: DATE MODIFIED: 41. Which component of a database management system (DBMS) is responsible for data storage, manipulation, and retrieval? database storage b. data mine data mart ANSWER: d RATIONALE: database engine Correct. A database engine, the heart of DBMS software, is responsible for data storage, manipulation, and retrieval. Because more than one logical view of data is possible, the database engine can retrieve and return data to users in many different ways. See 3-3: Components of a DBMS POINTS: 1 DIFFICULTY: Easy REFERENCES: Define the components of a database management system. QUESTION TYPE: Multiple Choice HAS VARIABLES: False