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 is exporting and importing utility?

612


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

577


What new changes are being made in SQL Server?

576


What do you mean by recursive stored procedure?

513


Explain what is the difference between a local and a global temporary table?

517






Explain microsoft sql server functions?

542


Define master database?

583


what is a correlated sub-query? : Sql server database administration

484


How many ways to create table-valued functions?

586


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1633


Can we perform backup restore operation on tempdb? : sql server database administration

587


Do you know what are the differences between lost updates and uncommitted dependencies?

547


Can binary strings be converted into numeric or float data types?

559


what are the three command line utilities and what are their primary functions?

101


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2211