engineering recuitment NIC NIELIT Scientist B 2023 Mock Test DBMS File Organization and Indexing Indexing
Which of the following statements is false?
1
The main disadvantage of the index-sequential file organization is that performance degrades as the file grows,both for index look ups and for sequential scans
through the data.
2
A B+ tree index takes the form of a balanced tree in which every path from the root of the tree to a leaf of the tree is of the same length.
3
The non leaf nodes of the B+ tree form a multilevel(sparse) index on the leaf nodes.
4
Searching for records with a multilevel index requires significantly more I/O operations than searching for records by binary search.