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
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How to concatenate two binary strings together?
how would you improve etl (extract, transform, load) throughput?
How to create a new login name in ms sql server?
Can you explain what are various ways to enhance the ssrs report?
What is ssl in sql server?
What is report snapshot?
What are different types of table joins?
What languages bi uses to achieve the goal?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to transfer a table from one schema to another?
What are statistics?
What is query processing?
What are the parts of a function?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration