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

How will you optimize a stored procedure optimization?

513


How to create a user name in a database?

585


It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

551


How to create a testing table with test data in ms sql server?

556


Explain what is public role in sql server?

580






Is truncate a dml command?

499


How to use old values to define new values in update statements in ms sql server?

679


What is failover clustering overview?

588


What is the dbcc command and why is it used?

569


What is isolation levels?

566


What are page splits?

577


How to make a remote connection in a database?

532


What is difference between after and before?

505


What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

741


How to implement service broker?

523