Tablespace is the collection of tables.we can create tablespaces by using

What is tablespace?

Question Posted / kathir

Answer Posted / kathir

Tablespace is the collection of tables.we can create
tablespaces by using 3 types,

simple tablespace
sigmented tablespace
partitioned tablespace

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When reorg is used?

1178

What is host variable?

1109

How to compare data between two tables in db2?

1136

Explain db2.

1083

What is database alias db2?

1176

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1211

How to check table size in db2 sap?

1093

What are the rules for db2 programming?

1152

What is cursor with hold option in db2?

1134

What are the various isolation levels possible?

1177

Mention the different locking levels that are available in db2.

1183

What is ibm db2 database?

1061

List down the data types in the db2 database.

1177

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2219

Which component is responsible for processing sql statements and selecting access paths?

1173