What are the Maximum and minimum, number of part

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

(Continued from previous question...)

What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?

Maximum is 64 and minimum is 4.

(Continued on next question...)

Other Job Interview Questions

• If I have a view which is a join of two or more tables, can this view be updatable?
• How could one combine a set of incremental image copies into a single copy?
• What will the COMMIT accomplish?
• What is pagespace?
• I need to view the number of tables existing under one particular OWNER. Is it possible ? If so, please give the SQL query for this ?
• What is the difference between group by and order by ?
• MAX number of columns in a DB2 table
• How many sub queries can you combine together?
• What are a precompiler?
• When is the access path determined for dynamic SQL?
• More...