KyaPoocha.com

Huge Collection of Interview Questions


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 dataset.



If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |