Interested to Buy Any Domain ? << Click Here >> for more details...
What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 13619 Views
- TCS, I also Faced
- E-Mail Answers
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
How can the duplicate values be eliminated from db2 select?
What is ibm db2 database?
Which are the db2 tools to protect integrity of the database?
What are the different types of base tables?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is drop table?
When reorg is used?
What is db2 and what is the use of db2 optimizer?
How do I import data from excel to db2?
What is difference between alias and synonym in db2?
What is the reason behind not using select * in embedded sql programs?
What is database alias db2?
Which isolation level provides highest data integrity?
What os does db2 run on?
What is plan in cobol db2?
