What is a clustered index?

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

(Continued from previous question...)

What is a clustered index?

For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.

(Continued on next question...)

Other Job Interview Questions

• Explain the use of the WHERE clause?
• What is the difference between TYPE 1 index and TYPE 2 index?
• What are PACKAGES?
• What is the difference between static and dynamic SQL?
• Explain transactions, commits and rollbacks in DB2?
• How many buffer pools are available in DB2
• What is normalization and what are the five normal forms?
• In SPUFI suppose you want to selet maximum of 1000 rows ...
• What is the command used by TSO users to invoke DB2 ?
• What will the COMMIT accomplish?
• More...