Interested to Buy Any Domain ? << Click Here >> for more details...
Name the different types of Table spaces.
- 5 Answers
- 15463 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 would you print the output of an SQL statement from SPUFI?
What are the 4 environments which can access DB2 ?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
what is difference between Plan and Package
Can we install 2 different versions of Db2 on same mainframe?
B37 abend during spufi?
What is db2 stogroup?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How can we define a table? How can we apply SEARCH ALL on it ?
What will the COMMIT accomplish?
Can you access the DB2 Directory table using SQL?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
COBOL 
