Ordered Indices MCQ

Test your knowledge with important Ordered Indices MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Ordered Indices MCQs at Bissoy

• A search key containing more than one attribute is called a _________ search key
  ক

  Multiple

  খ

  Multilevel

  গ

  Composite

  ঘ

  Primary
• Indices with two or more levels are called as?
  ক

  Multiple Indices

  খ

  Multilevel indices

  গ

  Bi- tri- Indices

  ঘ

  None of the mentioned
• If an index entry appears for only some of the search key values in the file, it is called as ________
  ক

  Dense key

  খ

  Dense index

  গ

  Sparse key

  ঘ

  Sparse index
• If an index entry appears for every search key value in the file, it is called as ________
  ক

  Dense key

  খ

  Dense index

  গ

  Sparse key

  ঘ

  Sparse index
• State true or false: Clustering indices are also called as primary indices
  ক

  True

  খ

  False
• If the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.
  ক

  Clustering data

  খ

  Cluttering index

  গ

  Clustering index

  ঘ

  Clustering number
• The additional space occupied by an index structure is called as _________
  ক

  Access modes

  খ

  Space types

  গ

  Access time

  ঘ

  Space overhead
• The time it takes to delete a data item is called as _________
  ক

  Insertion time

  খ

  Deletion time

  গ

  Time overhead

  ঘ

  Access time
• The time it takes to insert a new data item is called ____________
  ক

  Insertion time

  খ

  Deletion time

  গ

  Time overhead

  ঘ

  Access time
• The time it takes to find a particular data item is called as ___________
  ক

  Insertion time

  খ

  Deletion time

  গ

  Time overhead

  ঘ

  Access time
• The types of access that are supported efficiently are called as ________
  ক

  Access modes

  খ

  Access types

  গ

  Access time

  ঘ

  Access overhead
• While inserting the record into the index, if the search-key value does not appear in the index.
  ক

  The system adds a pointer to the new record in the index entry

  খ

  The system places the record being inserted after the other records with the same search-key values

  গ

  The system inserts an index entry with the search-key value in the index at the appropriate position

  ঘ

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

  Loading

  খ

  Bulk insertion

  গ

  Bulk loading

  ঘ

  Increase insertion
• In B+ tree the node which points to another node is called
  ক

  Leaf node

  খ

  External node

  গ

  Final node

  ঘ

  Internal node
• A search key containing more than one attribute is referred to as a _________ search key.
  ক

  Simple

  খ

  Composite

  গ

  Compound

  ঘ

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

  Pointed index

  খ

  Sequential index

  গ

  Multilevel index

  ঘ

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

  Dense

  খ

  Sparse

  গ

  Straight

  ঘ

  Continuous
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
  ক

  Dense

  খ

  Sparse

  গ

  Straight

  ঘ

  Continuous
• An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
  ক

  Index entry

  খ

  Index hash

  গ

  Index cluster

  ঘ

  Index map
• Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.
  ক

  Nonclustered

  খ

  Secondary

  গ

  All of the mentioned

  ঘ

  None of the mentioned
• 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.
  ক

  Clustered index

  খ

  Structured index

  গ

  Unstructured index

  ঘ

  Nonclustered index