NPTEL Introduction to Database Systems Week 9 Assignment Answers 2025
1. The unit of data transfer to and from disks is called “block”
- True
- False
Answer :- For Answers Click Here
2. If record length is much less than the block size and unspanned organization is used, then blocking factor of data file is ceil(B/r), where B is block size and r is record length
- True
- False
Answer :-
3. In the linked allocation of mapping file blocks onto disk blocks, scanning operation is faster compared to the contiguous allocation
- True
- False
Answer :-
4. In an RDBMS both fixed-length and variable-length record types can be used
- True
- False
Answer :-
5. Consider the following parameters of a hard disk: seek time: 12ms, rotational delay: 3ms. Suppose the read/write head of the disk is positioned on block 0 of track 20, then the maximum time taken for the head to move to block 10 on the same track is:
- 3 ms
- 12 ms
- 15 ms
- 30 ms
Answer :-
6. The number of data buckets in use after all the records are inserted is:
- 6
- 7
- 8
- 11
Answer :- For Answers Click Here
7. Choose the correct option for the following statements about the final file structure, after the insertion of all the records.
S1. The global depth value is 3 S2. The local depth values of all the data buckets except one is same
- S1, S2 are both false
- S1, S2 are both true
- S1 is true; S2 is false
- S1 is false; S2 is true
Answer :-
8. The blocking factors for the data file and the index file, respectively, are
- 11, 101
- 10, 103
- 11, 103
- 10, 102
Answer :-
9. The number of blocks in the first and second level index files, respectively, are:
- 131072, 1286
- 13111, 126
- 13110, 125
- 12851, 126
Answer :-
10. Let the number of blocks in the level-1 indexes of L1 and L2 be x1 and x2, respectively. The relationship between x1 and x2 is
- x1 < x2
- x1 = x2
- x1 > x2
- None of the above
Answer :-
11. Let the number of blocks in level-2 indexes of L1 and L2 be x1 and x2, respectively. The relation between x1 and x2 is
- x1 < x2
- x1 = x2
- x1 > x2
- None of the above
Answer :- For Answers Click Here
