Question
In two-phase locking, a transaction releases its locks:
Solution
Two-phase locking enforces a growing phase (acquire) and shrinking phase (release) for serializability.
More IT DBMS Questions
- Bitmap indexes are most efficient when:
- Which SQL statement is used to remove all rows from a table without logging individual row deletions?
- In the context of debugging an Object-Oriented program, what does "stepping over" a method call typically do in a debugger?Â
- What is a primary key in a relational database?
- Which deadlock prevention scheme allows older transactions to preempt younger ones?
- Â What is the primary purpose of a "Trigger" in a database?
- In relational algebra, the operation that combines tuples from two relations using common attribute values is:
- If every non-key attribute is functionally dependent on the primary key, the relation will be in
- In indexing, which tree is most commonly used for disk-based indexing because it minimizes disk seeks and keeps nodes dense?
- Given the following Python-like code snippet:   ```python   class Counter:     def __init__(self):       self.count = 0     def in...
