What is a clustered index?



What is a clustered index?..

Answer / pradeep

a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence

datarows will be arranged based on the index in leaf pages

Is This Answer Correct ?    10 Yes 3 No

Post New Answer

More DB2 Interview Questions

How to compare data between two tables in db2?

1 Answers  


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,


What do you mean by rollback?

1 Answers  


What are the different types of base tables?

1 Answers  


I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,


I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,


What is the difference between using bind () and rebind () methods of naming class?

1 Answers  


Why do we need reorg in db2?

1 Answers  


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


What is the self-referencing constraint?

2 Answers  


Categories