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

MAD I · Models, databases & SQLAlchemy

19 questions · 50 marks · 5 papers

Answer key

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Modern Application Development I

Models, databases & SQLAlchemy

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.
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

Q1MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q2MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A1-c, 2-a, 3-d, 4-b
2. B1-d, 2-c, 3-a, 4-b
3. C1-c, 2-d, 3-b, 4-a
4. D1-c, 2-d, 3-a, 4-b
Read the passage below, then answer Q3–Q4
Based on the above data, answer the given subquestions.
Q3MCQ4.5 Marks·Choose one option
Key ↓
Which of the following statements about the database schema and model relationships is correct?
1. A
2. B
3. C
4. D
Q4MCQ3 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D

End Term · 31 Aug 2025 (AN)End Term

Q5MCQ2 Marks·Choose one option
Key ↓
1. ARiya
2. BName stored in database
3. CNone
4. DError
Q6MCQ2 Marks·Choose one option
Key ↓
What does SQLAlchemy's lazy='dynamic' do?
1. ALoads extra content of all the tables
2. BReturns a query object that can be filtered
3. CLoads all related records immediately
4. DForces join queries at once
Q7MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A
2. B
3. C
4. D

Quiz 2 · 3 Aug 2025 (AN)Quiz 2

Q8MCQ2 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q9MSQ3 Marks·Choose all correct options
Key ↓
Which of the following is/are correct with respect to storing data in graphs?
1. AData on social networks can be stored with the help of graphs.
2. BGraphs support storing attributes such as node degree, edge weights ,and other metadata.
3. CData is stored as a key-value pair.
4. DIn graphs, path finding is not as important as just searching the data.
Read the passage below, then answer Q10–Q11
Q10MSQ4.5 Marks·Choose all correct options
Key ↓
1. A
2. B
3. C
4. D
Q11MSQ3 Marks·Choose all correct options
Key ↓
1. A
2. B
3. C
4. D

End Term · 13 Apr 2025 (FN)End Term

Q12MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. A1-c, 2-a, 3-d, 4-b
2. B1-d, 2-c, 3-a, 4-b
3. C1-c, 2-d, 3-b, 4-a
4. D1-c, 2-d, 3-a, 4-b
Read the passage below, then answer Q13–Q14
A college counseling system is designed to store and retrieve student records efficiently. The system uses different types of storage based on latency, throughput, and density. During peak counseling sessions, thousands of students access their academic records, appointment schedules, and previous counseling notes. The system needs to optimize storage selection for different types of data:
1. Frequently accessed small data (e.g., currently active student records)
2. Large archives of past counseling records (rarely accessed but need long-term storage) 3. Temporary session data that needs to be quickly read and updated during counseling sessions Based on the above data, answer the given subquestions.
Q13MCQ2 Marks·Choose one option
Key ↓
Which of the following storage types should be used for storing frequently accessed small student records that need low latency and high-speed access?
1. AHard Disk Drive (HDD)
2. BSolid State Drive (SSD)
3. CStatic RAM (SRAM)
4. DRegisters
Q14MCQ2 Marks·Choose one option
Key ↓
The college wants to store archived counseling records from past students for future reference. These records are rarely accessed, but cost efficiency and storage density are important. Which storage type is best suited?
1. ARegisters
2. BSRAM
3. CDRAM
4. DHard Disk Drive (HDD)
Read the passage below, then answer Q15–Q16
Q15MSQ3 Marks·Choose all correct options
Key ↓
Which of the following statements is/are True?
1. A
2. B
3. C
4. D
Q16MCQ2 Marks·Choose one option
Key ↓
Which of the following is the correct way of adding records into the ‘student’ and the ‘test_marks’ tables?
1. A
2. B
3. C
4. D

End Term · 22 Dec 2024 (FN)End Term

Q17MCQ2 Marks·Choose one option
Key ↓
1. AMany-to-Many
2. BOne-to-Many
3. COne-to-One
4. DThe tables are not at all related
Q18MCQ2 Marks·Choose one option
Key ↓
Which of the following is a time series database?
1. AMongoDB
2. BInfluxDB
3. CMySQL
4. DPostgreSQL
Q19MSQ2 Marks·Choose all correct options
Key ↓
Which of the following statements is invalid in the context of the primary key?
1. AThe primary key can be null
2. BThe primary key can be auto-incremented
3. CThe primary key allows duplicate values
4. DThe primary key can be referenced by foreign keys in other tables.

Official Key

Master Answer Key & Explanations

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

Reveal Key

Q1B

Q2D

Q3C

Q4D

Q5A

Q6B

Q7C

Q8B

Q9A, B

Q10A, B

Q11A, C

Q12D

Q13C

Q14D

Q15A, B, D

Q16B

Q17D

Q18B

Q19A, C

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.