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.?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is meant by AUTO COMMIT?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is the function of logging in the db2 database?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Before you give the explain statement, what are the prerogatives?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What do you do to keep the cursor from closing after a commit?
How could one combine a set of incremental image copies into a single copy?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?