Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locks available?
- 5 Answers
- 12129 Views
- CTS, I also Faced
- E-Mail Answers
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 |
Do we need cursor for Count(*)?
What is the difference between SYNONYM and ALIAS?
What is image copy in db2?
When is the skeleton cursor table created?
What is the self-referencing constraint?
What is a DB2 access path?
Where would you find information about the type of database authority held by the user?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
Mention the different locking levels that are available in db2.
What is a clustering index?
What is the maximum number of columns in a db2 table?
Is db2 relational database?
COBOL 
