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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of db2 optimizer?

1295


How do I start db2 in windows?

1092


Is ibm db2 open source?

1075


What is role in db2?

1107


What is the connection string to connect to the DB2 Database ?

1128


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077


What are bind parameters in db2?

1046


What is db2?

1182


What is ibm db2 client?

939


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1060


What is host variable?

1056


How to access db2 tables in mainframe?

1051


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240


What is meant by union and union all?

1012


Can we delete records from view?

967