IIT M QUIZ 1 FOUNDATION DAD DIPLOMA QPE3 16 Oct 2022 - 16 Oct 2022

THIS IS QUESTION PAPER FOR THE SUBJECT "DIPLOMA LEVEL: 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)

A certain text document consisting of only alphanumeric characters (including spaces) takes 35,552 bits, when encoded with UCS-4 (32 bit) encoding. How many bits will the same document take if encoded with ASCII 7 bit encoding?
(Concept: Encoding efficiency)

For a certain table "worker" in SQLite database having one of its fields as
"First_name", the correct SQL query to fetch all "First_name" values from "worker" table
using the alias name as "Worker_name" is:
(Concept: basic SQL queries)

Consider the following Python code snippet.

```python
from jinja2 import Template
temp = """{% for num in seq|reject("odd") %}
{{ num+2 }}
{% endfor %}
"""

seq = [6,5,71,13,30,22]
output = Template(temp)
print(output.render(seq = seq))
```

What will be the output if the given code is executed?

Consider the following Python code snippet.
(Concept: Python string and Jinja2 templates)

```python
from string import Template as T1
from jinja2 import Template as T2

info = {'girl1': 'Mary', 'girl2': 'Samantha',
        'girl3': 'girl2', 'girl4': 'girl1',
        'city1': 'Moscow', 'city2':'city1'}

t1 = T1("{{$girl4}} and {{$girl3}} arrived at the {{city2}} station early
and waited for the bus.")

out1 = t1.substitute(info)

out2 = T2(out1)

print(out2.render(info))
```

What will be the output on the terminal?

Consider the code snippets given below.
(Concept: HTML and CSS)

File 1: index.html:

```html
<head>
    <link rel="stylesheet" href="style.css">
</head>
<body>
    <h3>The CSS Box Model</h3>
    <div class="my_border box">
        <h3 class="title">Border</h3>
        <div class="my_padding box">
            <h3 class="title">Padding</h3>
            <div class="my_content box">
                <h3 class="title">Content</h3>
            </div>
        </div>
    </div>
</body>
```

File 2: style.css:

```css
div.my_border {
    background-color: purple;
    border: 2px dotted grey;
    height: 130px;
    width: 130px;
}

div.my_padding {
    background-color: lightblue;
    height: 80px;
    width: 80px;
}

div.my_content {
    background-color: yellow;
    height: 40px;
    width: 45px;
}

.title {
    text-align: left;
    font-size: 10px;
    font-style: italic;
}

.box {
    margin: 10px 20px;
    padding: 0px;
}
```

What will be rendered by the browser, when the above HTML file is loaded?

Consider the following Python code given below.
(Concept: Flask and concepts of HTTP methods)

```python
from flask import Flask, request, url_for

app = Flask(__name__)

@app.route('/dashboard')
def dashboard():
    return 'This is the dashboard'

@app.route('/user/<username>')
def user(username):
    return f'This is {username} profile'

@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        return (url_for('user', username='student_1'))
    else:
        return (url_for('dashboard'))

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

If the above flask application is running on URL “http://127.0.0.1:5000”, which of the following is the correct output if a user visits the URL “http://127.0.0.1:5000/login”, using a browser?

Consider the following HTML code below.

```html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8"/>
<style>
body{text-align: center;}
p{font-size: 30px;font-style: italic;color: black;}
.blue{color: red;}
.red{color: green;}
.green{color: blue;}
#myId{color: grey;}
</style>
</head>
<body>
<div>
<h2 class="red">Happy Coding</h2>
<p class="blue">1st class</p>
<p class="red" id="myId">2nd class</p>
<p class="green">3rd class </p>
</div>
</body>
```

How will the browser render the above HTML file?
Match the rendered colour for the text.

| | | |
|---|---|---|
| 1. | Happy Coding | a. green |
| 2. | 1st Class | b. blue |
| 3. | 2nd Class | c. red |
| 4. | 3rd Class | d. grey |

Consider the following tables.

User Table:

| Id | Name  | Age |
|----|-------|-----|
| 1  | Mala  | 50  |
| 2  | Kala  | 30  |
| 3  | Saamy | 25  |
| 4  | Ramya | 30  |

Book Table:

| Id | Bookname      | Username |
|----|---------------|----------|
| 1  | Python        | Saamy    |
| 2  | Java          | Kala     |
| 3  | C             | Mala     |
| 4  | Modern App    | Ramya    |

If the above tables are given as inputs, what will be the output of the following query?

```sql
SELECT u.Name, b.Bookname FROM User as u, Book as b WHERE b.Username = u.Name
```

Find the correct match with respect to MVC Software design pattern.

| | Action | | Component |
|---|---|---|---|
| 1 | Defining business logic | A | View |
| 2 | Display the data to user | B | Model |
| 3 | Databases, indexing for easy searching | C | Controller |
| 4 | User interfaces for finding information | | |
| 5 | Stores core data for the application | | |

Consider the below HTML and CSS styling.

```html
<html>
  <head>
    <style>
      h3 {
        color: red;
      }
      .content {
        color: green;
      }
    </style>
  </head>
  <body>
    <h3 class = "content">This is the main Content</h3>
    <button onclick = "remove_class"> Click Me </button>
  </body>
</html>
```

Assuming clicking the button with the text "Click Me" removes the class "content" from the "h3" element, what will be the text colour of the text placed inside the "h3" element, before and after clicking the button with the text "Click Me" (Assume a normal browser is used which shows black text on white background)?

A Server S needs to retrieve data from two datacenters D1 and D2 located at 1800 kilometres and 2400 kilometres respectively. Server S and D1 are connected via medium M1 through which information can be transferred with the speed of 1.5 × 10⁸ m/sec, and server S and D2 are connected via medium M2. If the server received data from both the data centres at the same time, what must be the speed of information transfer in medium M2?

(Concept: Performance parameters of a network)

Consider the following code for flask application.

**main.py:**

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

@app.route('/viewdata/')
def student_list():
    student_data={
        'rollno': [1001,1002,1003,1004,1005],
        'name': ['Amit','Ravi','Karthik','Ankur','Ishan'],
        'course':['Python','MAD1','MAD2','DBMS','MAD2']
    }
    return render_template("viewlist.html",st = student_data)

if __name__ == '__main__':
    app.run()
```

**viewlist.html:**

```html
<!DOCTYPE html>
<html lang="en">

<head>
    <title>Document</title>
    <style>
        table,
        th,
        td {
            border: 1px solid black;
        }
    </style>
</head>

<body>
    <table>
        <tr>
            <th>Sno</th>
            <th>Roll No</th>
            <th>Name</th>
            <th>Course</th>
        </tr>
        <!-- missing code block -->
        HTML code block
        <!-- missing code block -->
    </table>
</body>

</html>
```

Suppose we want to display the student_data in the following table format for route "http://127.0.0.1:5000/viewdata/":

| Sno | Roll No | Name    | Course |
| --- | ------- | ------- | -------- |
| 1   | 1001    | Amit    | Python   |
| 2   | 1002    | Ravi    | MAD1     |
| 3   | 1003    | Karthik | MAD2     |
| 4   | 1004    | Ankur   | DBMS     |
| 5   | 1005    | Ishan   | MAD2     |

Select the correct option to fill at the place of **HTML code block** in viewlist.html file to display the data in the above given table format without any error?

Which of the following statement(s) is/are true regarding HTML and encodings?
Concepts Covered: Encoding Standards, HTML & CSS

Which of the following option(s) will generate the HTML code equivalent to the below HTML code?
[Concepts covered: Programmatic HTML generation]

```html
<!DOCTYPE html>
<html>
<head>
    <title>My title</title>
</head>
<body>
    <div>
        <div>
            <h2>inside title</h2>
        </div>
        <p>some text in a paragraph</p>
    </div>
</body>
</html>
```

Consider the below table student:
(Concept: SQL INNER JOIN)

student

| Rollno | Name  | Grade |
| :----- | :---- | :---- |
| CE01   | Anil  | A     |
| CE02   | Sunil | B     |
| EE01   | Kapil | B     |
| EE02   | Anil  | C     |
| EE03   | Adil  | D     |

How many tuples are retrieved by the below SQL query?

Note: The answer must be an integer.

```sql
SELECT *
FROM (SELECT Rollno, Name FROM student) AS A INNER JOIN
(SELECT Name, Grade FROM student) AS B on A.Name = B.Name;
```

Which of the following statement
is/are always true for the given
instance of the relational tables?

What **S_Id**(s) is/are returned by the
following SQL query for the **given**
instance of the relational tables?

```sql
select R.S_Id from Student S join Result R on S.S_Id=R.S_id join
Course C on R.C_Id=C.C_Id where R.Marks>70 and S.City='Chennai' and
C.Course_name='MAD1'
```