Consider seek time of your hard disk read head is 2ms, rotational speed is 30,000 RPM. The disk
has 400 sectors/track and sector size is 128 bytes. What will be the transfer rate (KB/ms)?
A.
75 KB/ms
B.
25 KB/ms
C.
50 KB/ms
D.
100 KB/ms
A published solution is not available for this question yet.
Consider a multilevel index with five levels as L1, L2, L3, L4 and L5. Let L1 be the innermost and L5
be the outermost levels. Let the index blocking factor or the maximum number of entries held by
a block be 25. If the number of blocks in level L1 is 12,50,000, then how many blocks are required
at L2, L3, L4 and L5?
A.
Number of blocks at L2 is 50000,
Number of blocks at L3 is 2000,
Number of blocks at L4 is 80,
Number of blocks at L5 is 4
B.
Number of blocks at L2 is 125000,
Number of blocks at L3 is 2000,
Number of blocks at L4 is 80,
Number of blocks at L5 is 1
C.
Number of blocks at L2 is 50000,
Number of blocks at L3 is 2000,
Number of blocks at L4 is 80,
Number of blocks at L5 is 1
D.
Number of blocks at L2 is 125000,
Number of blocks at L3 is 2500,
Number of blocks at L4 is 80,
Number of blocks at L5 is 4
A published solution is not available for this question yet.
Consider the following statements:
1. Any transactions committed before the last checkpoint should be ignored.
2. Any transaction that was running at the time of failure needs to be redone.
3. It scans backwards from the end of the log to find the most recent < checkpointL > record.
Choose the correct option.
A.
Statements 1 and 2 are correct
B.
Statements 1 and 3 are correct
C.
All the statements are correct
D.
Only Statement 1 is correct
A published solution is not available for this question yet.
Consider a **Block nested loop join** for the two relations, **instructor** and **department**. Assuming
the worst-case memory availability and **instructor** as the outer relation, the provided details are
as follows:
What is the number of blocks in the inner relations?
A published solution is not available for this question yet.