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 the implicit cursor in oracle?

1055


How to get the Installed Oracle Version Information ?

1095


what is the dual table in oracle?

946


How do we create privileges in oracle?

1006


How to get a list of all user accounts in the database?

1054


How many categories of data types in oracle?

990


What are set operators?

1045


State any two functions of oracle?

1000


How to set up autotrace for a user account?

993


How to do clean up if create database failed?

993


Why do we use coalesce function in oracle?

1073


How do we get field detail of a table?

1038


What is sequence?

1032


How to create a temporary table in oracle?

1219


Can the query output be sorted by multiple columns in oracle?

953