Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is a deadlock in SQL? How can you prevent it?

Answer Posted / hr@tgksolutions.com

A deadlock occurs when two or more transactions hold locks that the other needs, causing them to wait indefinitely.
Ways to prevent deadlocks:
• Use consistent lock ordering.
• Keep transactions short and fast.
• Use lower isolation levels when possible.
• Implement deadlock detection mechanisms.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle rowcount?

1084


How data locks are respected in oracle?

1071


What is blob data type in oracle?

1123


How to sort the query output in oracle?

1028


What is connection pooling in oracle?

973


How to use fetch statement in a loop?

1019


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1943


how to handle exceptions in post production

1426


How many file formats are supported to export data?

1220


How to define a variable of a specific record type?

1078


What is rowid and rownum in oracle?

1011


1) Does oracle have any table which contain all the exceptions and it's code internally?

1749


Explain the use of ignore option in imp command.

1035


Explain the use of rows option in imp command.

1086


How to write an inner join with the where clause in oracle?

1044