Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 1 Answers
- 6944 Views
- I also Faced
- E-Mail Answers
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
What would you do with an "in-doubt" distributed transaction?
how can you communicate with operating system files from oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What is the default port no on which sql server listens? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what do you understand by fine-grained auditing?
What happens on checkpoint? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
How can you control the amount of free space in your index pages? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Explain materialized views and how they are used.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
