What are simple, segmented and partitioned table

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

(Continued from previous question...)

What are simple, segmented and partitioned table spaces ?

Simple Tablespace:
Can contain one or more tables
Rows from multiple tables can be interleaved on a page under the DBAs control and maintenance
Segmented Tablespace:
Can contain one or more tables
Tablespace is divided into segments of 4 to 64 pages in increments of 4 pages. Each segment is dedicated to single table. A table can occupy multiple segments
Partitioned Tablespace:
Can contain one table
Tablespace is divided into parts and each part is put in a separate VSAM dataset.

(Continued on next question...)

Other Job Interview Questions

• What happens to the PLAN if index used by it is dropped?
• What is filter factor?
• Is it mandatory to use DCLGEN? If not, why would you use it at all?
• What is ALTER ?
• How do you insert a record with a nullable column?
• How do you specify and use a cursor in a COBOL program? –
• Why SELECT * is not preferred in embedded SQL programs?
• When is the access path determined for dynamic SQL? –
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• What does it mean if the null indicator has -1, 0, -2? –
• More...