Hashing Techniques MCQs Quiz Online PDF Download

Learn hashing techniques MCQs, DBMS test for online courses learning and test prep to practice. Disk storage, file structures and hashing quiz has multiple choice questions (MCQ), hashing techniques quiz questions and answers to learn for online graduate degree test prep.

Database management system test MCQ on in linear hashing, formula of file load factor is with options l = r⁄ (bfr * n), l = r⁄ (bfr + n), l = r⁄ (bfr - n) and l = r⁄ (bfr * 2n) problem solving skills for viva, competitive exam prep, interview questions with answer key. Free study guide is for online learning hashing techniques quiz with MCQs to practice test questions with answers.

MCQs on Hashing Techniques Quiz PDF Download

MCQ. In linear hashing, formula of file load factor is

  1. l = r⁄ (bfr * N)
  2. l = r⁄ (bfr + N)
  3. l = r⁄ (bfr - N)
  4. l = r⁄ (bfr * 2N)

A

MCQ. Hashing technique which allocates fixed number of buckets is classified as

  1. dynamic hashing
  2. static hashing
  3. external hashing
  4. internal hashing

C

MCQ. Hashing technique which allows increase or decrease in number of buckets without a need of directory is classified as

  1. global depth hashing
  2. linear hashing
  3. relative hashing
  4. local depth hashing

B

MCQ. In linear hashing, formula used to calculate number of records if blocking factor, loading factor and file buckets are known is as

  1. r =l + bfr + N
  2. r =l - bfr - N
  3. r =l + bfr - N
  4. r =l * bfr * N

D

MCQ. If global depth is more than local depth then operation must be performed in directory array is

  1. adding
  2. subtracting
  3. halving
  4. doubling

C