Midterm 3 Solutions 12

Hence we revised grades to give credit as follows a

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: y and swarm to your office, submitting their information. You add them to the database and the Female table now holds 16,000 records! 18. Which of the following join strategies requires the least I/Os for this scenario? [1 pt] a. page nested loop join with Male as the outer- loop relation b. page nested loop join with Female as the outer- loop relation c. block (chunk) nested loop join with Male as the outer- loop relation d. block (chunk) nested loop join with Female as the outer- loop relation c We want to use the smaller relation as the outer, and block is strictly cooler. 19. What is the total number of I/O’s taken by your chosen strategy in Part 4? Ignore the cost of writing the final join out to disk. [3pt] 31,500. [R] = (12000 records * 1KB/record) / (8 KB/page) = 1,500 pages [S] = (1600...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online