What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / cheti
Deadlock is a sitiuation wher a group of processes are
permanetly blocked as result of each process having
acquired a subset of the resources needed for its
completion and waiting for release of remaining resources
held by others in the same group.Thus,making it impossible
for any of the process to proceed.
Livelock:- Sorry
Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
Are semicolons required at the end of sql statements in sql server 2005?
What is the contrast between sql and pl/sql?
How can sql server instances be hidden? : sql server security
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Explain the different types of joins?
What is schemabinding a view?
What happens if null values are involved in datetime operations?
What is merge?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Explain identity in sql server?
Can two tables share a primary key?
Define clusters?
what is normalization? : Sql server database administration
What are the dmvs?
What guidelines should be followed to help minimize deadlocks?