Answer Posted / 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 |
Post New Answer View All Answers
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is bufferpool in db2?
What is a db2 tablespace?
What is load replace in db2?
What is the use of dclgen in db2?
What is the meaning concurrency in the db2 database?
What is the use of runstats in db2?
What are concurrency issues?
Name the lockable units in DB2?
What is lock escalation in db2?
What is rebind in db2?
List out the three types of page locks that can be held.
What is precompiler in db2?
What is a trigger in the db2 database?
What is the maximum size of varchar data type in db2?
