View previous topic :: View next topic
|
Author |
Message |
CIS777 Currently Banned New User
Joined: 16 Sep 2005 Posts: 6
|
|
|
|
Which of the following statements about lock compatibility are true?
A. USER1 can hold an IS lock on a page at the same time USER2 holds an IX lock on the same page.
B. USER1 can hold a U lock on a page at the same time USER2 holds an S lock on the same page.
C. USER1 can hold an IX lock on a page at the same time USER2 holds a U lock on the same page.
D. USER1 and USER2 can each hold an IX lock on the same page at the same time.
E. USER1 and USER2 can each hold a U lock on the same page at the same time. |
|
Back to top |
|
|
ikumar
New User
Joined: 02 Aug 2005 Posts: 81
|
|
|
|
Option B is correct, not sure about others |
|
Back to top |
|
|
anadhamohan
New User
Joined: 27 Sep 2005 Posts: 25 Location: india
|
|
|
|
Options E is correct, any number of users can have U lock on a page, its otherwise said as Read-only lock.
Option B is also correct, when a user is having IS lock then it's shared for other users also, but when the other user make any updations to the row contained in that page then it gets IX lock so no one can able to access that page. |
|
Back to top |
|
|
|