Interested to Buy Any Domain ? << Click Here >> for more details...
Name the different types of Table spaces.
- 5 Answers
- 15258 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 |
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
How do you check for a null value in a db2 column?
Describe what a storage group(STOGROUP) is?
Can any one tell me about Restart logic in DB2.
select 100 records from million records ?
What is meant by dclgen?
What is a storage group (stogroup)?
How would you print the output of an SQL statement from SPUFI?
Can we able to find all the Table names under a Particular Plan?
Which transaction use a command thread ?
What is an instance in db2?
Explain db2.
COBOL 
