Test Bank for Database Concepts, 9th Edition

Chapter 1 Getting Started 1) Regarding Big Data, what does the term NoSQL really mean? A) No SQL used B) NortonOS Query Language C) Notational Query Language D) Non-Blocking Query Language E) Nonrelational Database Answer: E Diff: 2 Page Ref: 29 AACSB: Information Technology Chapter Obj: Introduce Big Data and cloud computing Classification: Concept 2) What is the name of Microsoft's cloud services? Answer: Azure Diff: 2 Page Ref: 31 AACSB: Information Technology Chapter Obj: Introduce Big Data and cloud computing Classification: Concept 3) What role does the Web browser play in a Web database application? A) Hardware support B) Microchip accelerator C) Web user interface D) Back-end Database Management System E) Bug-reporting System Answer: C Diff: 1 Page Ref: 28 AACSB: Information Technology Chapter Obj: Introduce Web database applications Classification: Concept 4) For efficiency purposes, data analysis should be done on the production database. Answer: FALSE Diff: 2 Page Ref: 29 AACSB: Information Technology Chapter Obj: Introduce data warehouses and business intelligence (BI) systems Classification: Concept 5) Although users use database systems, they are not considered part of a database system. Answer: FALSE Diff: 1 Page Ref: 18 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept 3 6) A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS). Answer: FALSE Diff: 2 Page Ref: 18 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept 7) Which of the following is not a basic component of a database system? A) Database B) User C) ERD D) DBMS E) Database applications Answer: C Diff: 2 Page Ref: 18 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept 8) A relational database is ________. A) a self-describing collection of related tables B) a collection of forms and reports that support a given purpose C) a library of queries and data files for querying D) a set of applications and the data sets for those applications E) a set of metadata Answer: A Diff: 2 Page Ref: 18 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept 9) The component of a database that makes it self-describing is the ________. A) related tables B) applications C) library D) data set E) metadata Answer: E Diff: 2 Page Ref: 19 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept 4 10) Which of the following would not be an example of database metadata? A) Names of tables in a database B) Properties of tables in a database C) Names of columns in a database and their associated tables D) Properties of columns E) Queries against records in the database tables Answer: E Diff: 2 Page Ref: 19 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept 11) In relational databases, query requests use a language called ________. Answer: Structured Query Language (SQL); Structured Query Language; SQL Diff: 1 Page Ref: 16-17 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept 12) Briefly describe the four components of a database system. Answer: The components of a database system are: (1) the users, (2) the application programs, (3) the DBMS, and (4) the database. The users are the people that will employ the system to input new data, modify existing data, and delete data in order to perform their jobs. The application programs are computer programs that act as intermediaries between the users and the DBMS. The application programs produce forms, reports, and queries; they also translate user actions into data management requests for the DBMS. The DBMS manipulates the database. It receives data management requests from the computer applications and translates them into read and write commands for the database. The database contains the actual user data that the users need to perform their jobs. Diff: 2 Page Ref: 18-21 AACSB: Information Technology Chapter Obj: Know the components of a database system Classification: Concept