IIT M DIPLOMA AN EXAM QDD4 16 Mar - 16 Mar 2025

IIT Madras runs a **BS Degree Program in Data Science & AI**, which has thousands of students enrolled across multiple levels (Foundational, Diploma, and Degree). The institution needs a database system to manage:

* Student enrollments, tracking performance across multiple subjects and semesters.
* Faculty assignments to courses, ensuring each instructor handles only specific subjects.
* Course prerequisites (e.g., a student must complete Mad1 before Mad2).
* Secure storage of student grades and transcripts, ensuring only authorized access.
* Handling transactions such as course enrollments, fee payments, and refunds.

Considering the above requirements, which type of database system is **most appropriate**?

Match the following:

| | | | |
|---|---|---|---|
| 1 | GET, POST, PUT, DELETE | a | a set of standards for addressing and routing data on the Internet |
| 2 | Client-Server Model | b | MVC |
| 3 | Software Architecture Pattern | c | HTTP request method |
| 4 | Internet Protocol | d | Explicit differentiation between clients and servers |

Consider the following Python code snippet.

```python
def update(func):
    def wrapper(N):
        out = []
        for i in range(N):
            if i%2 == 0:
                out.append(i**3)
            else:
                out.append(i**2)
        return out
    return wrapper

@update
def func(N):
    if N%2 == 0:
        return N**2
    else:
        return N**3

print(func(5))
```

What will be the output of the above code in the terminal?

Consider the HTML code given below:

File name: base_layout.html

```html
<!DOCTYPE html>
<html lang="en">
<head>
    <title>ABC App</title>
</head>
<body>
    <h3>Welcome to ABC App</h3>
    {% block abc %}{% endblock %}
</body>
</html>
```

Which of the following is the correct implementation of template inheritance?

Consider the following Flask code.

```python
from flask import Flask, request

app = Flask(__name__)

def is_odd(e):
    return e % 2 == 0

@app.route("/response")
def get_response():
    if request.args.get("n"):
        n = request.args.get("n")
        r = ""
        for i in range(1, (int(n) + 1)):
            if is_odd(i):
                r = r + "odd : " + str(i) + "\n"
            else:
                r = r + "even : " + str(i) + "\n"
        return r
    else:
        return "missing parameter `n` with value"

if __name__ == "__main__":
    app.run(debug=True)
```

Assume the above code is running on http://127.0.0.1:5000 . Which of the following
request URL does not throw Not Found error?

Consider the following Flask Restful API code:

```python
from flask import Flask
from flask_restful import Resource, Api

app = Flask(__name__)
api = Api(app)

class my_resource1(Resource):
    def get(self):
        return {"output": "Default computed value : 0"}, 200

class my_resource2(Resource):
    def get(self, x, y):
        c = x**y
        return f"output": "Computed x^y = " + str(c)}, 200

api.add_resource(my_resource1, "/")
api.add_resource(my_resource2, "/<int:x>/<int:y>")

if __name__ == "__main__":
    app.run(debug=True)
```

Assume that the above code is running on "http://127.0.0.1:5000".

| request URL | rendered output |
|---|---|
| 1) http://127.0.0.1:5000/ | i) {"output": "Computed x^y =36"} |
| 2) http://127.0.0.1:5000/x=6/y=2 | ii) {"output": "Default computed value : 0"} |
| 3) http://127.0.0.1:5000/6/2 | iii) Not Found |
| 4) http://127.0.0.1:5000/6 | iv) {"output": "Default computed value : 6"} |
| 5) http://127.0.0.1:5000/2 | v) {"output": "Default computed value : 2"} |

Based on the above table, choose the correct matching?

Consider the table "students" given below. The model class "Student" corresponds to the table "students" in the SQLite database.

Table: students

| ID | First_name | Last_name | Email             |
|----|------------|-----------|-------------------|
| 1  | Arjun      | Kumar     | arjun@example.com |
| 2  | Karthik    | Kumar     | karthik@example.com |
| 3  | Pranav     | Kumar     | pranav@example.com |
| 4  | Surya      |           | surya@example.com |
| 5  | Harish     | Vignesh   | harisj@example.com |
| 6  | Karthik    | Ramesh    | ramesh@example.com |
| 7  | Karthik    | Kumar     | kumar@example.com |

What will be the output of the following Flask-SQLAlchemy commands?

```python
student1 = Student.query.filter_by(First_name="Karthik").first()
student1.First_name = "Vikram"
db.session.commit()
students_list = Student.query.all()
for student in students_list:
    print(student.First_name, student.Last_name)
```

Consider the flask code below.

```python
from flask import Flask

app = Flask(__name__)

@app.route("/user/<id>")
def get_user(id):
    return "User Id : " + str(id)

if __name__ == "__main__":
    app.run(debug=True)
```

Assume that the above flask application is running on http://127.0.0.1:5000 . Which of the following URLs will render "Not Found" error?

Consider the following flask application running locally on http://127.0.0.1:5000.

```python
from flask import Flask, request

app = Flask(__name__)

@app.route('/endpoint/<username>')
def func(username):
    return {
        "username": username
    }, 200

@app.errorhandler(404)
def notfound(error):
    return {
        "message": "invalid endpoint!"
    }

app.run(debug = True)
```

Which of the following statements is/are correct for the URL:
http://127.0.0.1:5000/endpoint/user1/developer

Consider the following Salesman table/model and answer the following question.
Table/model name: Salesman

| sid | name    | sales_amount |
| :-- | :------ | :----------- |
| 101 | Ram     | 7800         |
| 102 | Rahim   | 4560         |
| 103 | Krishna | 8900         |
| 104 | David   | 12300        |
| 105 | Kittu   | 16700        |

Which of the following Flask SQLAlchemy code will retrieve Salesman data, where **sales_amount** is between 5000 and 10000(both inclusive)?

Consider the following Flask application:

```python
from flask import Flask

app = Flask(__name__)

@app.route('/')
def home():
    return "Welcome to Home Page"

@app.route('/user/<name>')
def user(name):
    return f"Hello, {name}!"

@app.route('/profile/<int:user_id>')
def profile(user_id):
    return f"User Profile ID: {user_id}"

if __name__ == "__main__":
    app.run(debug=True)
```

Assume the Flask application is running on http://127.0.0.1:5000/. Which of the following statements about this application are **correct**?

Consider the following Flask-RESTful API implementation:

```python
from flask import Flask, request
from flask_restful import Resource, Api

app = Flask(__name__)
api = Api(app)

students = {
    1: {"name": "Arjun", "grade": "A"},
    2: {"name": "Kiran", "grade": "B+"},
    3: {"name": "Meera", "grade": "A"},
}

class Student(Resource):
    def get(self, student_id):
        if student_id in students:
            return students[student_id], 200
        return {"message": "Student not found"}, 404

    def put(self, student_id):
        data = request.json
        if student_id in students:
            students[student_id]["grade"] = data.get("grade",
                                                    students[student_id]["grade"])
            return {"message": "Student record updated", "student":
                    students[student_id]}, 200
        return {"message": "Student not found"}, 404

api.add_resource(Student, "/student/<int:student_id>")

if __name__ == "__main__":
    app.run(debug=True)
```

The API is running on http://127.0.0.1:5000/. Which of the following statements about this API's behavior is correct?

Consider the following flask application.
app.py

```python
from flask import Flask, render_template, url_for
app = Flask(__name__)

@app.route("/if")
def ifelse():
    user = "MAD I"
    return f" Welcome {user}!"

@app.route("/for")
def for_loop():
    user = "MAD II"
    return f" Welcome {user}!"

@app.route("/choice/<pick>")
def choice(pick):
    if pick == 'if':
        return url_for('ifelse')
    if pick == 'for':
        return (url_for('for_loop'))

if __name__ == "__main__":
    app.run(debug=False)
```

Which of the following statements is/are true if the application is running locally on
http://127.0.0.1:5000 ?