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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of ocr?

683


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1633


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1726


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1798


What purpose does the model database server? : sql server DBA

709






What are the different types of upgrades that can be performed in sql server? : sql server DBA

785


What the different components in replication and what is their use? : sql server DBA

646


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1602


What authentication modes does sql server support? : sql server DBA

792


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1733


how can you communicate with operating system files from oracle?

662


internal architecture

1844


What is the default fill factor value? : sql server DBA

669


what is the use of recording information about current session?

657


How would you go about verifying the network name that the local_listener is currently using?

2838