Database Concepts, 8e (Kroenke)
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) Non-Relational Database
2) What is the name of Microsoft’s cloud services?
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
4) For efficiency purposes, data analysis should be done on the production database.
5) Although users use database systems, they are not considered part of a database system.
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).
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
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
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
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
11) In relational databases, query requests use a language called ________.
12) Briefly describe the four components of a database system.
13) What components are included in a database?
14) What is “metadata,” and how does it relate to the definition of a database?
15) A relational database can be defined as a self-describing collection of related tables.
16) A database is self-describing because the user maintains a record of the database structure
outside the database itself.
17) Metadata is the user data stored in the database.
18) Data that the database keeps about its own structure is called ________.
19) What is a surrogate key and how does Microsoft Access 2016 create surrogate keys?
20) Most organizations create and use their own database management system (DBMS)
products.
21) The DBMS is used to create the database itself.
22) Referential integrity constraints must be enforced by the application program.
23) Application programs are responsible for creating, maintaining, and supporting database
backup and recovery systems.
24) 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
25) 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
26) Microsoft SQL Server is an example of a ________.
A) database
B) database management system
C) data manipulation system
D) table
E) list manager
27) Microsoft Access is a personal database system, and a personal database system is
characterized by ________.
A) the DBMS removing the metadata from the database
B) the DBMS product taking the role of the DBMS and the database application generator
C) the database being stored inside the DBMS
D) the DBMS product being limited to a maximum of ten tables in any given database
E) the DBMS not supporting indexes
28) The Microsoft Access application generator is not responsible for ________.
A) creating forms
B) creating reports
C) creating queries
D) creating tables
E) storing queries
29) The purpose of the ________ in a database system is to receive requests from applications
and to translate those requests into reads and writes on the database files.
30) ________ constraints are rules that the DBMS enforces to ensure that data values in one
table have corresponding values in another related table.
31) The DBMS controls ________ by ensuring that one user’s work does not inappropriately
interfere with another user’s work.
32) Microsoft Access is a(n) ________, which combines a DBMS and an application generator.
33) The Microsoft Access application generator adds the ability to create and store ________,
________, and ________.
34) Microsoft Access 2016 database files are stored using the ________ file extension.
35) By default, Microsoft Access 2016 saves data files in the ________ file format.
36) Microsoft Access 2016 generates surrogate key values when the ________ data type is used.
37) Briefly describe the function of the DBMS in a database system.
38) What are “referential integrity constraints”? Give an example.
39) Briefly describe the function of an application program in a database system.
40) What are the advantages and disadvantages of personal DBMS products hiding the
complexity of database systems?
41) Microsoft Access is considered a “personal database” product. What is a personal database?
42) What Microsoft Access file format is used by default in Microsoft Access 2016?
43) A relational database stores data in the form of lists.
44) Usually, a database table containing both rows and columns is designed to store data for
exactly two themes.
45) By separating data into tables containing data on only one theme each, making changes to
the data is simplified.
46) SQL stands for Structural Question Language.
47) Relational database tables are commonly combined, queried, and processed using Structured
Query Language (SQL).
48) Today almost every commercial database is based on ________.
A) lists
B) the hierarchical model
C) the linked-list model
D) the relational model
E) the object-oriented model
49) A relational database stores data in the form of ________.
A) lists
B) forms
C) columns
D) tables
E) spreadsheets
50) SQL stands for ________.
A) Standard Query Language
B) Structural Question Language
C) Structured Query Language
D) Standard Question Language
E) Structured Question Language
51) The statement
SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of ________.
A) QBE
B) SQL
C) QLE
D) C++
E) Java
52) A relational database stores data in the form of ________.
53) It is almost always best to design a table in a database so that it contains data on ________
theme.
54) The DBMS receives data update requests from the application program.
55) In the general division of labor between database applications and the DBMS, the processing
of forms is considered a DBMS task.
56) In the general division of labor between database applications and the DBMS, the application
program determines which tables need to be modified.
57) In the general division of labor between database applications and the DBMS, the application
program formats the results of a query into a report.
58) Personal DBMS products, such as Microsoft Access, create a clear distinction between the
DBMS and the database application.
59) There is no reason for serious database developers to learn many aspects of database
processing technology because DBMS products like Microsoft Access hide these aspects.
60) Microsoft Access 2016 is a personal database that combines a DBMS with an application
generator.
61) The Microsoft Access 2016 application generator provides the ability to create and store
forms, reports, and queries.
62) Microsoft Access 2016 databases are stored using the file extension .accdb.
63) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for
database files.
64) Microsoft Access 2016 uses the AutoNumber data type to create surrogate keys.
65) Which of the following is a function of the database application in a database system?
A) Create and transmit queries
B) Update database data
C) Maintain database structures
D) Create tables
E) Backup and restore data
66) Which of the following is not a function of the database application in a database system?
A) Execute application logic
B) Control concurrency
C) Create and process forms
D) Create and transmit queries
E) Create and process reports
67) Microsoft Access 2013 database files are stored using the file extension ________.
A) .adb
B) .asp
C) .accdb
D) .mdb
E) .sql
68) The default file format for Microsoft Access 2016 database files is the ________.
A) Access 2007 format
B) Access 2003 format
C) Access XP format
D) SQL Server format
E) XBD format
69) The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need
for a ________.
A) foreign key
B) primary key
C) surrogate key
D) spare key
E) secondary key
70) A(n) ________ is a set of one or more computer programs that serves as an intermediary
between the user and the DBMS.
71) In a database system, the ________ creates and processes forms.
72) Web 2.0 web sites were popular due to their static, unchanging content.
73) Theoretically, databases could store instances in columns and characteristics in rows, instead
of the other way around.
74) A possible problem with keeping data in lists is that if you delete a row of data from a list,
you may also delete some data items that you want to keep.
75) 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.
76) 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.
78) Which of the following problems associated with storing data in a list is avoided by storing
data in a relational database?
A) CPU processing inefficiencies
B) Lack of necessary bandwidth
C) Running out of memory storage
D) Duplication of data items
E) Incorrect data typing
79) What problems with storing data on two themes in a list are addressed by database
technology?
80) The purpose of a database is to help people keep track of things.
81) A database may be used to help people with all of the following except ________.
A) track which student is assigned to a particular advisor
B) know the current inventory levels of products their company sells
C) check on the estimated arrival time of an incoming flight at an airport
D) look up their checking account balance over the Internet
E) debug existing program code
82) The purpose of a database is to help people ________.