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

More Questions from Managing Multiuser Databases

• An ACID transaction is one that is atomic, consistent isolated, and durable.
• A durable transaction is one in which all committed changes are permanent.
• An exclusive lock locks the item from change but not from read.
• Database administration refers to a function that applies to the entire organization.
• Locks placed by command are implicit locks.
• The size of a lock is referred to as lock sizing.
• The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
• Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
• In optimistic locking, the assumption is made that conflict will occur.
• When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

Discussion & Comments