BTechibtechi.in
Loading Loading
Free IIT Madras BS notes, PYQs and mock tests at btechi.in

DBMS · End Term · 31 Aug 2025 (Forenoon)

20 questions · 50 marks · 90 min

Answer key Take as mock

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

End Term · 31 Aug 2025 (Forenoon)

Official Paper

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
Key ↓
1. ANames of all the mentors with ‘GOOD’ rating from at least one of their mentees.
2. BNames of all the mentors with ’GOOD’ rating from all their mentees.
3. CNames of all the mentors with ‘BAD’ rating from at most one of their mentees.
4. DNames of all the mentors with ’BAD’ rating from all their mentees.
Q2MCQ2 Marks·Choose one option
Asked 3 times Key ↓
Consider a non-empty B+-tree of order 17. What are the maximum and minimum number of keys that can be placed in the root node?
1. Amax. number of keys = 16, min. number of keys = 1.
2. Bmax. number of keys = 17, min. number of keys = 1.
3. Cmax. number of keys = 16, min. number of keys = 8.
4. Dmax. number of keys = 17, min. number of keys = 8.
Q3MCQ3 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q4MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A2
2. B0
3. C1
4. D5
Q5MCQ3 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q6MSQ3 Marks·Choose all correct options
Asked 3 times Key ↓
1. ASchedule S can not be two-phase lockable.
2. BSchedule S can be two-phase lockable.
3. CSchedule S can be strict two-phase lockable.
4. DSchedule S is conflict serializable.
Q7MSQ3 Marks·Choose all correct options
Asked 3 times Key ↓
1. AT0 and T1 can be ignored.
2. BT0,T1, T2 and T3 can be ignored.
3. CT4 need to be undone.
4. DT0 and T3 need to be redone.
Q8MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. A(0,1,2,7,8)
2. B(0,5,2,3,4)
3. C(0,5,6,3,8)
4. D(0,5,2,7,4)
Q9MSQ3 Marks·Choose all correct options
Asked 4 times Key ↓
1. A
2. B
3. C
4. D
Q10MSQ2 Marks·Choose all correct options
Asked 5 times Key ↓
1. A
2. B
3. C
4. D
Q11MSQ2 Marks·Choose all correct options
Asked 3 times Key ↓
1. A
2. B
3. C
4. D
Q12MSQ2 Marks·Choose all correct options
Key ↓
1. A
2. B
3. C
4. D
Q13MSQ2 Marks·Choose all correct options
Key ↓
1. ANumber of block transfers require=300600
2. BNumber of block transfers require=300500
3. CNumber of seeks require=1200
4. DNumber of seeks require=1400
Q14MSQ2 Marks·Choose all correct options
Asked 5 times Key ↓
1. A
2. B
3. C
4. D
Q15NAT2 Marks·Write the number
Key ↓
Your answer:
Q16NAT2 Marks·Write the number
Key ↓
Your answer:
Q17NAT2 Marks·Write the number
Asked 5 times Key ↓
Your answer:
Q18NAT3 Marks·Write the number
Key ↓
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:
Q19NAT3 Marks·Write the number
Key ↓
Your answer:
Q20NAT3 Marks·Write the number
Asked 3 times Key ↓
Your answer:

Official Key

Master Answer Key & Explanations

Official answer keys from IIT Madras BS past papers. Click any question to review.

Reveal Key

Q1D

Q2A

Q3A

Q4C

Q5C

Q6A, C

Q7A, C

Q8B, C, D

Q9A, B, C

Q10A, B, D

Q11A, D

Q12A, C, D

Q13A, C

Q14D

Q153

Q165

Q174

Q1832

Q196

Q208

Questions and answer keys are reproduced from the official IIT Madras BS papers. BTechi is not affiliated with IIT Madras.