IT Questions and Answers :)

Thursday, November 7, 2019

In Microsoft SQL, which kind of transaction is allowed to occur through a shared lock?

In Microsoft SQL, which kind of transaction is allowed to occur through a shared lock?

  • Delete
  • Update
  • Read
  • Insert 
In Microsoft SQL, which kind of transaction is allowed to occur through a shared lock?

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.

Share:

0 comments:

Post a Comment

Popular Posts