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
How to connect to db2 database from windows command line?
What is null value in db2?
What is difference between alias and synonym in db2?
What is coalesce in db2?
What is rebind in db2?
What is the function of logging in the db2 database?
Explain correlated sub-queries.
What is a trigger in the db2 database?
What are the various data types available in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is runstats and reorg in db2?
Define declaration generator (dclgen).
What is db2? Explain.
Explain the contention situations caused by locks?