What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / gayatri soni
Deadlock occur in interconnection n/w when group of process
are unable to act because of waiting each other to release
some resorce.
live lock- packets continue to move through n/w, but does
not advance towards destination.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How to defragment table indexes?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Can binary strings be converted into numeric or float data types?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Do you know what are the differences between lost updates and uncommitted dependencies?
What is the difference between Normalization and De-normalization?
How can you check the level of fragmentation on a table?
Some queries related to SQL
What are the basic functions for master, msdb, model, tempdb and resource databases?
How can you find out how many rows returned in a cursor?
Do you know what is blocking?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What are the 2 types of classifications of constraints in the sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
In which tcp/ip port does sql server run? Can it be changed?