Name the different types of Table spaces.
- 5 Answers
- 13511 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 |
Explain an outer join?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
what is rebinding ?
Write a query to retrive partial string.
what are stage one indexable predicates?
What is reorg and runstats in db2?
what's the best lock size that you could use when you create a tablespace?
Which catalog tables contain authorization information?
What is a page?
What is rct?
what is Runstats? Whem will u choose to runatats?
What are foreign keys?
COBOL 
