What is the difference between TYPE 1 index & TYPE 2 index

Question Posted / guest

What is the difference between TYPE 1 index & TYPE 2 index..

TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.

Is This Answer Correct ?

20 Yes

4 No

More DB2 Interview Questions

What are db2 tables?

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

What is DCLGEN ?

What is the difference between spufi and qmf?

How can you do the explain of a dynamic sql statement?

Explain correlated sub-queries.

Explain what are the various isolation levels possible?

How does DB2 determine what lock-size to use?

Define check constraint.

How do you Load a table ?? and what is Load replace ?

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

For more DB2 Interview Questions Click Here