IIT M DIPLOMA QUIZ2 EXAM QPG1 10 July 2022 IBA - 10 Jul 2022

THIS IS QUESTION PAPER FOR THE SUBJECT "MODERN APPLICATION DEVELOPMENT 1"

ARE YOU SURE YOU HAVE TO WRITE EXAM FOR THIS SUBJECT?
CROSS CHECK YOUR HALL TICKET TO CONFIRM THE SUBJECTS TO BE WRITTEN.

(IF IT IS NOT THE CORRECT SUBJECT, PLS CHECK THE SECTION AT THE TOP FOR THE SUBJECTS REGISTERED BY YOU)

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

@app.route("/<name>/")
def index1(name):
    return "Hi" + " " + name + "!" + " " + "This is your home page."

@app.route("/first_index/<string:name>")
def index2(name):
    if name == "XYZ":
        return redirect(url_for("index1", name = "XYZ"))
    else:
        return redirect( url_for("index3"))

@app.route("/second_index")
def index3():
    return render_template("index.html")

if __name__ == "__main__":
    app.run(debug=True)
```
```html
<!DOCTYPE html>
<html lang="en">
<head>
    <title>My Document</title>
</head>
<body>
    <h2>You are on the incorrect page.</h2>
    <a href="{{ url_for("index1", name="ABC") }}">Go back</a>
</body>
</html>
```

```python
from flask import Flask, jsonify

app = Flask(__name__)

Gadgets = [
    {"tech":"Smartwatch, Digital camera"},
    {"mobile":"Headphones, Speakers"},
    {"Laptop":"Keyboard, Mouse"}
]

@app.route("/home", methods=["GET"])
def func1():
    return jsonify({"The list of gadgets": Gadgets})

@app.route("/")
def rest_lists():
    return {
        "Restaurant 1" : "Hotel Alpine",
        "Restaurant 2" : "Maurya Vihar",
        "Restaurant 3" : "Royal Garden"
    }

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

| Manufacturer | Product | Quantity | Cost |
|---|---|---|---|
| Industry A | Biscuits | 3 | 100 |
| Industry B | Shoes | 2 | 500 |
| Industry A | Chocolate | 10 | 200 |
| Industry C | Pen | 20 | 50 |
| Industry B | Shirts | 5 | 700 |
| Industry D | Beverages | 30 | 150 |
| Industry C | Notebook | 40 | 250 |

What will be the output of the SQL query given below?

```sql
SELECT Manufacturer, COUNT(*)
FROM production
WHERE Quantity>10
GROUP BY Manufacturer
HAVING COUNT(*)=2;
```

| id | first_name | last_name | email |
|---|---|---|---|
| 1 | Ruhil | Verma | verma@gmail.com |
| 2 | Monica | gulati | manisha@gmail.com |
| 3 | Sandeep | Sharma | sharma@gmail.com |
| 4 | Taapsi | Uma | uma@gmail.com |

What will be the output of the flask_sqlalchemy command given below?

```python
>>> user1= Employee.query.filter_by(first_name="Monica").first()
>>> user1.first_name= "Manisha"
>>> db.session.commit()
>>> emp = Employee.query.all()
>>> for emp1 in emp:
...print(first_name)
```

```sql
CREATE TABLE "Items" (
  "ID" INTEGER,
  "name" TEXT,
  "cost" INTEGER,
  PRIMARY KEY("ID" AUTOINCREMENT)
)
```

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

@app.route('/')
def home():
    my_course = ['App1', 'App2', 'python', 'Data science',
                 'Database', 'machine learning']

    return render_template('index.html', list=my_course)

if __name__ == '__main__':
    app.run(debug=True)
```
```html
<html>
<head>
    <title>template file</title>
</head>
<body>
    {% macro display(list) %}
        {% for course in list %}
            <p>{{ course }}</p>
        {% endfor %}
    {% endmacro %}
    {{ display(list) }}
</body>
</html>
```

| | ID | First_Name | Last_Name | Course |
|---|---|---|---|---|
| | Filter | Filter | Filter | Filter |
| 1 | 1 | Raj | R | Java |
| 2 | 2 | Riya | Z | Java |
| 3 | 3 | Sam | sundar | Java |
| 4 | 4 | praneeth | k | Java |
| 5 | 5 | Kunal | T | Python |
| 6 | 6 | vimal | singh | Python |
| 7 | 7 | sethu | J | Python |
| 8 | 8 | liza | G | C++ |
| 9 | 9 | shylla | chopra | C++ |

What will be the output of the following SQL query?

```sql
SELECT Course, count(ID) AS No_Of_Students
FROM table_A GROUP BY Course
ORDER BY No_Of_Students ASC;
```

```html
<!DOCTYPE html>
<html>
<body>

<h2>Creating a Json Object </h2>
<p id="jsonobj"></p>

<script>
const txt = '{"name":"icecream","type":"cup",
"flavor":"vanilla"}'

const obj = JSON.parse(txt);
document.getElementById("jsonobj").innerHTML = obj.name + ", "
+ obj.flavor + ", " + obj.type;
</script>

</body>
</html>
```

Here's the transcription of the visible text:

| ID ▼1 | Name | color |
|---|---|---|
| Filter | Filter | Filter |
| 1 | Jasmine | white |
| 2 | Rose | pink |
| 3 | Lily | pink |
| 4 | Lotus | pink |
| 5 | Red rose | red |

What will be the output of the following SQL query?

```sql
Select count(ID), Name, color from flowers
group by color HAVING count(color)<2;
```

| Parameters          | Storage element |
| :------------------ | :-------------- |
| 1. Highest Latency  | a. HDD          |
| 2. Lowest Density   | b. Register     |
| 3. Lowest Throughput| c. DRAM         |
|                     | d. SSD          |
|                     | e. SRAM         |

```html
<!DOCTYPE html>
<html>
<head>
    <style>
        [id~=out] {
            border: 10px solid red;
        }

        [class~=out]{
            border: 5px solid yellow;
        }
    </style>
</head>
<body>
    <h2>Hello World!</h2>
    <h1 id="out">Hey!</h1>
    <p id="out-text">My name is Fred.</p>
    <p class="outcontent">I am learning to develop
applications.</p>
    <p id ="out"> Are you also willing to learn?</p>
    <p class="out">Welcome to the world of Application
development!</p>
    <h3>Have a nice day!!</h3>
</body>
</html>
```

```python
from pyhtml import *

my_html = html(head(title("Quiz 2")),
               body(h2("Second level heading"),
                    div("This is my first div"),
                    p("Paragraph1"),
                    p("Paragraph2")
                    )
               )

output = my_html.render()
print(output)
```

Consider two software packages A and B. The average processing time of the package A is
TA(n) = 0.001n milliseconds and the average processing time of the package B is TB(n) = 500√n
milliseconds, where n is the number of records being processed. Which of the given software
packages A and B should be chosen to process data collections, containing 10⁸ records?

```python
from flask import Flask
from flask_restful import Resource, Api, reqparse, fields, \
    marshal_with

app = Flask('__main__')
api = Api(app)

parser = reqparse.RequestParser()
parser.add_argument("Id")
parser.add_argument("name")
parser.add_argument("email")

out_fields = {
    "Id": fields.Integer,
    "name": fields.String
}

class MyApi(Resource):
    def get(self):
        info = parser.parse_args()
        return {"Identity": info['Id'] , "Name": info['name'], \
"E-mail": info['email']}

    @marshal_with(out_fields)
    def post(self):
        info = parser.parse_args()
        return info

api.add_resource(MyApi, '/myinfo')

app.run(debug = True)
```
If the application is running locally on the URL: "http://127.0.0.1:5000", What will be the output on the terminal for command:

```bash
curl -X POST -H "Content-Type: application/json" \
    -d "{\"Id\":3, \"name\":\"user_1\", \"email\": \
\"user_1@gmail.com\"}" http://127.0.0.1:5000/myinfo
```