Question

What is a multitable clustering file organization?

(a) It stores related records of two or more relations in each block

(b) It stores related data about the relations in each block

(c) It links each and every block by introducing an external attribute

(d) None of the mentioned

I got this question during an interview.

Origin of the question is Organization of Records in Files in chapter Storage and File Structure of RDBMS

Answer 1

Correct choice is (a) It stores related records of two or more relations in each block

Best explanation: A multitable clustering file organization stores the related records of two or more relations in each block. This allows us to read records that satisfy a join condition by using one block read.