What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / cheti
Deadlock is a sitiuation wher a group of processes are
permanetly blocked as result of each process having
acquired a subset of the resources needed for its
completion and waiting for release of remaining resources
held by others in the same group.Thus,making it impossible
for any of the process to proceed.
Livelock:- Sorry
Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
How will you optimize a stored procedure optimization?
How to create a user name in a database?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
How to create a testing table with test data in ms sql server?
Explain what is public role in sql server?
Is truncate a dml command?
How to use old values to define new values in update statements in ms sql server?
What is failover clustering overview?
What is the dbcc command and why is it used?
What is isolation levels?
What are page splits?
How to make a remote connection in a database?
What is difference between after and before?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How to implement service broker?