What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / soma
transaction is said to be in the state of live-lock if it
cannot proceed for a indefinite period of time while the
other transaction in the system continue normally. this may
occur if the waiting scheme for lock item is unfair giving
priority to some other transaction.
deadlock: is a situation where two or more transaction are in
a simultaneous wait sate,each of them wait for the other to
release a lock before it can proceed.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is the contrast between sql and pl/sql?
How to get the definition of a stored procedure back?
What is store procedure? How do they work?
Explain forward - only cursors?
What is a trace frag?
What is dbcc? Give few examples.
What functions can a view be used to performed?
What do you understand by the denormalisation?
How do I find my localdb version?
Tell me what is use of except clause? How it differs from not in clause?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Explain various data region available in ssrs with their use?
What are horizontal and vertical scaling?
Can you force a query to use a specific index?