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


which is the most efficient tablespace??
a.simple tablespace.
b.partitioned tablespace.
c.segmented tablespace.
d.none of the above.
please post answer with the reason.?

Answers were Sorted based on User's Feedback



which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segment..

Answer / jaydeep c

C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.

Is This Answer Correct ?    1 Yes 0 No

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segment..

Answer / narayana reddy

c

Is This Answer Correct ?    1 Yes 1 No

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segment..

Answer / jaydeep c

C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  


What is db2?

0 Answers  


Mention and explain the contention situations caused by locks?

1 Answers  


What is drop table?

0 Answers  


What is a db2 tablespace?

0 Answers  


List out the three types of page locks that can be held.

0 Answers  


How can you get the number of rows impacted by the last executed query?

1 Answers  


What is a storage group (stogroup)?

0 Answers  


What is -904 sql code? How to resolve it?

3 Answers  


what is the soft code for deadlock ?

2 Answers   Logica CMG,


i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,


Categories