Question 13 Suppose that the Sailor table has 50 tuples (or records) stored in 5 disk blocks and the Reserve table has 5,000 tuples (or records) stored in 500 disk blocks. Let S be Student and let R...

Extracted text: Question 13 Suppose that the Sailor table has 50 tuples (or records) stored in 5 disk blocks and the Reserve table has 5,000 tuples (or records) stored in 500 disk blocks. Let S be Student and let R be Reserve. The following information is provided for access paths: • 7 buffer caches (pages) are available. • The Student table has the secondary index on sid with index level =1 • The Reserve table has the secondary index on sid with index level =2. • Each Student tuple matches with exactly 100 Reserve tuples Consider the join R \R.sid = S.sid S. Which one is the IO cost when using Block nested loop join? 1,000 505 None of the above 5,105 10,500