File Indexing Structures Multiple Choice Questions Test 1 Tests pdf Download

Practice DBMS test 1 with MCQ on single level order indexes test for online learning. Practice file indexing structures multiple choice questions (MCQ) and answers on single level order indexes, multilevel indexes, types of indexes. Free file indexing structures revision notes has answer key with choices as dense index, linear index, non dense index and cluster index of multiple choice questions (MCQ) as index which has an entry for some of key value is classified as to test learning skills. Study to learn single level order indexes quiz questions to practice MCQ based online exam preparation test.

MCQ on File Indexing Structures: Test 1 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. In multilevel indexes, 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


MCQ. 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


MCQ. Example of non dense index is

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

D Protection Status