Lot of updates have been done on a table due to

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

(Continued from previous question...)

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

Looks like index page split has occurred. DO a REORG of the indexes.

(Continued on next question...)

Other Job Interview Questions

• What is a Resource Control Table (RCT)? Describe its characteristics.
• What is EXPLAIN?
• What does CURRENTDATA option in bind indicate ?
• How does DDB2 use multiple table indexes ?
• What is the COBOL picture clause for a DB2 column defined
• Explain the use of the WHERE clause?
• What is the picture clause of the null indicator variable?
• What is the difference between CS and RR isolation levels ?
• What is a DB2 access path?
• What does CURRENTDATA option in bind indicate ?
• More...