Transaction

Transactions and locks, different types of locks like binary locking, two phase locking, strict two-phase locking, shared and an exclusive lock is illustrated by taking transactions example. Different types of conflicts in transactions like WW RR RW conflicts are explained. It is very easy to understand different types of locks when we understand and remember the rules of locking. shared and exclusive lock is the basic to understand the next  types of locks.

GATE (Graduate Aptitude Test in Engineering) 2020 & 2021 complete preparation with best educators. Know about the detailed syllabus, best books, exam pattern and dates, previous year question papers a

GATE - Iconic Pro

English

Transactions and Locks in DBMS

Programming Languages

Database Management System

CS & IT

GATE - CSIT, DSAI & Interview Preparation

GATE, ESE and IIT-JAM

This lesson deals with the definition of transaction and lock properties of transaction in DBMS.

Transaction and Locks: Introduction

Binary Lock

Shared and Exclusive Lock

Two Phase Lock (2PL)

Example of Two Phase Locking and Occurence of Dead Lock

Strict Two Phase Locking

Dead Lock

Dead Lock Detection and Dead Lock Prevention

WW conflicts, RR conflicts, and RW conflicts

Please Login To Continue

Transaction and Locks: Introduction

Srija Kalyanam

Transactions and Locks in DBMS

1

2

3

4

5

6

7

8

9

Crack GATE - Iconic Pro with Unacademy

Get subscription and access unlimited live and recorded courses from India's best educators

Structured syllabus

Daily live classes

Ask doubts

Tests & practice

Similar Plus Courses

Complete Course on Disaster Management - UPSC CSE - GS

Sumit Konde

Phoenix All Star Fastrack Course on Physics for NEET 2025

Anubhav Shrivastava

CSAT Orientation Class for 2025

Madhukar Kotawe

Complete Course on Disaster Management

Sudarshan Gurjar