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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What are simple, segmented and partitioned table spaces ?

Question Posted / guest


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

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

List down the data types in the db2 database.

0 Answers  

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

Which command is used to remove all rows from a table?

0 Answers  

What is a system catalog table in db2?

0 Answers  

Explain correlated sub-queries.

0 Answers  

what is the soft code for deadlock ?

2 Answers   Logica CMG,

What is cursor stability in db2?

0 Answers  

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

Is ibm db2 open source?

0 Answers  

For more DB2 Interview Questions Click Here
Categories