Indian Institute of Technology Madras
BS Degree Programme · Examination & Study Paper
Database Management Systems
End Term · 13 Apr 2025 (Afternoon)
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.
- Q1MCQ2 Marks·Choose one option
- A
- B
- C
- D
- A
- Q2MCQ2 Marks·Choose one option
- A
- B
- C
- D
- A
- Q3MCQ2 Marks·Choose one option
- A4
- B5
- C6
- D3
- Q4MCQ3 Marks·Choose one option
Consider the following schedule S. S:W1(A), W3(A), W3(C), R2(A), W2(A), W1(B), W3(B) Consider the following statements. Statement 1: The given schedule S is Conflict serializable. Statement 2: All Conflict serializable schedules are 2-P lockable. Statement 3: The given schedule is 2-P lockable. Which of the following options is correct?
- AStatement 1 is true and statement 3 is false
- BStatement 2 is true and statement 3 is false
- CStatements 1 and 2 are true
- DAll these statements are true.
- Q5MCQ3 Marks·Choose one option
- A19
- B20
- C21
- D22
- Q6MCQ3 Marks·Choose one option
- A1-a, 2-d, 3-f
- B1-b, 2-d, 3-e
- C1-a, 2-c, 3-e
- D1-b, 2-c, 3-f
- 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.
- Q8MSQ1 Mark·Choose all correct options
Choose the correct statement(s).
- AIn static hashing, overflow is commonly handled using overflow buckets or chaining.
- BDynamic hashing is suitable for applications where the number of records is unpredictable.
- CStatic hashing is ideal when the dataset size is expected to grow significantly.
- DDynamic hashing ensures that hash table utilization remains balanced as data changes.
- Q9MSQ3 Marks·Choose all correct options
- A
- B
- C
- D
- A
- Q10MSQ2 Marks·Choose all correct options
- A
- B
- C
- D
- A
- Q11MSQ2 Marks·Choose all correct options
Consider the following Entity Relationship Diagram:
Choose the correct statements.- AA bank can provide exactly one ATM machine
- BAn ATM card can be used by multiple customers
- CA customer can use multiple ATM cards
- DAn ATM card can be inserted in many ATM machines
- Q12MSQ2 Marks·Choose all correct options
- A
- B
- C
- D
- A
- Q13NAT3 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: - Q14NAT3 Marks·Write the number
Your answer: - Q15NAT3 Marks·Write the number
Your answer: - Q16NAT3 Marks·Write the number
Your answer: - Q17NAT3 Marks·Write the number
Your answer: - Q18NAT3 Marks·Write the number
Your answer: Read the passage below, then answer Q19–Q20
Q19NAT3 Marks·Write the number
Your answer:- Q20MCQ3 Marks·Choose one option
- A
- B
- C
- D
- A