IBM DB2 Question:

Download Job Interview Questions and Answers PDF

What is a clustering index ?

IBM DB2 Interview Question
IBM DB2 Interview Question

Answer:

Causes the data rows to be stored in the order specified in the index. A mandatory index defined on a partitioned table space.

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
A user
defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.		What is the difference between primary key & unique index ?