Question

The file organization which allows us to read records that would satisfy the join condition by using one block read is

(a) Heap file organization

(b) Sequential file organization

(c) Clustering file organization

(d) Hash file organization

This question was addressed to me in examination.

I'd like to ask this question from File Organisations topic in section Storage and File Structures of Database Management

Answer 1

Right option is (c) Clustering file organization

For explanation: All systems in the cluster share a common file structure via NFS, but not all disks are mounted on all other systems.