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

how can you initialize log miner?

0 Answers   Oracle,


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

0 Answers  


what r the types of backup?

5 Answers   CSC,


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  






How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,


I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  


what is the difference between db2start command and start database manager command?

1 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


what is logical system in sap basis

0 Answers  


why we use cursors

1 Answers  


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  


Categories