In terms of DB2 indexing, what is the root page

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

The simplest DB2 index is the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search.

(Continued on next question...)

Other Job Interview Questions

• What is the syntax required for the creation of a cursor ?
• What is the difference between TYPE 1 index and TYPE 2 index?
• What information is used as input to the bind process?
• What is a cursor and what is its function ?
• What is the SQL Communications Area and what are some of its key fields?
• an I alter a table when other user is selecting some columns ...
• Where is the output of EXPLAN stored?
• What is the difference between group by and order by ?
• What is the Manimum Length SQLCA and what is the content of SQLCABC?
• What is the meaning of -805 SQL return code ?
• More...