What are the four lockable units for DB2?

Question Posted / guest

What are the four lockable units for DB2?..

Tablespace, Table, Page, Row

Is This Answer Correct ?

12 Yes

0 No

More DB2 Interview Questions

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?

Differentiate between cs and rr isolation levels? Where do you specify them?

wht are the restrictions for union ?

What is the function of buffer manager?

Explain in detail about buffer manager and its functionalities?

What is the purpose of the QUIESE Utility?

Can we able to find all the Table names under a Particular Plan?

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

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

what is the Foreign key? explain?

What is the reason behind not using select * in embedded sql programs?

What is db2 bind process?

For more DB2 Interview Questions Click Here