Type:
Test Bank
Database Processing Resource: Fundamentals, Design, and Implementation Edition:
16th Edition
Author(s):
David M. Kroenke David J. Auer Scott L. Vandenberg Robert C. Yoder
Database Processing, 16e (Kroenke/Auer/Vandenberg) Chapter 1 Introduction 1) The purpose of a database is to help people keep track of things. Answer: TRUE Page Ref: 6 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 Page Ref: 6 AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 3) Like a spreadsheet, a database table has rows and columns. Answer: TRUE Page Ref: 6 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 Page Ref: 7 AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept 5) A database shows data in tables as well as the relationships among the rows in those tables. Answer: TRUE Page Ref: 8 AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships Classification: Concept
1 .
6) Data is recorded facts and figures; information is knowledge derived from data. Answer: TRUE Page Ref: 10 AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 7) Databases record data in such a way that they can produce information. Answer: TRUE Page Ref: 10 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 Page Ref: 11 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 Page Ref: 11 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 Page Ref: 11 AACSB: Information Technology Difficulty: Difficult LO: To survey some important and interesting database applications Classification: Concept
2 .
11) E-commerce companies use Web activity databases to determine which items on a Web page are popular and successful. Answer: TRUE Page Ref: 11 AACSB: Information Technology Difficulty: Moderate LO: To understand the importance of databases in Internet Web applications and smartphone apps Classification: Concept 12) A surrogate key is a key typically used in place of a foreign key. Answer: FALSE Page Ref: 8 AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 13) A database system is typically defined as its four components: users, database applications, the DBMS and the databases. Answer: TRUE Page Ref: 12 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 Page Ref: 30 AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept 15) Applications are computer programs used directly by users. Answer: TRUE Page Ref: 13 AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships Classification: Concept
3 .
16) Applications usually write data directly to the database. Answer: FALSE Page Ref: 13 AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships 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 Page Ref: 12 AACSB: Information Technology Difficulty: Moderate LO: To gain a general understanding of tables and relationships Classification: Concept 18) In database systems, indexes are held in the database. Answer: TRUE Page Ref: 38 AACSB: Information Technology Difficulty: Difficult LO: To define the term database and describe what is contained within the database Classification: Concept 19) A database management system (DBMS) creates, processes and administers databases. Answer: TRUE Page Ref: 38 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 Page Ref: 15 AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept
4 .
21) Big Data is often stored in non-relational databases Answer: TRUE Page Ref: 6 AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 22) The database management system (DBMS) is responsible for enforcing referential integrity constraints. Answer: TRUE Page Ref: 16 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 Page Ref: 16 AACSB: Information Technology Difficulty: Easy LO: To define the term database and describe what is contained within the database Classification: Concept 24) A database is a self-describing collection of non-integrated tables. Answer: FALSE Page Ref: 16 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 Page Ref: 16 AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept
5 .
26) Microsoft Access is just a DBMS. Answer: FALSE Page Ref: 18 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 Page Ref: 18 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 Page Ref: 19 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 Page Ref: 20 AACSB: Information Technology Difficulty: Moderate LO: To describe the components of a Microsoft Access database system and explain the functions they perform Classification: Application 30) In an enterprise-class database system, a database application interacts with the DBMS. Answer: TRUE Page Ref: 13 AACSB: Information Technology Difficulty: Moderate LO: To describe the components of an enterprise-class database system and explain the functions they perform Classification: Concept
6 .