What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / sanjeev kumar
Dead Lock:
Deak Lock is a situation when two or more process
continuous working and each having a lock on a particular
record but at a time only one can lock a particular and the
other one will go to dead lock
Live Lock:
A human example of live lock would be two people who meet
face-to-face in a corridor and each moves aside to let the
other pass, but they end up moving from side to side without
making any progress because they always move the same way at
the same time and never cross each other. This is good
example of live lock.
Is This Answer Correct ? | 29 Yes | 22 No |
Post New Answer View All Answers
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What command is used to delete a table from the database in the sql server and how?
How do use Having,Group by,Group function in SQL?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How can you set the threshold at which sql server will generate keysets asynchronously?
What is the datatype of rowid?
What is the use of group by clause?
How do I find the default sql server instance?
What xml support does the sql server extend?
What is a cache in ssrs?
Do you know what are various aggregate functions that are available?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is xdr?
‘Order by’ is not allowed in a view how can you sort information from a view?
Explain how to integrate the ssrs reports in application?