What DB2 Catalog column tell you when an index n

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

(Continued from previous question...)

What DB2 Catalog column tell you when an index needs table reorganized?

The FAROFFPOS column of the SYSIBM.SYSINDEXPART table.

(Continued on next question...)

Other Job Interview Questions

• What are some SQL aggregates and other built-in functions?
• Explain the use of the WHERE clause?
• How does DDB2 use multiple table indexes ?
• What is the purpose of the QUIESE Utility?
• What is the difference between static and dynamic SQL?
• When is the results table for the query in a DECLARE CURSOR statement created ?
• Under what circumstances will DB2 allow an SQL satement ...
• What does it mean if the null indicator has -1, 0, -2??
• How do you do the EXPLAIN of a dynamic SQL statement ?
• What is a Resource Control Table (RCT)? Describe its characteristics.
• More...