What is deadlock and how to avoid the deadlocks.
- 3 Answers
- 9863 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / moin
A deadlock occurs when there is a cyclic dependency between
two or more threads for some set of resources.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is a join in sql? What are the types of joins?
Do you know what is a trace frag? Where do we use it?
What is wrong with sql server client libarary dll, ntwdblib.dll?
How to rename databases in ms sql server?
Difference between Inner vs outer joins?
What is explicit mode in sql server?
What is the difference between deallocate cursor and close cursor?
Do you know concepts and capabilities of sql server?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What are the recovery models for a database?
Explain the disadvantages of cursors?
How to recreate an existing index in ms sql server?
What are the approximate numeric data types?
Define a cross join?
To which devices can a backup be created and where should these devices be located? : sql server management studio
