What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 13205 Views
- TCS, I also Faced
- E-Mail Answers
Answer / s
Simple tablespaces stores the rows for all the tables and
they are interleaved with one another.
Segmented tablespaces, tables are stored in equal sized
segments and a segment contains rows from one table.
Partitioned tablespace, only one table can be defined and
rows are spread across partitions.
| Is This Answer Correct ? | 6 Yes | 1 No |
What is a result table?
How do you check for a null value in a db2 column?
How to create a table using embedded sql?
How to define the a field which accepts value till 99999.99 in db2
Where could you look if you had a question about whether a column has been defined as an index?
Which component is used to execute the sql statements?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is role in db2?
What is a root page?
What is referential integrity?
Can we update view in db2?
What is COPY PENDING status?
COBOL 
