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 the difference between “where” and “having” clause in sql server?

750


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

840


What are different types of statement?

667


How to use subqueries in the from clause in ms sql server?

806


Does sql server 2000 clustering support load balancing?

734






What the different topologies in which replication can be configured?

721


What does ss stand for sexually?

794


What is the concept of optimization?

776


How we create SQL Server 2005 Reporting Services ? Give me Sample

1742


what is create database syntax? : Sql server database administration

795


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

933


How to change the system date and time from SQL Plus Terminal ?

860


What is left outer join in sql server joins?

696


How to link tables in sql server?

659


Define candidate key, alternate key, and composite key.

688