Answer Posted / swapnil
USING AN INDEX WE CAN ACCESS THE KEY VERY FAST
ON PRIMARY KEY YOU CREATE AN INDEX.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Define declaration generator (dclgen).
Which command is used to connect to a database in DB2 ? Give the Syntax.
Mention the definition of cobol in varchar field.
Where can you declare a cursor in a cobol-db2 program?
What is explain in db2?
Explain correlated sub-queries.
How and when does the db2 enforces the unique key?
Why cursor is used in db2?
Who uses db2?
What is a plan and package in db2?
Explain the function of data manager.
What is reorg and runstats in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Can one database have multiple instances?
