A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. Consider a join (relation algebra) between relations r(R)and s(S) using the nested loop method. There are 3 buffers each of size equal to disk block size, out of which one buffer is reserved for intermediate results. Assuming size(r(R)) < size(s(S)), the join will have fewer number of disk block accesses if
a. relation r(R) is in the outer loop
b. relation s(S) is in the outer loop
c. join selection factor between r(R) and s(S) is more than 0.5
d. join selection factor between r(R) and s(S) is less than 0.5
Answer:relation r(R) is in the outer loop
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: