Question

In a __________ , we obtain the address of the disk block containing a desired record directly by computing a function on the search key value of the record

(a) Hash file organization

(b) Hash index organization

(c) Hashing address

(d) None of the mentioned

I have been asked this question in an internship interview.

My doubt is from Static Hashing topic in section Indexing and Hashing of RDBMS

Answer 1

The correct option is (a) Hash file organization

The explanation is: Hashing can be used for 2 different purposes, hash file organization and hash index organization. In a Hash file organization, we obtain the address of the disk block containing a desired record directly by computing a function on the search key value of the record.