Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9186 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sagi.rahul
In SQL Server Live Lock occurs when read transactions are
applied on table which prevents write transaction to wait
indefinitely and Deadlocking occurs when two user processes
have locks on separate objects and each process is trying to
acquire a lock on the object that the other process has.
Lock escalation is the process of converting a lot of low
level locks (like row locks, page locks) into higher level
locks (like table locks).
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What are the five major components of a dbms?
What are pessimistic lock and optimistic lock?
How many types of database relationship in sql server?
Explain aggregate functions?
Why do we use stored procedures in sql server?
How do use Having,Group by,Group function in SQL?
How will you decide the active and passive nodes?
Are resultset updatable?
What are the types of database schema? : sql server analysis services, ssas
What is ms sql server triggers?
Name few of the dcl commands in sql?
Explain what is sql server english query?
What is temporal table?
How to insert new line characters into strings?
