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
Difference between DELETE and TRUNCATE?
What is row_number () and partition by in sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
What are different type of Collation Sensitivity?
Please explain what is “asynchronous” communication in sql server service broker?
between cast and convert which function would you prefer and why?
How to create function without parameter in sql server?
How to add the custom code in Report?
Explain the xml support sql server extends?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are drillthrough reports?
What is a data source file?
What are the different types of collation sensitivity?
How would you choose between a clustered and a non-clustered index?
Can you index views?