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

DBMS · SQL queries & their output

16 questions · 48 marks · 6 papers

Answer key

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

SQL queries & their output

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.

Quiz 1 · 26 Oct 2025 (AN)Quiz 1

Q1MCQ4 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q2MCQ4 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q3MCQ4 Marks·Choose one option
Key ↓
1. A4 rows and 6 columns
2. B3 rows and 7 columns
3. C4 rows and 5 columns
4. D3 rows and 6 columns
Q4MSQ4 Marks·Choose all correct options
Key ↓
1. A
2. B
3. C
4. D
Q5NAT4 Marks·Write the number
Key ↓
Your answer:
Q6NAT4 Marks·Write the number
Key ↓
Your answer:

End Term · 31 Aug 2025 (FN)End Term

Q7MCQ2 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.
Q8MCQ3 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q9MSQ2 Marks·Choose all correct options
Key ↓
1. A
2. B
3. C
4. D
Q10NAT2 Marks·Write the number
Key ↓
Your answer:

End Term · 13 Apr 2025 (FN)End Term

Q11MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q12MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A1-a, 2-c, 3-f
2. B1-b, 2-c, 3-e
3. C1-a, 2-d, 3-e
4. D1-b, 2-d, 3-f

End Term · 13 Apr 2025 (AN)End Term

Q13MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q14MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A1-a, 2-d, 3-f
2. B1-b, 2-d, 3-e
3. C1-a, 2-c, 3-e
4. D1-b, 2-c, 3-f

End Term · 22 Dec 2024 (FN)End Term

Q15MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. A
2. B
3. C
4. D

End Term · 22 Dec 2024 (AN)End Term

Q16MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. AID and name of students who have not taken any course from Biology department
2. BID and name of students who have taken courses from Biology department
3. CID and name of students who have taken all the courses from Biology department
4. DID and name of students who have not taken courses from other than Biology department

Official Key

Master Answer Key & Explanations

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

Reveal Key

Q1D

Q2A

Q3D

Q4A, C, D

Q54

Q62

Q7D

Q8A

Q9A, C, D

Q103

Q11A

Q12D

Q13D

Q14A

Q15C, D

Q16A

Questions and answer keys are reproduced from the official IIT Madras BS papers. Topics and repeated question types are BTechi’s own grouping. BTechi is not affiliated with IIT Madras.