What are the three types of page locks that can be held?



What are the three types of page locks that can be held?..

Answer / s

I think you mean the three types of LOCK MODES.
S Share
U Update
E Exclusive

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,


What is bind and rebind in db2?

0 Answers  


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,






What is netezza database?

0 Answers  


What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  


What are the rules for db2 programming?

0 Answers  


Is ibm db2 open source?

0 Answers  


What is bind package and plan in db2?

0 Answers  


i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,


what is difference between random and sequence file access

1 Answers   Syntel,


Categories