244 views
0 votes
0 votes

Two relations A and B are stored as clustered sequential files on disk. Each block on disk can hold 100 records of either A or B. The relation A contains 1000 records and B contains 500 records. There is a memory buffer to hold only 1 block of each relation. The number of block transfers required to complete a nested loop join operation on these two tables is at least (in integer) _________.

Please log in or register to answer this question.

Related questions

655
views
3 answers
0 votes
amit166 asked Jun 30, 2023
655 views
How many helloWorld lines are printed by the program:#include <stdio.h>#include <stdlib.h> void myFunc(){ if (fork() == 0){ fork(); printf( helloWorld\n ); ... main(){ printf( helloWorld\n ); myFunc(); printf( helloWorld\n ); return 1;}
571
views
5 answers
0 votes
amit166 asked Jun 30, 2023
571 views
Select the function(s) which is/are $O(n log n)$:$2n\log n+3n$10n\log n^2$1+\sqrt n$2n^2-3n$