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

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


What are the disadvantages of PAGE level lock?

3 Answers  


Define predicate?

0 Answers  


What are delete-connected tables?

1 Answers  


What is the max length of sqlca?

0 Answers  


What is a DB2 access path?

1 Answers  


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,


What information is held in SYSIBM.SYSCOPY?

1 Answers  


How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,


How many buffer pools are available in db2?

2 Answers  


Categories