Single Level Order Indexes MCQs Quiz Online PDF Download

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

MCQs on Single Level Order Indexes Quiz PDF Download

MCQ. The index which has an entry for some of the key value is classified as

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

C

MCQ. The primary indexes, secondary indexes and cluster indexes are all types of

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

A

MCQ. The example of non dense index is

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

D

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

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

A

MCQ. The first field in the primary index having same data type as in the ordering field is considered as

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

D