In terms of DB2 indexing, what is the root page?
Answer / s
Root page is at topmost level of the index which has the
upper range values and pointers to non-leaf pages.
Is This Answer Correct ? | 1 Yes | 0 No |
Q3. How will you fetch duplicate values from a DB2 table?
What is bind and rebind in db2?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is null value in db2?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What does a deadlock mean in DB2?
What is role in db2?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What are common abends
In terms of DB2 indexing, what is the root page?
Which component is responsible for db2 startup and shutdown?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)