What is the difference between TYPE 1 index & TYPE 2 index
Answer / s
TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.
| Is This Answer Correct ? | 20 Yes | 4 No |
How do you check for a null value in a db2 column?
How to solve S0C7 abend with out using DISPlay in 10 mins?
what is a plan and how do you refer the plan in the program?
What is a clustering index ?
What are db2 objects?
Can you search give an array in the WHERE clause of a db2 query?
What is the size of a data page?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
how to identify the pseudo conversation by seeing the program
What is meant by AUTO COMMIT?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?