In Microsoft SQL, which kind of transaction is allowed to occur through a shared lock?
-
Delete
-
Update
-
Read
-
Insert
EXPLANATION
Shared (S) locks: It permits a transaction to read a row.
If transaction of one session has got this lock no transaction of other session can apply X lock on the same row. We can also say that no transaction of some other session can update that row.
0 comments:
Post a Comment