What is a clustered index?
Answer / 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 |
Explain the function done by data manager?
Differentiate between cs and rr isolation levels? Where do you specify them?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the max length of sqlca?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is COPY PENDING status?
What is schema in db2?
What does a deadlock mean in DB2?
How can you split a table in to exactly half?
what is a collection?
How is the SUBSTR keyword used in sql?