What are simple, segmented and partitioned table spaces ?
Answer Posted / 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 |
Post New Answer View All Answers
What is a bind card?
What is the use of with ur in db2?
What is dbrm in db2 database?
What is check constraint. Explain with example.
Which isolation level provides maximum concurrency?
What is syscat in db2?
How to execute stored procedures?
How to restart a DB2 program?
Is the primary key a clustered index?
What is view db2?
What is access path in db2?
How can we retrieve the total number of records in RPG & CLLE?
How is the value function used?
How do I add a column to a table in db2?
What is rct?