File Indexing Structures Multiple Choice Questions 1 PDF Download

Learn file indexing structures multiple choice questions (MCQs), DBMS test 1 for online exams. Practice single level order indexes MCQs questions and answers on single level order indexes, multilevel indexes, types of indexes with answers. Free file indexing structures quiz, online study guide has helping answer key with choices as dense index, linear index, non dense index and cluster index of multiple choice questions as index which has an entry for some of key value is classified as to test learning skills for viva exam preparation and job's interview questions. Study to learn single level order indexes quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on File Indexing Structures Quiz PDF Download Test 1

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. In multilevel indexes, the primary index created for its first level is classified as

  1. zero level of multilevel index
  2. third level of multilevel index
  3. second level of multilevel index
  4. first level of multilevel index

C

MCQ. The indexes which specifies address of records on disk with a physical pointer are classified as

  1. structural index
  2. hashing index
  3. physical index
  4. logical index

C

MCQ. The example of non dense index is

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

D