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
What is db2 instance?
What is db2 stogroup?
How can you find out the # of rows updated after an update statement?
What is a collection in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What are db2 objects?
Explain correlated sub-queries.
Highlight all the advantages that are attached to a package.
What is a db2 tablespace?
What is clone table?
What is ibm db2 client?
What is schema in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Can we insert update delete in view?
How to retrieve rows from a db2 table in embedded sql?