AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists
Classification: Concept
30) An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well.
Answer: FALSE
Diff: 1 Page Ref: 8
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists
Classification: Concept
31) An advantage of keeping data in lists is that if you add a new row of data to the list, you will never have null values occurring for any data item in the row.
Answer: FALSE
Diff: 1 Page Ref: 8
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists
Classification: Concept
32) One problem with storing duplicated data is the potential for inconsistent values.
Answer: TRUE
Diff: 2 Page Ref: 8
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists
Classification: Concept
33) The purpose of a database is to help people keep track of things.
Answer: TRUE
Diff: 1 Page Ref: 7
AACSB: Information Technology
Chapter Obj.: Understand the reasons for using a database
Classification: Concept
34) 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
35) 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
36) 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
37) 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
38) 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
39) 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
40) The creation of a database and its tables is a function of which component of the database system?
A) Users
B) Application
C) DBMS
D) Database
E) Web server
Answer: C
Diff: 2 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
41) Which of the following is a function of the DBMS in a database system?
A) Create and transmit queries
B) Control applications
C) Create and process forms
D) Perform backup and recovery
E) Process Web page requests