What is a clustering index ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a clustering index ?

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

(Continued on next question...)

Other Job Interview Questions

• What is lock escalation?
• What are the functions of Bind?
• What is the command used by TSO users to invoke DB2 ?
• Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
• How do you retrieve the data from a nullable column?
• How many buffer pools are there in DB2?
• What do you mean by NOT NULL WITH DEFUALT? When will you use it ?
• Explain what a plan?
• How will you delete duplicate records from a table ?
• Explain the use of the WHERE clause?
• More...