Interested to Buy Any Domain ? << Click Here >> for more details...
What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 13724 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
Can we insert update delete in view?
List down the types of triggers in the db2 database?
What happens in bind step in a db2 program?
How to restart a DB2 program?
What is db2 command?
How do you find the maximum value in a column in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is ibm db2 used for?
what is a corelated subquerry?
What is reorg and runstats in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What kind of database is db2?
What is the clustering index in the db2 database?
Which isolation level provides maximum concurrency?
