Introduction to Database Systems Week 9 Quiz Answers Nptel
Are you looking for NPTEL Introduction to Database Systems Week 9 Quiz Answers? You’ve come to the right place! Access the most accurate answers at Progiez.
Table of Contents
Introduction to Database Systems Week 9 Quiz Answers (Jan-Apr 2025)
Course Link: Click Here
1. The unit of data transfer to and from disks is called “block”
a. True
b. False
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
a. True
b. False
3. In the linked allocation of mapping file blocks onto disk blocks, scanning operation is faster compared to the contiguous allocation
a. True
b. False
4. In an RDBMS both fixed-length and variable-length record types can be used
a. True
b. False
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:
a. 3 ms
b. 12 ms
c. 15 ms
d. 30 ms
Introduction to Database Systems Week 9 Quiz Answers
6. The number of data buckets in use after all the records are inserted is:
a. 6
b. 7
c. 8
d. 11
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
a. S1, S2 are both false
b. S1, S2 are both true
c. S1 is true; S2 is false
d. S1 is false; S2 is true
8. The blocking factors for the data file and the index file, respectively, are
a. 11, 101
b. 10, 103
c. 11, 103
d. 10, 102
9. The number of blocks in the first and second level index files, respectively, are:
a. 131072, 1286
b. 13111, 126
c. 13110, 125
d. 12851, 126
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
a. x1 < x2
b. x1 = x2
c. x1 > x2
d. None of the above
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
a. x1 < x2
b. x1 = x2
c. x1 > x2
d. None of the above
For answers to others Nptel courses, please refer to this link: NPTEL Assignment