In terms of DB2 indexing, what is the root page?



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

Post New Answer

More DB2 Interview Questions

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


What is bind and rebind in db2?

0 Answers  


Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


What is null value in db2?

0 Answers  


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?

3 Answers  






What does a deadlock mean in DB2?

0 Answers  


What is role in db2?

0 Answers  


What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


In terms of DB2 indexing, what is the root page?

1 Answers  


Which component is responsible for db2 startup and shutdown?

0 Answers  


if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  


Categories