Difference between blockings and dead locks.

Question

Accepted Answer

Blocking occurs when one transaction holds a lock on a resource that another transaction needs, while a deadlock occurs when two or more transactions are waiting for each other to release locks.

Blocking occurs when a transaction is waiting for a resource that is locked by another transaction.
Deadlock occurs when two or more transactions are waiting for each other to release locks.
Blocking can be resolved by allowing the first transaction to complete and release the lock.
Deadlocks can be resolved by killing one of the transactions or by rolling back one of the transactions.
Blocking is a common occurrence in databases, while deadlocks are less common but more serious.
Example of blocking: Transaction A locks a table, Transaction B tries to lock the same table and is blocked until Transaction A releases the lock.
Example of deadlock: Transaction A locks Table 1 and waits for Table 2, while Transaction B locks Table 2 and waits for Table 1, resulting in a deadlock.

Difference between blockings and dead locks.

Top TCS IT Analyst Team Lead interview questions & answers

Top HR questions asked in TCS IT Analyst Team Lead