What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 7 Answers
- 46554 Views
- Microsoft, I also Faced
- E-Mail Answers
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
What is a unique index?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
How would you use user_constraints table in DB?
Can a function call a stored procedure in sql server?
Find columns used in stored procedure?
What is hot add cpu in sql server 2008?
What is cursors?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Explain the difference between HTTP and HTTPS in database?
How do you start single user mode in clustered installations?
What is collation?
Tell me what is the difference between locking and multi-versioning?
What is data file in computer?
What is lock escalation and what is its purpose?
