Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are simple, segmented and partitioned table spaces ?



What are simple, segmented and partitioned table spaces ?..

Answer / s

Simple tablespaces stores the rows for all the tables and
they are interleaved with one another.

Segmented tablespaces, tables are stored in equal sized
segments and a segment contains rows from one table.

Partitioned tablespace, only one table can be defined and
rows are spread across partitions.

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More DB2 Interview Questions

Explain the use of the WHERE clause.

2 Answers   IBM,


what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,


What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,


How would one remove old reorg information from the DB2 catalog?

2 Answers  


cobol-db2 runjcl please?

2 Answers   DELL,


What is plan in cobol db2?

0 Answers  


How do you retrieve the data from a nullable column?

2 Answers  


i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,


How does db2 sample database connect?

0 Answers  


How do I start db2 in windows?

0 Answers  


How do I delete a table in db2?

0 Answers  


Categories