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

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


Can you Average the Characters ?

3 Answers  


What are the three types of page locks that can be held?

1 Answers  


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?

2 Answers  


What is null indicator in cobol db2?

0 Answers  






What is auditing?

2 Answers  


what is plan? is plan executable or package?

4 Answers  


How to update more then one record using update?

5 Answers   IBM,


What is the purpose of the QUIESE Utility?

1 Answers  


Define db2 and its databases?

0 Answers  


How to take backup of table in db2?

0 Answers  


For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  


Categories