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...


Mention and explain the contention situations caused by locks?



Mention and explain the contention situations caused by locks?..

Answer / ereshwari

Lock Contention can lead to:
1. Suspension
2. Timeout
3. Deadlock

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is a system catalog table in db2?

0 Answers  


What is reorg in database?

1 Answers  


Can we delete records from view?

0 Answers  


In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,


What are the contents of a dclmgen?

0 Answers  


Mention the definition of cobol in varchar field.

0 Answers  


Are views updatable ?

4 Answers  


What is commit in db2?

0 Answers  


Explain the EXPLAIN statement?

1 Answers  


If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


Which isolation level provides maximum concurrency?

0 Answers  


Categories