Root page is at topmost level of the index which has the upper range valu

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

Question Posted / s

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How will you return the number of records in table?

880

What is the use of db2 optimizer?

1036

Explain what are the various isolation levels possible?

989

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2865

What is a page in db2?

980

What is dclgen in db2?

1082

What is lock escalation in db2?

967

How to check sequence on a table in db2?

994

Define db2 and its databases?

1002

How can we retrieve the total number of records in RPG & CLLE?

577

What is db2 connect?

1008

What is the maximum size of a char data type in db2?

964

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11615

What is precompiler in db2?

958

What is sqlca’s maximum length?

1102