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


Please Help Members By Posting Answers For Below Questions

Are semicolons required at the end of sql statements in sql server 2005?

574


What is the contrast between sql and pl/sql?

627


How can sql server instances be hidden? : sql server security

599


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

518


Explain the different types of joins?

574






What is schemabinding a view?

536


What happens if null values are involved in datetime operations?

541


What is merge?

576


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3767


Explain identity in sql server?

569


Can two tables share a primary key?

526


Define clusters?

654


what is normalization? : Sql server database administration

541


What are the dmvs?

575


What guidelines should be followed to help minimize deadlocks?

511