Interested to Buy Any Domain ? << Click Here >> for more details...
Name the different types of Table spaces.
- 5 Answers
- 15447 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shruthi
In DB2:
1) Simple Tablespace
2) Segmented Tablespace
3) Partitioned tablespace
In Oracle:
1)Permanent tablespaces
2)Undo tablespaces
3)Temporary tablespaces
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / siva
A table space is a logical storage structure used to control where the data for a database physically is stored. Generally in db2 there are 3 types they are:
Catalog tablespace
User tablespace
Temporary tablespace
these are the default tablespaces
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shaikh asif
System Tablespace
Non-System Tablespace
Temporary Tablespace
Undo Tablespace
| Is This Answer Correct ? | 6 Yes | 8 No |
How do I delete a table in database?
What is COPY PENDING status?
can any one expalin check point with an example?
what is the difference between normal select query and currosor
What is the difference between primary key & unique index ?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is reorg in database?
how do you resolve -805?
What is cobol db2?
What is index in db2?
What is host variable in db2 cobol?
What is the difference between Where and Having Clause
COBOL 
