(Test Bank) Database Systems Design, Implementation, & Management

Coronel, 12

Computer Science & Engineering

Test Bank

12th Edition

• $15.00 $50.00

---

Description

Test Bank for Database Systems Design, Implementation, & Management, The downloadable file consists of 381 pages, and the total size of the file is 2.6 MB. Purchase now only for highly discounted price.

Author(s): Coronel

---

---

Study Note Preview

TESTBANK DATABASE SYSTEMS - DESIGN, IMPLEMENTATION, MANAGEMENT, 12E CORONEL TB Chapter 01: Database Systems Chapter 02: Data Models Chapter 03: The Relational Database Model Chapter 04: Entity Relationship (ER) Modeling Chapter 05: Advanced Data Modeling Chapter 06: Normalization of Database Tables Chapter 07: Introduction to Structured Query Language (SQL) Chapter 08: Advanced SQL Chapter 09: Database Design Chapter 10: Transaction Management and Concurrency Control Chapter 11: Database Performance Tuning and Query Optimization Chapter 12: Distributed Database Management Systems Chapter 13 : Business Intelligence and Data Warehouses Chapter 14: Big Data Analytics and NoSQL Chapter 15: Database Connectivity and Web Technologies Chapter 16: Database Administration and Security Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 1 1. Data and information are essentially the same thing. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Easy REFERENCES: p. 4 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Data versus Information KEYWORDS: Bloom's: Knowledge 2. Data processing can be as simple as organizing data to reveal patterns. a. True b. False ANSWER: True POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.4 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Data versus Information KEYWORDS: Bloom's: Knowledge 3. Data is the result of processing raw facts to reveal its meaning. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.4 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Data versus Information KEYWORDS: Bloom's: Knowledge 4. When data are entered into a form and saved, they are placed in the underlying database as knowledge. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.4 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 2 NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science TOPICS: Data versus Information KEYWORDS: Bloom's: Comprehension 5. Data constitute the building blocks of information. a. True b. False ANSWER: True POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.4 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Data versus Information KEYWORDS: Bloom's: Knowledge 6. Metadata describe the data characteristics and the set of relationships that links the data found within the database. a. True b. False ANSWER: True POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 7. The only way to access the data in a database is through the DBMS. a. True b. False ANSWER: True POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science TOPICS: Introducing the Database KEYWORDS: Bloom's: Comprehension 8. Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests. a. True Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 3 b. False ANSWER: False POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Comprehension 9. The DBMS reveals much of the database’s internal complexity to the application programs and users. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science TOPICS: Introducing the Database KEYWORDS: Bloom's: Comprehension 10. One disadvantage of the DBMS is that it increases the risk of data security breaches. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.7 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducting the Database KEYWORDS: Bloom's: Knowledge 11. An operational database is sometimes referred to as an enterprise database. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.9 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 4 TOPICS: Data versus Information KEYWORDS: Bloom's: Knowledge 12. A data warehouse can store data derived from many sources. a. True b. False ANSWER: True POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.9 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom’s: Knowledge 13. The same data might be simultaneously structured and unstructured depending on the intended processing. a. True b. False ANSWER: True POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.9 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science TOPICS: Introducing the Database KEYWORDS: Bloom’s: Comprehension 14. Corporations use only structured data. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.10 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science TOPICS: Introducing the Database KEYWORDS: Bloom's: Comprehension 15. Field refers to a collection of related records. a. True b. False ANSWER: False Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 5 POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.15 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -5 - LO1-5 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Evolution of File System Data Processing KEYWORDS: Bloom’s: Knowledge 16. Structural dependence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.21 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -6 - LO1-6 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Problems with File System Data Processing KEYWORDS: Bloom's: Comprehension 17. Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 19 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -6 - LO1-6 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Problems with File System Data Processing KEYWORDS: Bloom's: Knowledge 18. One disadvantage of a database system over previous data management approaches is increased costs. a. True b. False ANSWER: True POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.28 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -7 - LO1-7 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Database System Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 6 KEYWORDS: Bloom's: Knowledge 19. An advantage of database systems is that you needn't perform frequent updates and apply latest patches. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.28 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -7 - LO1-7 NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science TOPICS: Database System KEYWORDS: Bloom's: Comprehension 20. One advantage of a database system over previous data management approaches is that the database system is considerably less complex. a. True b. False ANSWER: False POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p. 28 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -7 - LO1-7 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Database System KEYWORDS: Bloom's: Comprehension 21. _____ is the result of revealing the meaning of raw facts. a. End-user data b. An encoded sample c. An encrypted bit d. Information ANSWER: d POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 4 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Data versus Information KEYWORDS: Bloom's: Knowledge 22. _____ is the body of information and facts about a specific subject. a. Validation b. A format c. Knowledge d. A database ANSWER: c POINTS: 1 Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 7 DIFFICULTY: Easy REFERENCES: REF: p.5 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Data versus Information KEYWORDS: Bloom's: Knowledge 23. Accurate, relevant, and timely information is the key to ____. a. data management b. good decision making c. knowledge d. understanding ANSWER: b POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p.5 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -2 - LO1-2 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Data versus Information KEYWORDS: Bloom's: Comprehension 24. End-user data is _____. a. knowledge about the end users b. raw facts of interest to the end user c. information about a specific subject d. accurate, relevant and timely information ANSWER: b POINTS: 1 DIFFICULTY: Easy REFERENCES: REG: p. 6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 25. _____ provide a description of the data characteristics and the set of relationships that link the data found within the database. a. Queries b. End-user data c. Metadata d. Schemas ANSWER: c POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 26. _____ serve as the intermediary between the user and the database. Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 8 a. DBMSs b. Metadata c. End-user data d. Programming languages ANSWER: a POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 27. The database structure in a DBMS is stored as a _____. a. single file b. collection of files c. set of key/value pairs d. collection of queries ANSWER: b POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 28. A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. a. query b. operating system c. database management system d. application ANSWER: d POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 6 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 29. _____ exists when different versions of the same data appear in different places. a. Data inconsistency b. Poor data security c. Structural dependence d. Conceptual dependence ANSWER: a POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 7 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 9 TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 30. The response of the DBMS to a query is the ___________ a. ad hoc query b. ad hoc response c. query result set d. integrated view of the data ANSWER: c POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 7 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 31. A(n) _____ database is used by an organization and supports many users across many departments. a. desktop b. workgroup c. enterprise d. transactional ANSWER: c POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 8 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 32. A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization. a. desktop b. workgroup c. enterprise d. transactional ANSWER: b POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p.8 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 33. A workgroup database is a(n) _____ database. a. single -user b. multiuser c. desktop d. distributed ANSWER: b POINTS: 1 Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 10 DIFFICULTY: Easy REFERENCES: REF: p. 8 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 34. A desktop database is a _____ database. a. single -user b. multiuser c. workgroup d. distributed ANSWER: a POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 8 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 35. Data warehouse contains historical data obtained from the _____. a. operational databases b. desktop database c. enterprise databases d. workgroup databases ANSWER: a POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 9 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 36. _____ data exist in the format in which they were collected. a. Structured b. Semistructured c. Unstructured d. Historical ANSWER: c POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 9 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 37. _____ data exist in a format that does not lend itself to processing that yields information. Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 11 a. Structured b. Semistructured c. Unstructured d. Historical ANSWER: c POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 9 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 38. _____ are the result of formatting disorganized data in order to facilitate storage, use and generation of information. a. Structured data b. Raw data c. Unstructured data d. Obsolete data ANSWER: a POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 9 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 39. Most data that can be encountered are best classified as _____. a. structured b. semistructured c. unstructured d. historical ANSWER: b POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 10 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 40. An XML database supports the storage and management of _____ XML data. a. structured b. multistructured c. fullystructured d. semistructured ANSWER: d POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 10 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -3 - LO1-3 NATIONAL STANDARDS: United States - BUSPROG: - Analytic Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 12 TOPICS: Introducing the Database KEYWORDS: Bloom's: Knowledge 41. The organization of data within folders in a manual file system is determined by _______. a. its date of creation b. its expected use c. the title of the documents in the folder d. the data processing specialist ANSWER: b POINTS: 1 DIFFICULTY: Moderate REFERENCES: REF: p. 14 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -5 - LO1-5 NATIONAL STANDARDS: United States - BUSPROG: Analytic - BUSPROG: Analytic skills: Statistics and Management Science TOPICS: Evolution of File System Data Processing KEYWORDS: Bloom's: Comprehension 42. A _____ is a logically connected set of one or more fields that describes a person, place, or thing. a. database b. column c. record d. file ANSWER: c POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 15 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -5 - LO1-5 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Evolution of File System Data Processing KEYWORDS: Bloom's: Knowledge 43. A _____ is a collection of related records. a. schema b. field c. column d. file ANSWER: d POINTS: 1 DIFFICULTY: Easy REFERENCES: REF: p. 15 LEARNING OBJECTIVES: DATA.CORO.15.LO1 -5 - LO1-5 NATIONAL STANDARDS: United States - BUSPROG: Analytic TOPICS: Evolution of File System Data Processing KEYWORDS: Bloom's: Knowledge 44. A _____ is a character or group of characters that has a specific meaning. a. database b. field c. record d. file ANSWER: b POINTS: 1