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.?
- 3 Answers
- 5250 Views
- I also Faced
- E-Mail Answers
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
How do you find the maximum value in a column in db2?
What is concurrency?
What are db2 objects?
List down the types of triggers in the db2 database?
List some fields from sqlca?
What are the contents of a dclmgen?
What is a plan and package in db2?
Is schema the same as database?
What is cursor with hold option in db2?
What are foreign keys in db2?
Define check constraint.
What is the default page size of buffer pools?
Define db2 and its databases?
What is check constraint. Explain with example.
Is db2 a database?
