Single Level Order Indexes MCQs Quiz Online PDF Download

Learn single level order indexes MCQs, DBMS test for learning online courses and test prep to practice. File indexing structures quiz has multiple choice questions (MCQ), single level order indexes quiz questions and answers, types of indexes, multilevel indexes, single level order indexes tutorials for online introduction to DBMS courses distance learning.

Database management system practice test MCQ: index which has an entry for some of key value is classified as with choices linear index, dense index, non dense index and cluster index problem solving skills for summative and formative assessment, competitive exam prep, interview questions with answer key. 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. 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