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 a page in db2?
Are views updateable?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is netezza database?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are types of indexes?
What is db2 look?
How do I add a column to a table in db2?
What is bind package and plan in db2?
What are the bind parameters ibm db2?
What is the difference between spufi and qmf?
How do I start db2 in windows?
Explain how can you do the explain of a dynamic sql statement?
Is the primary key a clustered index?
What is dbrm in db2 database?