Give some example of statistics collected during

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

(Continued from previous question...)

Give some example of statistics collected during RUNSTATS?

# of rows in the table
Percent of rows in clustering sequence
# of distinct values of indexed column
# of rows moved to a nearby/farway page due to row length increase

(Continued on next question...)

Other Job Interview Questions

• When you COMMIT, is the cursor closed? - drona questions–
• What is the restriction on using UNION in embedded SQL?
• What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
• What happens when you say OPEN CURSOR?
• What are correlated subqueries?
• What is the difference between IN subselects and EXISTS subselect?
• What is a NULL value? What are the pros and cons of using NULLS?
• When you COMMIT, is the cursor closed? - drona questions–
• What is a cursor? why should it be used? –
• What else is there in the PLAN apart from the access path? –
• More...