System Tablespace Non-System Tablespace Temporary Tablespace Undo Table

Name the different types of Table spaces.

Question Posted / shaikh asif

5 Answers
15194 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / shaikh asif

System Tablespace
Non-System Tablespace
Temporary Tablespace
Undo Tablespace

Is This Answer Correct ?

6 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2008

What is db2 connect?

1009

Explain package in db2 and its advantages?

1134

What is the advantage in De-normalizing tables in DB2?

1115

What is the picture clause of null indicator variable?

1081

What is scrollable cursor in db2?

996

Can you tell me how can you find out the # of rows updated after an update statement?

1044

List out the buffer pools in db2

1020

What db2 400?

1103

Name the lockable units in DB2?

1073

How to test SQL -911 error while developing COB-DB2 program

7442

What is meant by explain?

1062

How do I connect my db2 database to ibm?

985

What is commit in db2?

996

What is ibm db2 client?

880