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
- 5268 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
B37 abend during spufi?
Which isolation level provides highest data integrity?
Highlight all the advantages that are attached to a package.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Explain about rct in db2?
How is deadlock resolved?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is declare cursor?
How to find primary key of a table in db2?
What is db2 bind?
Explain the benefits you can get from mainframe connect?
What is the syntax for FETCH in DB2 ?
Discuss about db2 bind?
Is db2 free?
What is the clustering index in the db2 database?
