Question $2[11]$

In DBMS$,$ locking methods are one of the most common techniques used in concurrency

control because they facilitate the isolation of data items used in concurrently executing

transactions.

$2\mathrm{.}1$ What is concurrency control? $2$

$2\mathrm{.}2$ A deadlock is a condition where two or more transactions wait indefinitely for

the other to release the lock on a previously locked data item.

Give and briefly describe three ways in which you can control deadlocks in a

DBMS$.$

$9$