Interested to Buy Any Domain ? << Click Here >> for more details...
What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 13744 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 |
Can we install 2 different versions of Db2 on same mainframe?
What is a NULL value? What are the pros and cons of using NULLS?
Define db2 and its databases?
Normalization in DB2 – first normal form, second normal form
What is precompiler in db2?
What is a page?
What Utility is used to migrate DB2 from one release to the next?
What is the difference between group by and order by?
What do you mean by between and in? Is between inclusive of specified range values?
What is filter factor?
what's the error code for Unique Index Violation?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
COBOL 
