File Indexing Structures Multiple Choice Questions 1 PDF Download

Learn file indexing structures multiple choice questions (MCQs), DBMS test 1 for online learning, course exam prep. Practice single level order indexes MCQs, file indexing structures questions and answers on single level order indexes, multilevel indexes, types of indexes test for online introduction to DBMS courses distance learning.

Free file indexing structures quiz online, self-study student guide has multiple choice question: index which has an entry for some of key value is classified as with choices dense index, linear index, non dense index and cluster index with technical interview questions for online assessment of fresh and experienced graduates. Study to learn online single level order indexes quiz questions with DBMS MCQs for DBMS certification competitive exam prep.

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

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