Exam 9: Managing Multiuser Databases

Resource locking is one remedy to the lost update problem.

All commercial DBMS products use some version of "username and password" as part of their security features.

Both rollforward and rollback require the use of a log of transaction results.

Locks that are placed assuming that a conflict will occur are called:

The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

Transaction level consistency means that all rows impacted by any actions in a transaction are protected from change during the entire transaction.

The size of a lock is referred to as the lock granularity.

In two-phase locking,all locks are released during the contracting phase.

Which type of data repository is composed of metadata that is created automatically as the system components are created?

Database administration is more important but less difficult in multiuser database systems than in single-user database systems.

Explain the process of using optimistic locking.

A static cursor processes a snapshot of the relation that was taken when the cursor was opened.

Copies of each database record or page before being changed by a transaction that are saved for use in database recovery are called before images.

In general,optimistic locking is the preferred technique for Internet databases.

Ensuring that all rows impacted by the actions of a transaction are protected from changes until the entire transaction is completed is called:

In general,the overall responsibility of the DBA is to facilitate the development and use of the database system.

A durable transaction is one for which all committed changes are permanent.

Rollforward and reprocessing are two different names for the same technique.

Which of the following would a DBA do in managing the DBMS?

When a transaction reads a row that has been changed,but the change has not been committed,this is known as a ________.