Type:
Test Bank
Database Processing Resource: Fundamentals, Design, and Implementation Edition:
14th Edition
Author(s):
David M. Kroenke David J. Auer
Database Processing, 14e (Kroenke) Chapter 1: Introduction 1) The purpose of a database is to help people keep track of things. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 2) In a database, each table stores data about a different type of thing. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 3) Like a database table, a spreadsheet has rows and columns. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept 4) In every database, not just the databases discussed in this book, table names are capitalized. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept 5) A database shows data in tables and the relationships among the rows in those tables. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships Classification: Concept 6) Data is recorded facts and figures; information is knowledge derived from data. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept
1 ..
7) Databases record data in such a way that they can produce information. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 8) Enterprise Resource Planning (ERP) is an example of a data mining application. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept 9) Databases are a key component of e-commerce order entry, billing, shipping and customer support. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept 10) The largest databases in e-commerce are the order entry databases. Answer: FALSE AACSB: Information Technology Difficulty: Difficult LO: To survey some important and interesting database applications Classification: Concept 11) The e-commerce companies use Web activity databases to determine which items on a Web page are popular and successful. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To understand the importance of databases in Internet Web applications and smartphone apps Classification: Concept 12) Small databases typically have simple structures. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To gain a general understanding of tables and relationships Classification: Concept
2 ..
13) A database system is typically defined as its four components: users, database applications, the DBMS and the databases. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 14) Databases based on the CODASYL standard are based on the network data model. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 15) Applications are computer programs used directly by users. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 16) Applications usually write data directly to the database. Answer: FALSE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 17) Sequenced Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept 18) In database systems, indexes are held in the database. Answer: TRUE AACSB: Information Technology Difficulty: Difficult LO: To define the term database and describe what is contained within the database Classification: Concept
3 ..
19) A database management system (DBMS) creates, processes and administers databases. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 20) The database management system (DBMS) is responsible for inserting, modifying, reading, and deleting data. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 21) The database application is responsible for concurrency control. Answer: FALSE AACSB: Information Technology Difficulty: Difficult LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 22) The database management system (DBMS) is responsible for enforcing referential integrity constraints. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 23) Referential integrity constraints are rules about what data values are allowed in certain columns. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database and describe what is contained within the database Classification: Concept
4 ..
24) A database is a self-describing collection of non-integrated tables. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To define the term database and describe what is contained within the database Classification: Concept 25) Integrated tables store both data and the relationships among the data. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To define the term database and describe what is contained within the database Classification: Concept 26) Microsoft Access is just a DBMS. Answer: FALSE AACSB: Information Technology Difficulty: Easy LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Concept 27) Microsoft Access is a low-end product intended for individuals and small workgroups. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Concept 28) The current DBMS engine in Microsoft Access is called ADE. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Concept 29) In Microsoft Access, you can use ODBC to connect to SQL Server in place of the ADE database engine. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Application 5 ..
30) In an Enterprise-class database system, a database application interacts with the DBMS. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Concept 31) In an Enterprise-class database system, a database application accesses the database data. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Application 32) In an Enterprise-class database system, business users interact directly with the DBMS, which directly accesses the database data. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Concept 33) All database applications get and put database data by sending SQL statements to the DBMS. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 34) The DBMS ranked as having the "most power and features" in the text is IBM's DB2. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept 35) The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept 6 ..