What are the various locks available?
Answers were Sorted based on User's Feedback
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 |
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 is role in db2?
what is load and unload in db2
How would you print the output of an SQL statement from SPUFI?
Explain what are the various isolation levels possible?
Is it possible using max on a char column?
what is different three logs in DB2?
What is normalization and what are the five normal forms?
What is cursor stability?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What is reorg in database?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What techniques are used to retrieve data from more than one table in a single SQL statement?