Databases Reference
In-Depth Information
ASSESS YOUR UNDERSTANDING
Go to
www.wiley.com/college/gillenson
to evaluate your knowledge of databases
and database management systems.
Measure your learning by comparing pre-test and post-test results.
Summary Questions
1.
Companies adopting the database approach to data typically use a combina-
tion of data-driven and process-driven development methods. True or False?
2.
Which of the following relate to storing and managing data structure
information?
(a)
data repository
(b)
data abstraction
(c)
data dictionary
(d)
data access
3.
In the distributed model of database implementation, all of the database
servers must use the same DBMS. True or False?
4.
Which of the following statements correctly describes a transaction?
(a)
All statements in a transaction must be completed or rolled back as a
group.
(b)
A transaction must consist of a single executable statement.
(c)
If an error occurs during processing, a transaction leaves data in an
inconsistent state.
5.
Which of the following correctly lists the words making up the abbrevia-
tion CRUD?
(a)
consistency, redundancy, utility, data store
(b)
create, read, update, delete
(c)
columns, rows, users, data
(d)
create, reply, understand, distribute
6.
Which of the following is a common hybrid database model?
(a)
object-relational
(b)
hierarchical-object
(c)
network-relational
(d)
hierarchical-network
7.
In the relational model, a relation refers to which of the following?
(a)
the association between two data tables
(b)
a foreign key definition
