Answer Posted / 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 |
Post New Answer View All Answers
If I have a view which is a join of two or more tables, can this view be updateable?
What is db2?
List out the three types of page locks that can be held.
What is the maximum No of rows per page?
What is commit in db2?
What are the uses of db2 optimizer?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is bind in db2?
Can there be more than one cursor open for any program?
What is copy pending status in db2?
List down the data types in the db2 database.
How do you eliminate duplicate values in db2?
What is the advantage in De-normalizing tables in DB2?
What is check constraint. Explain with example.
What is drop table?