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
- 5767 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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is db2 and what is the use of db2 optimizer?
What is the use of db2?
How to rename a table in DB2 ?
What is db2 stogroup?
How do I create a view in db2?
What are the different types of base tables?
How do I import data from excel to db2?
What is the default page size of buffer pools?
Why do chiropractors use drop table?
What is the use of commit in db2?
Explain in detail about buffer manager and its functionalities?
How to fetch the last row from the table in SQL (db2)?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Who uses db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
