Name the different types of Table spaces.
- 5 Answers
- 13578 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 the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is the FREE command?
What does the REORG Utility do?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is a buffer in memory?
What is EXPLAIN?
what is a trigger and types of triggers
what is the difference between normal select query and currosor
What is node in db2?
What is with ur in db2?
Mention the definition of cobol in varchar field.
COBOL 
