Exam 7: Dbms Functions

In which procedure does the DBMS read the log for the problem transactions and apply the before images to undo their updates?

In updating and retrieving data, users need to know how data is physically structured on a storage medium.

If the database has been destroyed, you can use a rollback to recover the database to a valid state by undoing problem transactions.

What type of rules specify which users have what type of access to which data in the database?

You can improve the performance of the recovery program by having it first scan the log and then apply the last after image.

A user's ____________________ specify what kind of access the user has to objects in the database.

Discuss the four ways in which integrity constraints can be handled.

Which authentication method identifies users by physical characteristics such as fingerprints, voiceprints, handwritten signatures, and facial characteristics?

One guideline for writing programs for concurrent updates in a PC-based DBMS states that if an update transaction must lock more than one row in the same table, the whole table must be locked.

A(n) ____________________ is a set of steps completed by a DBMS to accomplish a single user task.