What is Concurrency

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\lang1033\f0\fs22\par
\pard\li720 Concurrency is allowing simultaneous access of same data by different users. Locks useful for accessing the database are\par
a) Exclusive \par
The exclusive lock is useful for locking the row when an insert, update or delete is being done. This lock should not be applied when we do only select from the row.\par
b) Share lock\par
We can do the table as Share_Lock as many share_locks can be put on the same resource.\par
\pard\sa200\sl276\slmult1\lang9\f1\par
}