GATEverse
← GATE IT 2005

Q82b

MCQMarks unknown

A database table T1T_1 has 20002000 records and occupies 8080 disk blocks. Another table T2T_2 has 400400 records and occupies 2020 disk blocks. These two tables have to be joined as per a specified join condition that needs to be evaluated for every pair of records from these two tables. The memory buffer space available can hold exactly one block of records for T1T_1 and one block of records for T2T_2 simultaneously at any point in time. No index is available on either table. If, instead of Nested-loop join, Block nested-loop join is used, again with the most appropriate choice of table in the outer loop, the reduction in number of block accesses required for reading the data will be

Sign in to save attempts.

Loading…