Interested to Buy Any Domain ? << Click Here >> for more details...
What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 13754 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 |
My sql statement select avg(salary) from emp yields inaccurate results. Why?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What is IMAGECOPY ?
What are the various locks available?
Where are plans stored?
What is meant by explain?
What is page size in db2?
How do I create a view in db2?
How does DB2 determine what lock-size to use?
Explain what a plan is?
Who uses db2?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
COBOL 
