Question

SQL based: Session 1 gets a share lock on a resource. Which statement best describes options for session 2 that is running in parallel with session 1?

a. session 2 can get a shared lock, but it cannot get an exclusive lock on the resource

b. session can get any lock, shared or exclusive on the same resource

c. session 2 cannot get a shares lock, but it can get an exclusive lock on th resource

d. session 2 cannot get any lock, shared or exclusive on any resource

Answer 1

Answer)

For the above mentioned statement the option which describes the best for session 2 is as follows:

a. session 2 can get a shared lock, but it cannot get an exclusive lock on the resource

Because an exclusive lock prevent any other session/user from reading the locked resources whereas in a shared lock it allows the other users to even read the locked resources but any modification cannot be done.

If you find the answer useful, hit the thumbs up symbol. Thanks
Hope this answer helps. :)