What is live lock and deadlock?
what is Lock escalation?
Answer Posted / zeeshu
LIVE LOCK: when a process is running but it doesnt do any useful work at all but it consumes the cpu time.
DEADLOCK: IN SIMPLE MEANING when a process is requesting for a resource which is held by some other process,and that process is waiting for the resource which is holding by the previous process,then there is a condition of deadlock....
converting low level lock to high level lock is lock escalation
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is inner join? Explain with an example?
What is the difference between value type and reference type?
What is usually the first word in a sql query?
How to enable/disable indexes?
How to stop a loop early with break statements in ms sql server?
What is coalesce in sql server?
What is single-user mode?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How do I port a number to sql server?
Difference between aggregate functions of sql?
What is the meaning of resultset type_scroll_insensitive?
What is a print index?
What is catalog views?
How to recover from sql injection? : sql server security
When multiple after triggers are attached to sql table, how to control the order of execution?