← Quiz: File Organization and Hashing: all 9 questions
Quiz: File Organization and Hashing · Question 2 of 9
Which file organization is best for WHERE roll = 1042 but useless for WHERE marks BETWEEN 60 AND 70?
Which file organization is best for WHERE roll = 1042 but useless for WHERE marks BETWEEN 60 AND 70?
- A.Sequential (sorted on marks)
- B.Heap
- C.B+ tree
- D.Hash file on the searched column
Answer & explanation
Correct answer: Hash file on the searched column
Hashing spreads neighbouring values across buckets, so ranges cannot use it.
Can you get the rest right without peeking?
Take the timed Quiz: File Organization and Hashing quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →