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 DBA's 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 daataset.

(Continued on next question...)

Other Job Interview Questions

• What are the three lock types?
• What is the SQL Communications Area and what are some of its key fields?
• How to see the structure of DB2 table?
• What is a view ? Why use it
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• What types of copies can be made with the COPY Utility?
• What is the COBOL picture clause of the following DB2 data types?
• How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ?
• What is meant by index cardinality?
• The only place of VSAM KSDS in DB2 is
• More...