Database Processing, 15e (Kroenke)
Chapter 1: Introduction
1) The purpose of a database is to help people keep track of things.
2) In a database, each table stores data about a different type of thing.
3) Like a spreadsheet, a database table has rows and columns.
4) In every database, not just the databases discussed in this book, table names are capitalized.
5) A database shows data in tables as well as the relationships among the rows in those tables.
6) Data is recorded facts and figures; information is knowledge derived from data.
2
7) Databases record data in such a way that they can produce information.
8) Enterprise Resource Planning (ERP) is an example of a data mining application.
9) Databases are a key component of e-commerce order entry, billing, shipping, and customer
support.
10) The largest databases in e-commerce are the order entry databases.
11) E-commerce companies use Web activity databases to determine which items on a Web page
are popular and successful.
12) A surrogate key is a key typically used in place of a foreign key.
13) A database system is typically defined as its four components: users, database applications,
the DBMS and the databases.
14) Databases based on the CODASYL standard are based on the network data model.
15) Applications are computer programs used directly by users.
16) Applications usually write data directly to the database.
17) Sequenced Query Language (SQL) is an internationally recognized standard language that is
understood by all commercial database management system products.
18) In database systems, indexes are held in the database.
19) A database management system (DBMS) creates, processes and administers databases.
20) The database management system (DBMS) is responsible for inserting, modifying, reading,
and deleting data.
21) Knowledge workers are programmers who write applications that process the database.
22) The database management system (DBMS) is responsible for enforcing referential integrity
constraints.
23) Referential integrity constraints are rules about what data values are allowed in certain
columns.
24) A database is a self-describing collection of non-integrated tables.
25) Integrated tables store both data and the relationships among the data.
26) Microsoft Access is just a DBMS.
27) Microsoft Access is a low-end product intended for individuals and small workgroups.
28) The current DBMS engine in Microsoft Access is called ADE.
29) In Microsoft Access, you can use ODBC to connect to SQL Server in place of the ADE
database engine.
30) In an enterprise-class database system, a database application interacts with the DBMS.
31) In an enterprise-class database system, a database application accesses the database data.
32) In an enterprise-class database system, business users interact directly with the DBMS,
which directly accesses the database data.
33) All database applications send and receive database data by sending SQL statements to the
DBMS.
34) According to the text, IBM’s DB2 is the DBMS with the most power and features.
35) According to the text, Oracle Corporation’s Oracle Database is considered the most difficult
DBMS to use.
Classification: Concept
36) According to the text, Microsoft’s SQL Server is the easiest DBMS to use.
37) According to the text, Microsoft Access has the least power and features of any major
DBMS.
38) A database is called self-describing because it reduces data duplication.
39) The description of a database’s structure that is stored within the database itself is called the
metadata.
40) Indexes are data structures that speed database searches.
41) Database design is important, and fortunately it is simple to do.
42) A database design may be part of a new systems development project.
43) A database design is rarely a redesign of an existing database.
44) Each row in a database table is also known as a record.
45) Data Language/I (DL/I) structured data relationships as a tree structure.
46) The CODASYL DBTG model structured data relationships as a tree structure.
47) The relational model was first proposed in 1970 by E. F. Codd at IBM.
48) The 1977 edition of this text contained a chapter on the relational model, and that chapter
was reviewed by E. F. Codd.
49) dBase was the first PC-based DBMS to implement true relational algebra on a PC.
50) Paradox is the only major survivor of the “bloodbath of PC DBMS products.”
51) Business organizations have resisted adopting object-oriented database systems because the
cost of purchasing OODBMS packages is prohibitively high.
52) Bill Gates has said that “XML is the lingua-franca of the Internet Age.”
53) XML Web services allow database processing to be shared across the Internet.
54) The NoSQL movement could also be called a NoRelational movement.
55) Twitter and Facebook use NoSQL databases.
56) The purpose of a database is to ________.
A) help people keep track of things
B) store data in tables
C) create tables of rows and columns
D) maintain data on different things in different tables
57) A database stores ________.
A) data
B) relationships
C) applications
D) Both A and B are correct
58) Which of the following statements is true about Web 2.0?
A) It requires the Android Operating System.
B) It allows users to add content to Web sites.
C) Twitter and Facebook are examples of Web 2.0 sites.
D) Both B and C are correct
11
59) A sales contact manager used by a salesperson is an example of a(n) ________.
A) single-user database application
B) multiuser database application
C) e-commerce database application
D) data mining application
60) A Customer Resource Management (CRM) system is an example of a(n) ________.
A) single-user database application
B) multiuser database application
C) e-commerce database application
D) digital dashboard
61) An online drugstore such as Drugstore.com is an example of a(n) ________.
A) single-user database application
B) multiuser database application
C) e-commerce database application
D) enterprise resource planning system
62) The industry standard supported by all major DBMSs that allows tables to be joined together
is called ________.
A) Sequential Query Language (SQL)
B) Structured Question Language (SQL)
C) Structured Query Language (SQL)
D) Standard Question Language (SQL)
63) A program whose job is to create, process and administer databases is called a ________.
A) database modeling system