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
- 5771 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
What is the role of the data page in the db2 database?
When do you specify the isolation level?
How to view db2 table structure?
What are the two types of logging in the db2 database? Explain them.
How to execute stored procedure in db2 command editor?
What is the usage of open cursor command?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is db2? Explain.
What is rebind in db2?
What is cloudant database?
What is the use of dclgen in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How connect db2 database to datastage?
What is concurrency?
What is the maximum No of rows per page?
