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 |
How to compare data between two tables in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to get Top 10 Salaries from a Table
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What do you mean by rollback?
What are the different types of base tables?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is the difference between using bind () and rebind () methods of naming class?
Why do we need reorg in db2?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What is the self-referencing constraint?