File Indexing Structures Multiple Choice Questions 1 PDF Download

Learn file indexing structures multiple choice questions (MCQs), DBMS test 1 for online course prep exams. Practice single level order indexes MCQs questions and answers on single level order indexes, multilevel indexes, types of indexes for online software engineering degree practice test.

Free file indexing structures quiz online, study guide has multiple choice question on index which has an entry for some of key value is classified as with options dense index, linear index, non dense index and cluster index to test online e-learning skills for viva exam prep and job's interview questions with answers key. 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. 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

C

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

A

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

C

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

C

MCQ. Example of non dense index is

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

D