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

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

0 Answers  


What is the use of dclgen in db2?

0 Answers  


What is RUNSTATS?

3 Answers  


What is host variable in db2 cobol?

0 Answers  


Is schema the same as database?

0 Answers  






What are the benefits of using the db2 database?

0 Answers  


What are union and union all?

0 Answers  


What is PRIME TABLE and what are the uses of it

1 Answers  


How is deadlock resolved?

0 Answers  


Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,


What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  


What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,


Categories