What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?

Answer Posted / gayatri soni

Deadlock occur in interconnection n/w when group of process
are unable to act because of waiting each other to release
some resorce.

live lock- packets continue to move through n/w, but does
not advance towards destination.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are dml triggers and types of dml triggers?

547


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

565


What is isolation levels?

566


What are the basic functions for master, msdb, model, tempdb databases?

588


What are points to remember while using the fillfactor argument?

530






Explain tablesample?

550


What is mean by dml?

537


How we can compare two database data?

519


Which is the best place or learning center for MS SQL?????In Bangladesh?????

1594


What is the difference between lock, block and deadlock? : sql server database administration

564


How to make remote connection in database?

594


What is BCP? When does it used in sql server 2012?

578


Tell me the phases a transaction has to undergo?

548


How to download microsoft sql server 2005 express edition?

574


What types of Joins are possible with Sql Server?

543