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

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


How to solved 818 error

4 Answers   Keane India Ltd, Wipro,


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


What is meant by AUTO COMMIT?

3 Answers  


i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  


What is the function of logging in the db2 database?

0 Answers  


how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,


Before you give the explain statement, what are the prerogatives?

0 Answers  


This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  


What do you do to keep the cursor from closing after a commit?

1 Answers  


How could one combine a set of incremental image copies into a single copy?

1 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


Categories