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

Write a program using SQL queries to find a unique entry in a table.

550


What is the difference between ddl,dml and dcl commands?

612


What is partition, how will you implement it? : sql server analysis services, ssas

606


What is the use of stored procedure?

516


What are the differences between lost updates and uncommitted dependencies?

545






What is the cartesian product of table?

550


Can you tell me some of the common replication dmv's and their use? : sql server replication

537


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

583


Can a function call a stored procedure in sql server?

529


What is the use of builtinadministrators group in sql server? : sql server security

537


How to create prepared statements using odbc_prepare()?

570


How to connect a database with sql express.?

572


How to assign null values to variables or columns?

551


How to recreate an existing index in ms sql server?

550


What is partition in sql server?

535