Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Shared locks are not compatible with exclusive locks. True/False?
on 9/27/2013 | Category:
Sql Server Interview questions
| Views: 1379 |
Select from following answers:
While an exclusive (X) lock is held, no other transaction can acquire a lock of any kind (shared, update, or exclusive) on that resource until the exclusive (X) lock is released. Alternatively, if a shared (S) lock has been applied to a resource, other transactions can also acquire a shared lock or an update (U) lock on that item even if the first transaction has not completed. However, other transactions cannot acquire an exclusive lock until the shared lock has been released.
Show Correct Answer
Many Interviews |
< Previous :
BEGIN TRANSACTION INSERT INTO DemoTable VALUES( ...
Next > :
What is the result of the below query: SELECT PATI ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
What is the result of the below query: SELECT PATINDEX('%NET%' ...
What is the result of the below query: SELECT SUBSTRING('DOTNETFUN ...
By default, which type of index is created for a primary key?
Which of the following is true?
Which of the following are T-SQL ranking functions that can be used fo ...
Which of the following is correct about DELETE and TRUNCATE statements ...
Which of the following is true about Implicit Transactions?
Which of the following is NOT used for getting auto-incremented value ...
Latest Interview Questions
You have created an assembly that utilizes unmanaged code to access ex ...
You have an application that is used by international clients. All cli ...
Your application uses two threads, named threadOne and threadTwo. You ...
You need to create a method to clear a Queue named q.
You need to write a multicast delegate that accepts a DateTime argumen ...
Differentiate between a page theme and a global theme?
ASP .Net Page class, in which of them would you attach an event handle ...
What is right way to define the routes.MapRoute() method in MVC?