Interested to Buy Any Domain ? << Click Here >> for more details...
What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 13703 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 |
What is meant by repeatable read?
What is a DB2 catalog?
What is a buffer pool?
How to handle null values in db2
What are foreign keys in db2?
how to execute qcmdexc in rpgle?plz write code also?
How to take backup of table in db2?
How can you quickly find out the # of rows updated after an update statement?
How Plan is created while executing the query using SPUFI?
What is the significance of DB2 free space and what parameters control it?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is meant by union and union all?
COBOL 
