Question 41
Question 46
(a) More than one program may be loaded into main memory at the same time for execution. (b) If a program waits for certain events such as I/O, another program is immediately scheduled for execution. (c) If the execution of program terminates, another program is immediately scheduled for execution.
Question 47
A B+ -tree index is to be built on the Name attribute of the relation STUDENT. Assume that all student names are of length 8 bytes, disk block are size 512 bytes, and index pointers are of size 4 bytes. Given this scenario, what would be the best choice of the degree (i.e. the number of pointers per node) of the B+ -tree?
Question 48
Question 49
A | B | C |
1 | 1 | 1 |
1 | 1 | 0 |
2 | 3 | 2 |
2 | 3 | 2 |
Question 50
In the index allocation scheme of blocks to a file, the maximum possible size of the file depends on :
There are 50 questions to complete.