Test Bank For, Design, Implementation and Management 13th Edition Carlos Coronel Steven morris | Complete 2023

Test Bank For Database Systems, Design, Implementation and Management 13th Edition Carlos Coronel Steven morris | Complete 2023. A data warehouse can store data derived from many sources. a. True b. False ANSWER: True DIFFICULTY: Easy REFERENCES: 1-3b Types of Databases LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making 13. Structure is based on the type of processing to be performed on the data. a. True b. False ANSWER: True DIFFICULTY: Moderate REFERENCES: 1-3b Types of Databases LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making 14. Corporations use only structured data. a. True b. False ANSWER: False DIFFICULTY: Moderate REFERENCES: 1-3b Types of Databases LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making 15. Field refers to a collection of related records. a. True b. False ANSWER: False DIFFICULTY: Easy REFERENCES: 1-5b Computerized File Systems LEARNING OBJECTIVES: 01.04 - See how modern databases evolved from file systems 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 Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 4 DIFFICULTY: Moderate REFERENCES: 1-6a Structural and Data Dependence LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management 17. One disadvantage of a database system over previous data management approaches is increased costs. a. True b. False ANSWER: True DIFFICULTY: Easy REFERENCES: 1-7c Managing the Database System: A Shift in Focus LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management 18. 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 DIFFICULTY: Easy REFERENCES: 1-6b Data Redundancy LEARNING OBJECTIVES: 01.05 - Understand flaws in file system data management 19. An advantage of database systems is that you needn't perform frequent updates and apply latest patches. a. True b. False ANSWER: False DIFFICULTY: Moderate REFERENCES: 1-7c Managing the Database System: A Shift in Focus LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system 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 DIFFICULTY: Moderate REFERENCES: 1-7c Managing the Database System: A Shift in Focus LEARNING OBJECTIVES: 01.06 - Outline the main components of the database system Multiple Choice 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 DIFFICULTY: Easy Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 5 REFERENCES: 1-2 Data versus Information LEARNING OBJECTIVES: 01.01 - Define the difference between data and information 22. _____ is the body of information and facts about a specific subject. a. Validation b. A format c. Knowledge d. A database ANSWER: c DIFFICULTY: Easy REFERENCES: 1-2 Data versus Information LEARNING OBJECTIVES: 01.01 - Define the difference between data and information 23. Accurate, relevant, and timely information is the key to ____. a. data management b. good decision making c. knowledge d. understanding ANSWER: b DIFFICULTY: Moderate REFERENCES: 1-2 Data versus Information LEARNING OBJECTIVES: 01.01 - Define the difference between data and information 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 DIFFICULTY: Easy REFERENCES: 1-3 Introducing the Database LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making 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 DIFFICULTY: Easy REFERENCES: 1-3 Introducing the Database LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making 26. _____ serve as the intermediary between the user and the database. a. DBMSs b. Metadata c. End-user data d. Programming languages ANSWER: a DIFFICULTY: Easy REFERENCES: 1-3a Role and Advantages of the DBMS LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making Chapter 01: Database Systems Copyright Cengage Learning. Powered by Cognero. Page 6 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 DIFFICULTY: Easy REFERENCES: 1-3a Role and Advantages of the DBMS LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of databases, and why they are valuable assets for decision making 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