Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locks available?
- 5 Answers
- 12334 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 |
What is the meaning concurrency in the db2 database?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
When is the results table for the query in a DECLARE CURSOR statement created?
What are the four lockable units for DB2?
What is a NULL value? What are the pros and cons of using NULLS?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do you eliminate duplicate values in db2?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is dbrm? When it will be created?
What is database manager in db2?
What are leaf pages?
What is pagespace?
COBOL 
