What are blockings ? What are deadlocks and difference to blockings ?

Question

Accepted Answer

Blockings occur when one transaction holds a lock on a resource, preventing other transactions from accessing it. Deadlocks are a specific type of blocking where two or more transactions are waiting for each other to release resources.

Blockings happen when one transaction holds a lock on a resource and other transactions are blocked from accessing it.
Deadlocks occur when two or more transactions are waiting for each other to release resources, resulting in a deadlock situation.
Blockings can be resolved by allowing the blocking transaction to complete or by killing the blocking process.
Deadlocks require intervention to resolve, such as killing one or more transactions involved in the deadlock or using deadlock detection and resolution mechanisms.
Blockings are less severe than deadlocks as they can be resolved without causing data inconsistencies.

Accepted Answer

A: Block: If one process is waiting because of other process it will call it as blocking.

Deadlock: If few transactions blocked by each other not able to continue further that situation is called deadlock.

What are blockings ? What are deadlocks and difference to blockings ?

Top DXC Technology MS SQL DBA interview questions & answers

Popular interview questions of MS SQL DBA

Top HR questions asked in DXC Technology MS SQL DBA