Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6251 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 the difference between plan and package in db2?
Are views updateable?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What language is db2 written in?
List out the three types of page locks that can be held.
Is schema the same as database?
What is the result of open cursor statement?
Can there be more than one cursor open for any program?
What is cursor in dbms?
What is table space in db2?
What is db2 plan table?
Which isolation level provides maximum concurrency?
How can record locking be achieved in those DB2 versions which do not support it?
What is alias in db2?
What is database reorganization?
