What are leaf pages ?
They are the opposite of root pages. Leaf pages are the lowest level index pages - the pages that contain index entries and information to the corresponding table rows.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How is nesting of elements handled in XML? 22.11.08
If Nesting implies Handling the various Xpaths from root to the leaf nodes then below is the menthod to hadle it. There can be many repeatative groups in the...leaf node does not have any child nodes. 29.10.08
A leaf node is the last node on a branch and does not have any child nodes...What is a leaf node? 29.10.08
A leaf node is the last node on a branch...How many sub pages, secondary pages can be created in one level ? 12.08.08
There can be any number of sub-pages but only one secondary page in a level....What is the basic difference between clustered and a non-clustered index ? 23.07.08
The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index i...What is a root page ? 05.04.08
The opposite of a leaf page; it is the highest level index page. An index can contain only the one root page; all other index pages are associated to the root...How are Servlets and JSP Pages related? 08.02.07
JSP pages are focused around HTML (or XML) with Java codes and JSP tags inside them. When a web server that has JSP support is asked for a JSP page, it checks t...What is a Style Sheet? 16.08.06
Style sheets are the way that standards-compliant Web designers define the layout, look-and-feel, and design of their pages. They are called Cascading Style She...Which is faster?JSP page or ASP page. 08.08.06
Although ASP pages are cached, they are always interpreted. By contrast, JSP pages are compiled into Java servlets and loaded into memory the first time they ar...In RDBMS, what is the efficient data structure used in the internal storage representation? 09.03.06
B+ tree. Because in B+ tree, all the data is stored only in leaf nodes, that makes searching easier. This corresponds to the records that shall be stored in lea...