Indian Institute of Technology Madras
BS Degree Programme · Examination & Study Paper
Database Management Systems
Storage: disks, RAID & buffers
Examination Instructions & Guidelines
- Solve on notebook/paper first before checking solutions.
- MCQ: Exactly 1 option is correct. Negative marking applies.
- MSQ: One or more options correct. Select all to score.
- NAT: Numerical response. No negative marking.
- Scientific calculator allowed for all calculations.
- Official answer key is sealed at the end of this sheet.
End Term · 31 Aug 2025 (FN)End Term
- Q1NAT3 Marks·Write the number
Consider a magnetic disk with 16 platters, 2 surfaces per platter, 1024 tracks per surface, 2048 sectors per track and 512 bytes per sector. The disk rotates at 6000 rpm. What is the disk capacity (in GB)?
Your answer:
Quiz 2 · 3 Aug 2025 (AN)Quiz 2
- Q2MCQ4 Marks·Choose one option

- A8
- B9
- C10
- D11
- Q3MSQ2 Marks·Choose all correct options
Identify the correct statement(s):
- ABinary search has a time complexity of O(log n). where n is number of elements.
- BIn a linked list the data elements are required to be stored in contiguous memory locations
- CMain memory is the fastest and most costly form of storage
- DA sector is the smallest unit of data read or written on a Magnetic Disk for every read operation.
- Q4MSQ3 Marks·Choose all correct options

- AQuery 1 will execute more efficiently when multitable clustering file organization scheme is used.
- BBoth the queries will execute more efficiently when sequential clustering file organization scheme is used.
- CQuery 2 will execute more efficiently when sequential clustering file organization scheme is used.
- DQuery 1 will execute more efficiently when sequential clustering file organization scheme is used.
End Term · 13 Apr 2025 (FN)End Term
- Q5NAT3 Marks·Write the number
Consider you have a file in your hard disk of size 1000 KB. Seek time of your hard disk read head is 3ms and rotational speed in 30,000 rpm. The disk has 200 sectors per track and 512 bytes per sector. Considering the fact that the file data is stored in non consecutive sectors. How much time will be required to read the whole file after a read request is made? (in ms)
Your answer: - Q6NAT3 Marks·Write the number
Consider a system using the Least Recently Used (LRU) page replacement policy. The system has a main memory buffer with 4 slots, and the page reference sequence is as follows: 3, 4, 1, 4, 2, 3, 1, 4, 2, 3 Calculate the total number of page misses (page faults) during this sequence.
Your answer:
End Term · 13 Apr 2025 (AN)End Term
- Q7MCQ1 Mark·Choose one option
Consider the following statements and select the correct option. 1. RAID 1 employs mirroring, maintaining two identical copies of the data on two different disks 2. RAID 3 has a single check disk with parity information.
- ABoth the statements are correct.
- BBoth the statements are wrong.
- CStatement 1 is correct and statement 2 is wrong.
- DStatement 1 is wrong and statement 2 is correct.
- Q8NAT3 Marks·Write the number
Consider you have a file in your hard disk of size 1024 KB. The seek time of your hard disk read head is 4 ms, and the rotational speed is 30,000 rpm. The disk has 256 sectors per track, and each sector stores 512 bytes. Considering that the file data is stored in non-consecutive sectors, how much time will be required to read the whole file after a read request is made (in ms)?
Your answer: - Q9NAT3 Marks·Write the number
Your answer:
End Term · 22 Dec 2024 (FN)End Term
- Q10MCQ2 Marks·Choose one option

- A

- B

- C

- D

- A
- Q11MCQ2 Marks·Choose one option
Consider seek time of your hard disk read head is 2ms, rotational speed is 60,000 RPM. The disk has 300 sectors/track and sector size is 256 bytes. What will be the transfer rate (KB/ms)?
- A75 KB/ms
- B25 KB/ms
- C50 KB/ms
- D100 KB/ms
End Term · 22 Dec 2024 (AN)End Term
- Q12MCQ2 Marks·Choose one option

- A

- B

- C

- D

- A
- Q13MCQ2 Marks·Choose one option
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)?
- A75 KB/ms
- B25 KB/ms
- C50 KB/ms
- D100 KB/ms