Indian Institute of Technology Madras
BS Degree Programme · Examination & Study Paper
Modern Application Development I
End Term · 22 Dec 2024 (Forenoon)
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

- AMany-to-Many
- BOne-to-Many
- COne-to-One
- DThe tables are not at all related
- Q2MCQ2 Marks·Choose one option

- A

- B

- C

- D

- A
- Q3MCQ2 Marks·Choose one option

- A

- B

- C

- D

- A
- Q4MCQ2 Marks·Choose one option
Which of the following is a time series database?
- AMongoDB
- BInfluxDB
- CMySQL
- DPostgreSQL
- Q5MCQ2 Marks·Choose one option
Match the platforms given in column A with their correct features in column B.

- A1 - A, 2 - B, 3 - C, 4 - D
- B1 - D, 2 - A, 3 - B, 4 - C
- C1 - B, 2 - D, 3 - A, 4 - C
- D1 - A, 2 - C, 3 - D, 4 - B
- Q6MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
- Q7MCQ3 Marks·Choose one option

- A1.35
- B2.7
- C3.15
- D5.4
- Q8MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
- Q9MCQ3 Marks·Choose one option
Consider the following HTML document.

- A

- B

- C

- D

- A
- Q10MCQ3 Marks·Choose one option
Match the following terms with their correct descriptions:

- AA → 2, B → 4, C → 1, D → 3, E → 5
- BA → 3, B → 4, C → 1, D → 2, E → 5
- CA → 2, B → 4, C → 5, D → 3, E → 1
- DA → 3, B → 4, C → 5, D → 2, E → 1
- Q11MCQ3 Marks·Choose one option
Which of the following is an example of an application using Attribute-Based Access Control (ABAC)?
- AA system where users are granted access based on their job roles within an organization.
- BA cloud service that grants or restricts access to files based on attributes such as user department, job title, or current location.
- CA file-sharing system where the file owner decides who can access their documents.
- DA system that enforces access based on security classifications and clearance levels.
- Q12MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
- Q13MCQ3 Marks·Choose one option

- A

- B

- C

- D

- A
- Q14MCQ4.5 Marks·Choose one option

- A

- B

- C

- D

- A
- Q15MCQ4.5 Marks·Choose one option
Consider the following HTML document.
How will the browser render above HTML file?- A

- B

- C

- D

- A
- Q16MCQ4.5 Marks·Choose one option

- A

- B

- C

- D

- A
- Q17MCQ4.5 Marks·Choose one option

- A

- B

- C

- D

- A
- Q18MSQ4.5 Marks·Choose all correct options

- A

- B

- C

- D

- A
- Q19MSQ3 Marks·Choose all correct options
Consider the following code snippet.

- A

- B

- C

- D

- A
- Q20MSQ3 Marks·Choose all correct options
Consider the following flask application running on the base URL and is accessed through a browser. Select the correct option(s).

- A

- B

- C

- D

- A
- Q21MSQ3 Marks·Choose all correct options
Consider the following Python code snippet.

- A

- B

- C

- D

- E

- A
- Q22MSQ3 Marks·Choose all correct options
Which of the following statements about the Constraint Validation API is/are true?
- AThe Constraint Validation API ensures that form input meets client-side validation rules before submission.
- BThe Constraint Validation API is sufficient to prevent server-side attacks like SQL injection.
- CIt is possible to bypass the Constraint Validation API by directly sending requests to the server.
- DThe Constraint Validation API automatically validates all data on the server side.
- Q23MSQ2 Marks·Choose all correct options
Which of the following statements is invalid in the context of the primary key?
- AThe primary key can be null
- BThe primary key can be auto-incremented
- CThe primary key allows duplicate values
- DThe primary key can be referenced by foreign keys in other tables.
- Q24MSQ2 Marks·Choose all correct options
Consider the following HTML document.
Which of the following statements is/are correct about the above code snippet?- AList Items, Foundations and Diploma are numbered 1 and 2
- BList Items, Foundations and Diploma are bulleted
- CList Items, PDSA, MAD-I and MAD-II are numbered 1, 2 and 3
- DList Items, PDSA, MAD-I and MAD-II are bulleted
- Q25NAT3 Marks·Write the number
Your answer: - Q26NAT3 Marks·Write the number
Your answer: Read the passage below, then answer Q27–Q28

Based on the above data, answer the given subquestions.
Q27MCQ3 Marks·Choose one option
- A

- B

- C

- D

- A
- Q28MCQ2 Marks·Choose one option

- A

- B

- C

- D

- A
Read the passage below, then answer Q29–Q30
Q29MCQ4.5 Marks·Choose one option
- A

- B

- C

- D

- A
- Q30MCQ4.5 Marks·Choose one option

- A

- B

- C

- D

- A
Read the passage below, then answer Q31–Q32
Use the Python code given below for answering the subquestions:
Q31MCQ4.5 Marks·Choose one option
- A

- B

- C

- D

- A
- Q32MCQ3 Marks·Choose one option

- A201
- B404
- C500
- DNone of these