(Test Bank) Modern Database Management

Hoffer, 13

Computer Science & Engineering

Test Bank

13th Edition

• $15.00 $50.00

---

Description

Test Bank for Modern Database Management, The downloadable file consists of 374 pages, and the total size of the file is 3.9 MB. Purchase now only for highly discounted price.

Author(s): Hoffer

---

---

Study Note Preview

1 Copyright © 2019 Pearson Education, Inc. Modern Database Management, 13e (Hoffer) Chapter 1 The Database Environment and Development Process 1) According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than: A) 1 terabyte of data. B) 3 gigabytes of data. C) at least 100 petabytes of data. D) more than 7 billion exabytes of data. Answer: D LO: 1.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 2) Database management involves all of the following EXCEPT: A) collecting data. B) organizing data. C) design web pages. D) managing data. Answer: C LO: 1.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 3) A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly Answer: A LO: 1.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 4) Legacy systems often contain data of ________ quality and are generally hosted on ________. A) poor; personal computers B) excellent; mainframes C) poor; mainframes D) excellent; workgroup computers Answer: C LO: 3.1: Define key terms. Difficulty: Moderate Classification: Concept AACSB: Information Technology 2 Copyright © 2019 Pearson Education, Inc. 5) Program-data dependence is caused by: A) file descriptions being stored in each database application. B) data descriptions being stored on a server. C) data descriptions being written into programming code. D) data cohabiting with programs. Answer: A LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Moderate Classification: Concept AACSB: Information Technology 6) Because applications are often developed independently in file processing systems: A) the data is always non-redundant. B) unplanned duplicate data files are the rule rather than the exception. C) data can always be shared with others. D) there is a large volume of file I/O. Answer: B LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Moderate Classification: Concept AACSB: Information Technology 7) Relational databases establish the relationships between entities by means of common fields included in a file called a(n): A) entity. B) relationship. C) relation. D) association. Answer: C LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 8) A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A) enterprise view B) reporting document C) user view D) user snapshot Answer: C LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 3 Copyright © 2019 Pearson Education, Inc. 9) A graphical system used to capture the nature and relationships among data is called a(n): A) XML data model. B) hypertext graphic. C) relational database. D) data model. Answer: D LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 10) Data that describe the properties of other data are: A) relationships. B) logical. C) physical. D) metadata. Answer: D LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 11) Metatdata typically describes all of the following EXCEPT: A) data definitions. B) length. C) allowable values. D) location on disk. Answer: D LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 4 Copyright © 2019 Pearson Education, Inc. 12) A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): A) relationship. B) object. C) attribute. D) entity. Answer: D LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 13) ________ are established between entities in a well-structured database so that the desired information can be retrieved. A) Entities B) Relationships C) Lines D) Ties Answer: B LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 14) All of the following are primary purposes of a database management system (DBMS) EXCEPT: A) creating data. B) updating data. C) storing data. D) providing an integrated development environment. Answer: D LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Difficult Classification: Concept AACSB: Information Technology 5 Copyright © 2019 Pearson Education, Inc. 15) With the database approach, data descriptions are stored in a central location known as a: A) server. B) mainframe. C) PC. D) repository. Answer: D LO: 1.6: List and briefly describe nine components of a typical database environment. Difficulty: Moderate Classification: Concept AACSB: Information Technology 16) A user view is: A) what a user sees when he or she looks out the window. B) a table or set of tables. C) a logical description of some portion of the database. D) a procedure stored on the server. Answer: C LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Easy Classification: Concept AACSB: Information Technology 17) A major difference between data warehouses and transactional systems as compared to big data is: A) the data is unstructured in big data systems. B) the size of the CPU used. C) the programming required to access data. D) all of the above. Answer: A LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Difficult Classification: Concept AACSB: Information Technology 18) Which organizational function should set database standards? A) Management B) Application development C) Technical services D) Database Administration Answer: D LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 6 Copyright © 2019 Pearson Education, Inc. 19) ________ is a tool even non-programmers can use to access information from a database. A) ODBC B) Structured query language C) ASP D) Data manipulation query language Answer: B LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Easy Classification: Concept AACSB: Information Technology 20) Which of the following is NOT an advantage of database systems? A) Redundant data B) Program-data independence C) Better data quality D) Reduced program maintenance Answer: A LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Easy Classification: Concept AACSB: Information Technology 21) The most common source of database failures in organizations is: A) lack of planning. B) inadequate budget. C) inadequate hardware. D) failure to implement a strong database administration function. Answer: D LO: 1.4: Identify several costs and risks of the database approach. Difficulty: Difficult Classification: Concept AACSB: Information Technology 22) A rule that CANNOT be violated by database users is called a: A) password. B) constraint. C) program. D) view. Answer: B LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Easy Classification: Concept AACSB: Information Technology 7 Copyright © 2019 Pearson Education, Inc. 23) In a file processing environment, descriptions for data and the logic for accessing the data are built into: A) application programs. B) database descriptors. C) fields. D) records. Answer: A LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Easy Classification: Concept AACSB: Information Technology 24) E. F. Codd developed the relational model in the: A) 1960s. B) 1970s. C) 1980s. D) 1990s. Answer: B LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Easy Classification: Concept AACSB: Information Technology 25) Which of the following is NOT an objective that drove the development and evolution of database technology? A) The need to provide greater independence between programs and data. B) The desire to manage increasing complex data types and structures. C) The desire to require programmers to write all file handling functionality. D) The need to provide ever more powerful platforms for decision support applications. Answer: C LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Difficult Classification: Concept AACSB: Information Technology 8 Copyright © 2019 Pearson Education, Inc. 26) The period that can be considered a "proof of concept" time was the: A) 1950s. B) 1960s. C) 1970s. D) 1990s. Answer: B LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 27) A departmental multi-tiered client/server database is stored on a central device called a: A) client. B) server. C) remote PC. D) network. Answer: B LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Moderate Classification: Concept AACSB: Information Technology 28) Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. A) 40 percent B) 25 percent C) 60 percent D) 80 percent Answer: D LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Moderate Classification: Concept AACSB: Information Technology 29) Which of the following is NOT a cost and/or risk of the database approach? A) Specialized personnel B) Cost of conversion C) Improved responsiveness D) Organizational conflict Answer: C LO: 1.4: Identify several costs and risks of the database approach. Difficulty: Moderate Classification: Concept AACSB: Information Technology 9 Copyright © 2019 Pearson Education, Inc. 30) The need for consensus on data definitions is an example of which type of risk in the database environment? A) Specialized personnel needs B) Organizational conflict C) Conversion costs D) Legacy systems Answer: B LO: 1.4: Identify several costs and risks of the database approach. Difficulty: Moderate Classification: Concept AACSB: Information Technology 31) A knowledge base of information or facts about an enterprise is called a(n): A) enterprise information system. B) repository. C) systems information unit. D) database process. Answer: B LO: 1.6: List and briefly describe nine components of a typical database environment. Difficulty: Easy Classification: Concept AACSB: Information Technology 32) Which of the following is software used to create, maintain, and provide controlled access to databases? A) Network operating system B) User view C) Database management system (DBMS) D) Attribute Answer: C LO: 1.6: List and briefly describe nine components of a typical database environment. Difficulty: Easy Classification: Concept AACSB: Information Technology 33) A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): A) index. B) data warehouse. C) repository. D) database management system. Answer: C LO: 1.6: List and briefly describe nine components of a typical database environment. Difficulty: Easy Classification: Concept AACSB: Information Technology 10 Copyright © 2019 Pearson Education, Inc. 34) Languages, menus, and other facilities by which users interact with the database are collectively called a(n): A) client. B) user interface. C) icon. D) development environment. Answer: B LO: 1.7: Identify four categories of applications that use databases and their key characteristics. Difficulty: Easy Classification: Concept AACSB: Information Technology 35) Database development begins with ________, which establishes the range and general contents of organizational databases. A) database design B) cross-functional analysis C) departmental data modeling D) enterprise data modeling Answer: D LO: 1.7: Identify four categories of applications that use databases and their key characteristics. Difficulty: Easy Classification: Concept AACSB: Information Technology 36) The traditional methodology used to develop, maintain, and replace information systems is called the: A) Enterprise Resource Model. B) Systems Development Life Cycle. C) Unified Model. D) Systems Deployment Life Cycle. Answer: B LO: 1.8: Describe the life cycle of a systems development project, with an emphasis on the purpose of database analysis, design, and implementation activities. Difficulty: Moderate Classification: Concept AACSB: Information Technology 11 Copyright © 2019 Pearson Education, Inc. 37) The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase. A) planning B) design C) analysis D) implementation Answer: C LO: 1.8: Describe the life cycle of a systems development project, with an emphasis on the purpose of database analysis, design, and implementation activities. Difficulty: Easy Classification: Concept AACSB: Information Technology 38) The SDLC phase in which database processing programs are created is the ________ phase. A) planning B) design C) analysis D) implementation Answer: D LO: 1.8: Describe the life cycle of a systems development project, with an emphasis on the purpose of database analysis, design, and implementation activities. Difficulty: Easy Classification: Concept AACSB: Information Technology 39) The SDLC phase in which the detailed conceptual data model is created is the ________ phase. A) planning B) design C) analysis D) implementation Answer: C LO: 1.8: Describe the life cycle of a systems development project, with an emphasis on the purpose of database analysis, design, and implementation activities. Difficulty: Easy Classification: Concept AACSB: Information Technology 12 Copyright © 2019 Pearson Education, Inc. 40) Specifying how data from a logical schema are stored in secondary memory is part of the: A) design. B) maintenance. C) analysis. D) implementation. Answer: A LO: 1.8: Describe the life cycle of a systems development project, with an emphasis on the purpose of database analysis, design, and implementation activities. Difficulty: Easy Classification: Concept AACSB: Information Technology 41) An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: A) CASE. B) CAD. C) RAD. D) MST. Answer: C LO: 1.9: Explain the prototyping and agile-development approaches to database and application development. Difficulty: Easy Classification: Concept AACSB: Information Technology 42) One of the most popular RAD methods is: A) automated design. B) structured walkthrough. C) prototyping. D) crafting. Answer: C LO: 1.9: Explain the prototyping and agile-development approaches to database and application development. Difficulty: Moderate Classification: Concept AACSB: Information Technology 13 Copyright © 2019 Pearson Education, Inc. 43) ________ specify computer systems requirements. A) Programmers B) Users C) Systems analysts D) Database analysts Answer: C LO: 1.10: Explain the roles of individuals who design, implement, use, and administer databases. Difficulty: Easy Classification: Concept AACSB: Information Technology 44) ________ do NOT concentrate on determining the requirements for the database component of an information system. A) Database analysts B) Systems analysts C) Programmers D) End Users Answer: D LO: 1.10: Explain the roles of individuals who design, implement, use, and administer databases. Difficulty: Easy Classification: Concept AACSB: Information Technology 45) The three-schema approach includes which of the following schemas? A) Internal B) Logical C) Cross-functional D) Dissecting Answer: A LO: 1.11: Explain the differences among external, conceptual, and internal schemas and the reasons for the three-schema architecture for databases. Difficulty: Moderate Classification: Concept AACSB: Information Technology 14 Copyright © 2019 Pearson Education, Inc. 46) A data warehouse derives its data from: A) on-line transactions. B) various operational data sources. C) reports. D) a data mart. Answer: B LO: 1.11: Explain the differences among external, conceptual, and internal schemas and the reasons for the three-schema architecture for databases. Difficulty: Moderate Classification: Concept AACSB: Information Technology 47) Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called: A) tables on write. B) schema on write. C) on demand paging. D) caching. Answer: B LO: 1.5: Distinguish between operational (transactional) and informational (data warehousing and big data) data management approaches and related technologies. Difficulty: Moderate Classification: Concept AACSB: Information Technology 48) Information is processed data. Answer: TRUE LO: 1.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 49) Metadata are data that describe the properties of other data. Answer: TRUE LO: 1.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology 50) Databases were developed as the first application of computers to data processing. Answer: FALSE LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Moderate Classification: Concept AACSB: Information Technology 15 Copyright © 2019 Pearson Education, Inc. 51) File processing systems have been replaced by database systems in most critical business applications today. Answer: TRUE LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Easy Classification: Concept AACSB: Information Technology 52) Unplanned duplicate data files are the rule rather than the exception in file processing systems. Answer: TRUE LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Easy Classification: Concept AACSB: Information Technology 53) Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance. Answer: FALSE LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Easy Classification: Concept AACSB: Information Technology 54) Many of the disadvantages of file processing systems can also be limitations of databases. Answer: TRUE LO: 1.2: Name several limitations of conventional file processing systems. Difficulty: Easy Classification: Concept AACSB: Information Technology 55) With the traditional file processing approach, each application shares data files, thus enabling much data sharing. Answer: FALSE LO: 1.3: Explain at least 10 advantages of the database approach, compared to traditional file processing. Difficulty: Easy Classification: Concept AACSB: Information Technology