Indian Institute of Technology Madras
BS Degree Programme · Examination & Study Paper
Database Management Systems
SQL DDL, constraints & app development
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
- Q1MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
- Q2MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
Read the passage below, then answer Q3–Q4
Q3MSQ4 Marks·Choose all correct options
- Aa → b → c
- Bb → a → c
- Cb → c → a
- Dc → b → a
- Q4MSQ4 Marks·Choose all correct options
Which of the following SQL queries is/are used to create table Teams?
- A

- B

- C

- D

- A
Quiz 2 · 3 Aug 2025 (AN)Quiz 2
- Q5MCQ4 Marks·Choose one option

- A1
- B4
- C6
- D5
- Q6MSQ2 Marks·Choose all correct options

- A

- B

- C

- D

- A
End Term · 13 Apr 2025 (FN)End Term
Read the passage below, then answer Q7–Q8
Q7NAT3 Marks·Write the number
Your answer:- Q8MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
End Term · 13 Apr 2025 (AN)End Term
Read the passage below, then answer Q9–Q10
Q9NAT3 Marks·Write the number
Your answer:- Q10MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
End Term · 22 Dec 2024 (FN)End Term
- Q11MSQ3 Marks·Choose all correct options

- A

- B

- C

- D

- A
End Term · 22 Dec 2024 (AN)End Term
- Q12MSQ3 Marks·Choose all correct options

- A

- B

- C

- D

- A