What is a root page?



What is a root page?..

Answer / s

Root pages contains the high range values and pointers to
the non-leaf pages.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,


When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,


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?

3 Answers  


What is cursor with hold option in db2?

0 Answers  


Mention the various locks that are available in db2.

0 Answers  






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?

3 Answers   CTS,


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  


What is an asychronous write?

1 Answers  


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  


How to see the structure of db2 table??

4 Answers   IBM,


What is the difference between db2 and oracle?

0 Answers  


What is read-only cursor?

1 Answers  


Categories