Mention and explain the contention situations caused by locks?

Question Posted / prakasha m

1 Answers
1421 Views
I also Faced
E-Mail Answers

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 are the benefits of using the db2 database?

0 Answers

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers

What is check constraint. Explain with example.

0 Answers

What is node in db2?

0 Answers

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers

What is DCLGEN ?

3 Answers

What is buffrpool? Where we use it ?

2 Answers Tesco,

How do you retrieve the data from a nullable column?

2 Answers

What is a LIKE table and how is it created?

2 Answers

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers

What are the contents of a DCLGEN?

4 Answers MetLife,

For more DB2 Interview Questions Click Here