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



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

Answer / monal

Live Lock occurs when exclusive lock is denied continuously
by series of overlapping shared locks keep on interfering
each other and they keep changing status further preventing
them to complete the task.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB Administration Interview Questions

What types of replication are supported in sql server? : sql server DBA

0 Answers  


How do you resize a data file?

2 Answers  


How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  


Where would you look for errors from the database engine?

0 Answers   IBM,


Give two examples of referential integrity constraints.

2 Answers  






how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,


What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  


How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  


how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,


I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  


What is replication? : sql server DBA

0 Answers  


Categories