Chapter 3 - Slides

Question 1

_______, such as Microsoft Access, are usually stored on a user’s
desktop computer system or a client computer

Answer 1

Personal database management systems

Question 2

personal database packages are developed primarily for _____

Answer 2

single-user applications.

Question 3

When such a package is used for a multi-user or a
shared access environment, the database applications
and the data are stored on a _____

Answer 3

server

Question 4

A ____ is a computer that accepts and services
requests from other computers, such as client
computers.

Answer 4

server

Question 5

A server’s ____ could include the server’s hard-disk drive space, application programs
on a server’s hard drive, data stored on the server’s
drive, or printers.

Answer 5

resources

Question 6

A ___ is an infrastructure of hardware and

software that enables computers to communicate with each other.

Answer 6

network

Question 7

True or false? In a network environment with a personal DBMS, the client computer must load the entire database
application along with the client database application
in its memory.

Answer 7

True

Question 8

If the client requires a small piece of data from the

server’s large database, the server has to:

Answer 8

transmit the entire database to the client over the network.

Question 9

The personal database system assumes that no two
transactions will happen at the same time on one
table, which is known as ____

Answer 9

optimistic locking.

Question 10

True or false? The client computer runs the entire DBMS

Answer 10

False, the client computer does not run the entire
DBMS, only the client application that requests
data from the server