Chapter 09 Database Design Multiple Choice

Chapter 09: Database Design Multiple Choice 21. The process of creating an information system is known as _____. a. systems development b. database development c. network development d. enterprise development ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 9-1 The Information System LEARNINGOBJECTIVES:09.01 - Describe the role of database design as the foundation of a successful information  system 22. The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases.  a. two b. three  c. four d. five ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 9-2 The Systems Development Life Cycle LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 23. Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC).  a. planning b. analysis  c. detailed systems design d. implementation ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 9-2b Analysis LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 24. Coding, testing, and debugging are part of the _____ phase of the Systems Development Life Cycle (SDLC).  a. planning b. analysis  c. detailed systems design d. implementation ANSWER: d DIFFICULTY: Difficulty: Moderate REFERENCES: 9-2d Implementation LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 25. “Should the existing system be replaced?” is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC).  a. planning b. analysis  c. implementation d. maintenance ANSWER: a DIFFICULTY: Difficulty: Moderate REFERENCES: 9-2a Planning LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 26. “What are the requirements of the current system’s end users?” is a question asked during the _____ phase of the Systems Development Life Cycle (SDLC).  planning analysis a. b. c. d. maintenance implementation Page5 Chapter 09: Database Design  b Difficulty: Easy ANSWER: DIFFICULTY: REFERENCES: 9-2b Analysis LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 27. The result of the _____ phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.   a. analysis c. detailed systems design ANSWER: a DIFFICULTY: Difficulty: Moderate REFERENCES: 9-2b Analysis LEARNINGOBJECTIVES: b. implementation d. maintenance 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 28. The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).  a.  c. planning implementation ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 9-2b Analysis LEARNINGOBJECTIVES: b. analysis d. maintenance 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 29. The _____ phase of the Systems Development Life Cycle (SDLC) includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.  a. analysis  c. detailed systems design ANSWER: c DIFFICULTY: Difficulty: Moderate REFERENCES: 9-2c Detailed Systems Design LEARNINGOBJECTIVES: b. implementation d. maintenance 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 30. Training principles and methodologies are planned during the _____ phase of the Systems Development Life Cycle (SDLC).   a. maintenance b. implementation c. analysis ANSWER: DIFFICULTY: REFERENCES: d. detailed systems design d Difficulty: Moderate 9-2c Detailed Systems Design LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 31. During the _____ phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.   a. detailed systems design c. maintenance ANSWER: DIFFICULTY: REFERENCES: LEARNINGOBJECTIVES: b. analysis d. implementation d Difficulty: Moderate 9-2d Implementation 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) Page6 Chapter 09: Database Design 32. The database contents are loaded during the _____ phase of the Systems Development Life Cycle (SDLC).  a. analysis b. detailed systems design  c. implementation d. maintenance ANSWER: c DIFFICULTY: Difficulty: Easy REFERENCES: 9-2d Implementation LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 33. The implementation of _____ applications tends to prolong the operational life of systems by making them easier to update and maintain.  a. database-produced b. network-produced  c. CASE-produced d. design-produced ANSWER: c DIFFICULTY: Difficulty: Easy REFERENCES: 9-2e Maintenance LEARNINGOBJECTIVES: 09.02 - Describe the five phases in the Systems Development Life Cycle (SDLC) 34. In DBLC, the phase after the database initial study is _____.  a. operation b. database design  c. database initial study d. implementation and loading ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 9-3b Database Design LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 35. The maintenance and evolution phase of the Database Life Cycle (DBLC) involves _____.  a. defining objectives b. introducing changes  c. testing the database d. installing the DBMS ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 9-3 The Database Life Cycle LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 36. Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC).  a. database initial study b. database design  c. implementation and loading d. testing and evaluation ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 9-3 The Database Life Cycle LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 37. Producing the required information flow is part of the _____ phase of the Database Life Cycle (DBLC). a. database initial study b. database design Page7 Chapter 09: Database Design  c. operation ANSWER: DIFFICULTY: REFERENCES: d. testing and evaluation c Difficulty: Moderate 9-3 The Database Life Cycle LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 38. _____ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.  a. Normalization c. Specialization ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 9-3c Implementation and Loading b. Virtualization d. Generalization LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 39. The implementation and loading phase of the Database Life Cycle (DBLC) involves _____. a. b. introducing changes c. testing the database d. ANSWER: d DIFFICULTY: Difficulty: Moderate REFERENCES: 9-3c Implementation and Loading defining objectives installing the DBMS LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 40. In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is _____. a. database analysis and requirements b. ER modeling and normalization c. data model verification ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 9-4d Distributed Database Design d. distributed database design LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 41. In the context of the database design process, the conceptual design step that determines end-user views, outputs, and transaction-processing requirements is _____. a. data analysis and requirements b. entity relationship modeling and normalization c. data model verification d. distributed database design ANSWER: a Difficulty: Easy DIFFICULTY: 9-4a Data Analysis and Requirements REFERENCES: LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 42. _____ can render data useless to unauthorized users who might have violated some of the database security layers. a. c. ANSWER: Data encryption b. Access rights Physical security a d. Password security Page8 Chapter 09: Database Design DIFFICULTY: Difficulty: Easy REFERENCES: 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 43. Once the data has been loaded into the database, the _____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.  a. programmer b. manager  c. database administrator d. systems administrator ANSWER: c DIFFICULTY: Difficulty: Easy REFERENCES: 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 44. In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up.  a. transaction log backup b. conservative backup  c. differential backup d. adaptive backup ANSWER: c DIFFICULTY: Difficulty: Easy REFERENCES: 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 45. Which of the following is a hardware-induced database failure?  a. Memory chip errors b. Viruses  c. Malware d. Abortion due to deadlock ANSWER: a DIFFICULTY: Difficulty: Moderate REFERENCES: 9-3d Testing and Evaluation LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 46. The last step in the Database Life Cycle (DBLC) is _____.  a. maintenance and evolution b. operation  c. testing and evaluation d. implementation and loading ANSWER: a DIFFICULTY: Difficulty: Easy REFERENCES: 9-3f Maintenance and Evolution LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 47. The first step in developing the conceptual model using ER diagrams is to _____.  a. normalize the entities b. complete the initial ER diagram  c. identify, analyze, and refine the d. define the attributes, primary keys, and foreign keys for each of business rules the entities ANSWER: c DIFFICULTY: Difficulty: Moderate REFERENCES: 9-4b Entity Relationship Modeling and Normalization LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework Page9 Chapter 09: Database Design 48. The first step in the ER model verification process is to _____.  a. identify each module and its components b. identify the ER model's central entity  c. verify all processes against the ER model d. identify each module's internal transaction requirements ANSWER: b DIFFICULTY: Difficulty: Moderate REFERENCES: 9-4c Data Model Verification LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 49. _____ is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.  a. Conceptual design b. Network design  c. Logical design d. Physical design ANSWER: d DIFFICULTY: Difficulty: Easy REFERENCES: 9-7 Physical Design LEARNINGOBJECTIVES:09.03 - Design databases using the six phases in the Database Life Cycle (DBLC) framework 50. During decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.  a. declaration process b. verification process  c. conceptual process d. logical process ANSWER: b DIFFICULTY: Difficulty: Easy REFERENCES: 9-9 Centralized versus Decentralized Design LEARNINGOBJECTIVES: 09.06 - Distinguish between centralized and decentralized conceptual database design Page10