Single Level Order Indexes MCQs Quiz Online Tests pdf Download

Practice single level order indexes MCQs, DBMS MCQ for online test prep. File indexing structures quiz has multiple choice questions (MCQ), single level order indexes quiz questions and answers as index which has an entry for some of key value is classified as, answer key with choices as linear index, dense index, non dense index and cluster index for competitive viva exams prep, interview questions. Free study guide is to learn single level order indexes quiz online with MCQs to practice test questions with answers.

MCQs on Single Level Order Indexes Quiz pdf Download

MCQ. Index which has an entry for some of key value is classified as

  1. linear index
  2. dense index
  3. non dense index
  4. cluster index


MCQ. Primary indexes, secondary indexes and cluster indexes are all types of

  1. ordered indexes
  2. unordered indexes
  3. linear indexes
  4. relative search indexes


MCQ. Example of non dense index is

  1. ternary index
  2. secondary index
  3. primary index
  4. clustering index


MCQ. In data file, first record of any of block is called

  1. anchor record
  2. dense record
  3. non dense record
  4. none of above


MCQ. First field in primary index having same data type as in ordering field is considered as

  1. indexed key
  2. ternary key
  3. secondary key
  4. primary key