Question:
Which of the following protocol is the lock based mechanism for concurrency control?
Which of the following protocol is the lock based mechanism for concurrency control?
Show Hint
Two-Phase Locking is the standard method for ensuring serializability in databases.
Updated On: May 26, 2025
- Two Phase lock protocol
- Timestamp based protocol
- Validation based protocol
- Time lock protocol
Hide Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
Lock-based concurrency control uses locks to manage access to the database.
Two-Phase Locking (2PL) protocol ensures serializability by dividing the transaction into two phases: growing (acquiring locks) and shrinking (releasing locks).
Two-Phase Locking (2PL) protocol ensures serializability by dividing the transaction into two phases: growing (acquiring locks) and shrinking (releasing locks).
Was this answer helpful?
0
0
Top Questions on Database Concepts
- Given the relation: \[ R = \{A, B, C, D, E, F, G\} \] With the following functional dependencies (FDs): \[ A \rightarrow BCEF, \quad E \rightarrow DG, \quad BC \rightarrow A \] Which of the following statements is correct?
- GATE DA - 2025
- Data Science and Artificial Intelligence
- Database Concepts
- Consider the following database schema: \[ \text{Person (aadhar CHAR(12) PK, name VARCHAR(32))} \] \[ \text{Customer (name VARCHAR(32), email VARCHAR(32) PK, phone CHAR, aadhar CHAR(12) FK(aadhar))} \] Which of the following statements is/are correct?
- GATE DA - 2025
- Data Science and Artificial Intelligence
- Database Concepts
- The Debentures that are payable on the expiry of the specific period either in lumpsum or in instalments during life time of the company are called:
- CUET (UG) - 2025
- Accountancy
- Database Concepts
- Identify the other name by which Liquid ratio is known:
- CUET (UG) - 2025
- Accountancy
- Database Concepts
Match List I with List II:
Choose the correct answer from the options given below:- CUET (UG) - 2025
- Accountancy
- Database Concepts
View More Questions
Questions Asked in TS PGECET exam
- Which of the following correctly describes the TCP/IP model?
- TS PGECET - 2025
- Computer Networks
- In which year was the Earth Summit (Rio Conference) held?
- TS PGECET - 2025
- Environmental pollution
- A bag contains 3 red and 2 blue balls. Two balls are drawn without replacement. What is the probability that both are red?
- TS PGECET - 2025
- Probability
- Which of the following techniques is primarily used for the synthesis of carbon nanotubes?
- TS PGECET - 2025
- Strength of Materials
- Which of the following materials exhibits superparamagnetism at the nanoscale?
- TS PGECET - 2025
- Strength of Materials
View More Questions