What are the various locks available?

Answers were Sorted based on User's Feedback



What are the various locks available?..

Answer / sudha

share,exclusive and update

Is This Answer Correct ?    14 Yes 0 No

What are the various locks available?..

Answer / lakshmisudha

locks are 2 types
1.explicet locks
cs,rr,ur,rs
2.implicet locks
shared,exclusive,update

Is This Answer Correct ?    2 Yes 0 No

What are the various locks available?..

Answer / nag(igate)

They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release

Is This Answer Correct ?    1 Yes 1 No

What are the various locks available?..

Answer / muthusamy

share,exclusive and update

Is This Answer Correct ?    0 Yes 0 No

What are the various locks available?..

Answer / satya narayana

Three. 1. mode , 2.size , 3.duration.

Is This Answer Correct ?    0 Yes 11 No

Post New Answer

More DB2 Interview Questions

How do you retrieve the data from a nullable column?

2 Answers  


What is a collection?

3 Answers  


What does DML stand for and what are some examples of it?

3 Answers   IBM,


What is usage pointer in cobol?

3 Answers   IBM,


What is with ur in db2?

0 Answers  






Explain the contention situations caused by locks?

0 Answers  


What can the Locate option of the Repair Utility accomplish?

2 Answers  


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


Is ibm db2 open source?

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  


Explain dclgen.

0 Answers  


What is PRIME TABLE and what are the uses of it

1 Answers  


Categories