Interested to Buy Any Domain ? << Click Here >> for more details...
Name the different types of Table spaces.
- 5 Answers
- 15415 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 |
What is the difference between static and dynamic SQL?
Is ibm db2 free?
How many databases are there?
what is the use of cursors?
How to connect to db2 database from windows command line?
Can we delete records from view?
how to fetch multiple records without using cursor
What is a thread?
How can we retrieve the total number of records in RPG & CLLE?
how can u nderstand the sql stmts executed successfully or not ?
can any one expalin check point with an example?
What are packages in db2?
COBOL 
