Interested to Buy Any Domain ? << Click Here >> for more details...
What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 13800 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
What is difference between isnull and coalesce?
What is drop table?
How to test SQL -911 error while developing COB-DB2 program
Define db2.
What is node in db2?
When do you specify the isolation level?
List out the data types available.
What is rebind in db2?
How to find the number of rows in db2 tables?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
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
What do you mean by commit and rollback?
What is the role of the data page in the db2 database?
If I have a view which is a join of two or more tables, can this view be updateable?
What is bind in db2?
