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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which components manage deadlocks in db2?
What is difference between rollback and commit?
What is plan in cobol db2?
How is the value function used?
How is a typical db2 batch pgm executed?
How will you return the number of records in table?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is cursor with hold option in db2?
What is clone table?
What is db2 connect?
Mention the various locks that are available in db2.
What is deadlock in db2?
What are concurrency issues?
What is check constraint in db2?
What is meant by explain?