Which of the following is/are true in case of tree locking (the tree protocol)?
A. It ensures shorter waiting times.
B. It ensures freedom from deadlock.
C. A transaction can lock data items earlier.
D. It does not ensure a greater amount of concurrency.
Choose the correct answer from the options given below:
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. A and B Only
Explanation
The tree protocol is deadlock-free and allows early unlocking, which gives shorter waits and more concurrency. Its drawback is that transactions may lock items they don't need.More Database Management Systems questions
- Which of the following statements is/are FALSE? A. A user can assign privileges to any user on any relation. B. A user can assign privilege…
- The techniques used to handle the phantom problem are: A. Time stamping B. Index locking C. Predicate locking D. Execution indexing Choose…
- What will be the order of the typical steps when processing a high-level query? A. Query optimizer B. Runtime database processor C. Scannin…
- Which SQL query retrieves the total number of orders placed by a specific customer?
- Based on the passage, which of the following statements is true?
- Which of the following tables is most likely to have a foreign key referencing another table?