Ordered Indices - DBMS

1.

In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

   A.) Clustered index
   B.) Structured index
   C.) Unstructured index
   D.) Nonclustered index

Answer: Option 'A'

Clustered index

2.

In B+ tree the node which points to another node is called

   A.) Leaf node
   B.) External node
   C.) Final node
   D.) Internal node

Answer: Option 'D'

Internal node

3.

Insertion of a large number of entries at a time into an index is referred to as __________ of the index.

   A.) Bulk loading
   B.) Bulk insertion
   C.) Loading
   D.) Increase insertion

Answer: Option 'A'

Bulk loading

4.

In a __________ index, an index entry appears for only some of the search-key values.

   A.) Dense
   B.) Sparse
   C.) Straight
   D.) Continuous

Answer: Option 'A'

Dense

5.

Incase the indices values are larger, index is created for these values of index. This is called

   A.) Pointed index
   B.) Sequential index
   C.) Multilevel index
   D.) Multiple index

Answer: Option 'C'

Multilevel index

Ordered Indices - DBMS Download Pdf