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 files organization

The question was posed to me during an interview.

Origin of the question is Multiversion Schemes topic in portion Concurrency Control of Database Management

Answer 1

The correct answer is (c) Clustering file organization

To explain: Clustering file organization allows us to read records that would satisfy the join condition by using one block read.