Interested to Buy Any Domain ? << Click Here >> for more details...
Name the different types of Table spaces.
- 5 Answers
- 15190 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 correlated sub-queries.
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is a predicate?
What is lock contention?
How to check table size in db2 sap?
What do you mean by NOT NULL? When will you use it?
How do I create a view in db2?
What is the difference between group by and order by?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is index in db2?
Why db2 is called db2?
What is the difference between db2 and oracle?
COBOL 
