Answer Posted / pradeep
a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence
datarows will be arranged based on the index in leaf pages
Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What is a db2 table?
what is the role of the cursor in db2?
What is reorg and runstats in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the max length of sqlca?
How can deadlocks be resolved?
What are the prerogatives?
Mention the definition of cobol in varchar field.
What is load replace in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is db2 optimizer?
Where do you specify them?
what is utility for parm lib
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
When the like statement is used?