Proctor Level2_132

Student reviews

Ashutosh MAD1 Aug 16, 2026

For Level 1, Focus on Flask basics, CRUD, MVC, POST vs PUT, checksum, and your project flow. Practice writing the register route and flash message code by hand, as code-writing questions are common.

Questions remembered

Asked me to explain the checksum and verify the project checksum.
Asked about CRUD operations (Create, Read, Update, Delete).
Asked me to run and demonstrate the project (show the webpages and functionality).
Asked What is MVC? and explain MVC with my project.
Asked the difference between POST and PUT.
Asked me to write the frontend code to display Flask flash messages in Notepad.
Asked me to write the Flask registration route (/register) in Notepad.

Neha Gawande MAD1 Aug 16, 2026

Procter ask same things to all ,she came late and she supports you.

Questions remembered

She will asked to login as admin,create trek ,create staff,create user..... do what she says
She checked if admin has blacklisted user then whether that admin will able to book a trek or not.
Change code if approved staff is greater than 5 then don't allow new staff registration unless some staff is blacklisted (changes in code)
Write form taking input as username and password (in nodepad)
Diff between post and put
What if in put method there is no resources to replace
What is orm 8.what is MVC

Dharmendrra MAD1 Aug 16, 2026

She was chill. Do charts questions, she will definitely ask. Be honest if you don't know the answer.

Questions remembered

LEVEL-1
Mam came 10 mins late.
Asked to download project and run the application without checksum.
Show Github
Demonstrate the project with all the functionalities.
Flask route to search a trekker using their name(it should be GET but I wrote POST)
She asked to change the colour of the charts.
Which ORM is used in the application.
How many tables you have created.

Sabuj MAD1 Aug 16, 2026

she seems patient and if you dont know something then just tell her
i also got error on 4 so maam just moved on and asked other questions

Questions remembered

show id
asked for checksum but i said im downloading directly from the portal
open GitHub to show your repository and check if mad1 is added as collaborator
asked to start giving the demo of my project then started the viva questions when i just started and was on landing page
(question are out of order i wrote them as I remembered them)
1.What is orm?
2.authentication vs authorization
3.create a trek
4.modify so that if a trek is open admin cant create new treks
5.Create a staff
6.create a trekker
7.checking if staff needs approval
8.blacklist user and try to login as user
9.search for a user in admin page
10.assign staff to trek
11.change status of trek to completed from staff side and then check if it is updated on user and admin side
12.put vs post
13.write the html for a table to display name and roll no.
Im missing one question on which i said i dont know. i dont remember that question

Sheet response MAD1 Aug 16, 2026

Shared viva questions from response sheet: Do some modification in code so that if company have a one active place when drive he cannot create another drive; Create flask app and write a function so that it show all the unapprove drive; What is rest full and restless API

Questions remembered

Do some modification in code so that if company have a one active place when drive he cannot create another drive
Create flask app and write a function so that it show all the unapprove drive
What is rest full and restless API
What is https http difference
What is data normalisation

Sanket MAD1 Aug 16, 2026

He is chill guy i was facing an issue in running project because of venv he gave time and guide me to install dependencies in global

Questions remembered

Download zip from viva portal rename it as level1viva1 and then extract
Ask me show functionalities of each user
about the login logic how it works how you implement security check up
Authorization and authentication and show in your code
Ask me created a new entry in registration form for age and print output in the terminal
Explain MVC and show how you implement it
And some basic question related to route and models

Shiva Ramakrishna MAD1 Aug 16, 2026

Go through this excel sheet and that would be enough

Questions remembered

Viva 1 Showed ID, Downloaded the code from viva portal
Asked me to rename the zip folder name to viva_1
Showed the demo
Asked about routes, blueprints
CRUD operations - admin side
summary page visual dashboard (Asked for charts especially)
Inline Vs Internal Vs External CSS
Authorization Vs Authentication
ORM

Sharbba MAD1 Aug 16, 2026

If you are ever stuck somewhere he will give you time and guide you but will ask more and more questions. He also asked about AI percent and all. Also acc to him you should stick fully to the project document. Don't try to miss anything. Prepare really well and be thorough with ur code. this level 1 exp was more like level 2

Questions remembered

Run checksum
Run the code
Made me change the "Cancel" booking button to "release"
Made me reduce the height of my chart
What did you use for CSS?
What are the types of CSS with preference?
What tags are used for tables in HTML, create a table with 3 columns.
What is HTTP full form?
Tell me about HTTP codes.
How are you calculating leaving_time and cost? Show and explain code for that.
Difference between authentication and authorisation
Did you complete DBMS course? I did so he asked about ACID properties

Approved viva sets

See reviews Level2_132 MAD2 Level 2

Aug 16, 2026

Copy set link

1

-> Id, GitHub check, 30 mins

Times asked 2
2

-> change celery beat time to 6:52(12 mins from the time he said) - I didn't remember to do it through crontab so set it at 720 seconds.

Times asked 2
3

-> Demonstration (stopped midway)

Times asked 2
4

-> Caching implemented? Where? Are you deleting the cached data when anything updates. Show

Times asked 2
5

-> How does your authorization and RBAC work.(Mentioned abt tokens so question on that)

Times asked 2
6

-> Can anyone decode your token if there is data leakage. Is your token getting stored in database.

Times asked 2
7

-> Checked mails in mailhog

Times asked 2
8

-> checked patient CSV

Times asked 2
9

Coding question:

Times asked 2
10

In your app after patient registers, it is redirected to login page, so change the code to redirect to patient dashboard directly after registration(couldn't do)

Times asked 2

Advice: Was patient and gave me suggestion on the coding question. When asked for feedback he said project is good but coding question was basic check after viva. Really good proctor

See reviews Level2_132 MAD2 Level 2

Aug 16, 2026

Copy set link

1

LVL1 VIVA

Times asked 2
2

Asked for ID

Times asked 2
3

Downloaded in front of him

Times asked 2
4

Asked me to show functionality one by one

Times asked 2
5

then asked about authentication settings

Times asked 2
6

asked me about token and how it was setup-i used flask security explained unquifier

Times asked 2
7

then asked me to copy paste the home url to another browser and asked me why does the link not work there like extension to authentication

Times asked 2
8

also saw the token being generated in db

Times asked 2
9

asked to show csv export and open the file

Times asked 2
10

asked me to change time in celery task to run it

Times asked 2
11

checked my frontend files and asked me how would i create a new view component or view and connect it to backend

Times asked 2
12

asked me to show code for routes,all apis-authentication and CRUD

Times asked 1
13

asked about cache

Times asked 2
14

theory asked:

Times asked 2
15

difference in put and patch

Times asked 2
16

what are vue methods and its comparison to properties not props im not sure

Times asked 2
17

what are vue directives

Times asked 2
18

rest i dont recall but were in middle of conversation

Times asked 2

Advice: be thorough with your code, know where is what

See reviews Level2_132 MAD2 Level 2

Aug 16, 2026

Copy set link

1

- change the schedule job timings

Times asked 2
2

- Show the crud jobs

Times asked 2
3

- difference between methods and computed properties in vue js

Times asked 2
4

- How can you send data from child to parent?

Times asked 2
5

- How did you "TEST" frontend and backend cashing?

Times asked 2
6

- How did you clear the caching in both.

Times asked 2
7

- diff between PUT and PATCH

Times asked 2

Advice: Chill proctor, run the project before hand and check for all the errors. Do kill all the processes before

See reviews Level2_132 MAD2 Level 2

Aug 16, 2026

Copy set link

1

how do u do Authentication

Times asked 2
2

did u use caching? if so where? (Note: u are expected to have caching)

Times asked 2
3

what did u use for generating access token

Times asked 2
4

difference between vue inline modifiers vs methods (not sure what the exact question was)

Times asked 2

Advice: Check if all the needed softwares are installed in your laptop.

See reviews Level2_132 MAD2 Level 2

Aug 16, 2026

Copy set link

1

Level 1

Times asked 12
2

He is very chill , first I downloaded from portal

Times asked 2
3

Then run app

Times asked 2
4

After proctor ask some questions

Times asked 2
5

What is celery where you use

Times asked 2
6

Where you implement api

Times asked 2
7

Diffence Put vs patch

Times asked 2
8

Css inline vs intenal vs external

Times asked 2
9

He ask questions in conversation

Times asked 2
10

Overall good experience

Times asked 2

Advice: Learn theory.

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1

Asked me to explain the checksum and verify the project checksum.

Times asked 1

Official solution

SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.
Viva tipFunction signature + 3-4 important lines + edge case.
2

Asked about CRUD operations (Create, Read, Update, Delete).

Times asked 1

Official solution

SimpleCRUD = Create Read Update Delete. Admin pe ek resource ke 4 ops dikhao.
3

Asked me to run and demonstrate the project (show the webpages and functionality).

Times asked 1

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
4

Asked What is MVC? and explain MVC with my project.

Times asked 1

Official solution

SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
5
Asked the difference between POST and PUT.

Times asked 1
Official solution

SimplePOST naya janam (har baar naya id). PUT poori photo replace. PATCH sticker chipkao.
POST create, not idempotent. PUT full update, idempotent. PATCH partial.
POST ki jagah PUT se REST semantics toot. GET typically no body.
CRUD map: POST create, GET read, PUT/PATCH update, DELETE delete.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
POST /api/venues
PUT  /api/venues/1   {all fields}
PATCH /api/venues/1 {only name}
```
Project example: POST /api/venues create. PUT /venues/1 saari fields. PATCH sirf name.
6
Asked me to write the frontend code to display Flask flash messages in Notepad.

Times asked 1
Official solution

Simpleredirect dusre URL pe bhejta hai. flash one-time message session mein rakh ke next page pe dikhata hai.
Example
```
flash('Login successful', 'success')
return redirect(url_for('user.dashboard'))
```
7
Asked me to write the Flask registration route (/register) in Notepad.

Times asked 1
Official solution

SimpleLive Flask coding: chhota route likho, save, browser/curl se test. Syntax error terminal mein padho.
Example
```
@app.route('/ping')
def ping():
    return jsonify(ok=True)

@app.route('/even/<int:n>')
def even(n):
    return 'even' if n % 2 == 0 else 'odd'
```

Advice: For Level 1, Focus on Flask basics, CRUD, MVC, POST vs PUT, checksum, and your project flow. Practice writing the register route and flash message code by hand, as code-writing questions are common.

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1

She will asked to login as admin,create trek ,create staff,create user..... do what she says

Times asked 1

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
2

She checked if admin has blacklisted user then whether that admin will able to book a trek or not.

Times asked 1

Official solution

SimpleBlacklist/block: user.status='blocked' check login/booking pe. Temporary flag vs hard delete permanent.
3

Change code if approved staff is greater than 5 then don't allow new staff registration unless some staff is blacklisted (changes in code)

Times asked 1

Official solution

SimpleBlacklist/block: user.status='blocked' check login/booking pe. Temporary flag vs hard delete permanent.
4
Write form taking input as username and password (in nodepad)

Times asked 1
Official solution

SimpleORM = Object Relational Mapping. Tables → Python classes. Raw SQL kam likhte ho.
Example
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

User.query.get(5)  # SELECT ... WHERE id=5
```
5
What if in put method there is no resources to replace

Times asked 1
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: Procter ask same things to all ,she came late and she supports you.

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1

Mam came 10 mins late.

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
2

Demonstrate the project with all the functionalities.

Times asked 1

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
3
Flask route to search a trekker using their name(it should be GET but I wrote POST)

Times asked 1
Official solution

SimpleGET data read/show karta hai (idempotent). POST create/submit karta hai (form).
Example
```
@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        # validate + session
        ...
    return render_template('login.html')
```
4
She asked to change the colour of the charts.

Times asked 1
Official solution

SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.
Example
```
/* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }
```
Viva tipDevTools se pehle try, phir file mein permanent change.
5
Which ORM is used in the application.

Times asked 1
Official solution

SimpleORM = Object Relational Mapping. Tables → Python classes. Raw SQL kam likhte ho.
Example
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

User.query.get(5)  # SELECT ... WHERE id=5
```
6

How many tables you have created.

Times asked 1

Official solution

SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.
Viva tipFunction signature + 3-4 important lines + edge case.

Advice: She was chill. Do charts questions, she will definitely ask. Be honest if you don't know the answer.

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1

asked for checksum but i said im downloading directly from the portal

Times asked 1

Official solution

SimpleExaminer portal wala submitted ZIP chahta hai. Local extra changes mat dikhana.
Suggested flow1) Portal ZIP download
2) Extract
3) venv + pip install -r requirements.txt
4) flask run / python app.py
2
open GitHub to show your repository and check if mad1 is added as collaborator

Times asked 1
Official solution

SimpleGitHub repo open karo: commits, collaborators, README. Examiner check karta hai tumne khud kaam kiya.
Example
```
Settings → Collaborators
Commits: regular messages, last-day dump nahi.
```
Viva tipPrivate repo access pehle de do. Main branch submitted ZIP se match honi chahiye.
3

asked to start giving the demo of my project then started the viva questions when i just started and was on landing page

Times asked 1

Official solution

SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
4

(question are out of order i wrote them as I remembered them)

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
5

3.create a trek

Times asked 1

Official solution

SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
6

5.Create a staff

Times asked 1

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
7

6.create a trekker

Times asked 1

Official solution

SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
8
7.checking if staff needs approval

Times asked 1
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.
9

8.blacklist user and try to login as user

Times asked 1

Official solution

SimpleBlacklist/block: user.status='blocked' check login/booking pe. Temporary flag vs hard delete permanent.
10
9.search for a user in admin page

Times asked 1
Official solution

SimpleSearch: form/query param → ilike filter → results template.
Example
```
q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
```
11

10.assign staff to trek

Times asked 1

Official solution

SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
12

11.change status of trek to completed from staff side and then check if it is updated on user and admin side

Times asked 1

Official solution

SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
13
12.put vs post

Times asked 1
Official solution

SimplePOST naya janam (har baar naya id). PUT poori photo replace. PATCH sticker chipkao.
POST create, not idempotent. PUT full update, idempotent. PATCH partial.
POST ki jagah PUT se REST semantics toot. GET typically no body.
CRUD map: POST create, GET read, PUT/PATCH update, DELETE delete.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
POST /api/venues
PUT  /api/venues/1   {all fields}
PATCH /api/venues/1 {only name}
```
Project example: POST /api/venues create. PUT /venues/1 saari fields. PATCH sirf name.
14
13.write the html for a table to display name and roll no.

Times asked 1
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.
15

Im missing one question on which i said i dont know. i dont remember that question

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.

Advice: she seems patient and if you dont know something then just tell her i also got error on 4 so maam just moved on and asked other questions

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1

Do some modification in code so that if company have a one active place when drive he cannot create another drive

Times asked 1

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
2
Create flask app and write a function so that it show all the unapprove drive

Times asked 1
Official solution

SimpleLive Flask coding: chhota route likho, save, browser/curl se test. Syntax error terminal mein padho.
Example
```
@app.route('/ping')
def ping():
    return jsonify(ok=True)

@app.route('/even/<int:n>')
def even(n):
    return 'even' if n % 2 == 0 else 'odd'
```
3
What is rest full and restless API

Times asked 1
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.
4

What is https http difference

Times asked 1

Official solution

SimpleHTTP postcard (koi padh le). HTTPS envelope (TLS lock).
Same headers, encrypted channel. MITM se password/token bachao. Local viva HTTP OK.
HTTP/1.1 version keep-alive. TCP neeche, TLS security layer, SMTP mail alag.
Browser + API ke beech extra darwaze: CORS origin allow, HTTPS encrypt transit, CSRF cookie-auto-send attack, XSS HTML inject, SQL injection raw query.
MAD2 SPA: Vue :8080 Flask :5000 → Flask-CORS. JWT localStorage XSS se chori ho sakta — v-html user input pe avoid. Password Network tab localhost pe dikhega; prod HTTPS, response mein password echo nahi.
401 unauthenticated, 403 unauthorized, 400 validation. Hash one-way — SHA decrypt nahi hota. Secret key .env, GitHub pe nahi.
Project example: Dev localhost http. Production https:// + cert.
Viva tipProtocols: HTTP/HTTPS app, TCP transport, TLS security, SMTP mail. HTTP/1.1 version — persistent connections.

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1

Download zip from viva portal rename it as level1viva1 and then extract

Times asked 1

Official solution

SimpleExaminer portal wala submitted ZIP chahta hai. Local extra changes mat dikhana.
Suggested flow1) Portal ZIP download
2) Extract
3) venv + pip install -r requirements.txt
4) flask run / python app.py
2
about the login logic how it works how you implement security check up

Times asked 1
Official solution

SimpleLogin flow pehle poochta hai "tu kaun hai?", token milne ke baad har API pe wohi proof dikhate ho.
Authentication step: Vue form email + password JSON POST karta hai. Flask user dhoondhta hai, check_password_hash se prove karta hai ki tum genuine ho. Galat 401. Sahi pe JWT + role milta hai — yeh session/token hai.
Vue localStorage (ya cookie) mein token rakhta hai, dashboard pe router.push. Aage ki har fetch header: Authorization: Bearer <token>. @jwt_required identity check (authentication). @roles_required('admin') permission check (authorization) — logged in ho, lekin allowed nahi to 403.
Validation alag cheez hai: empty email, password 8+ — form sahi bhara hai ya nahi. Woh identity prove nahi karta.
Logout = client token delete + login page. Server blacklist optional. Password response JSON mein kabhi mat bhejo.
Example
```
# Authentication
@app.route('/api/login', methods=['POST'])
def login():
    u = User.query.filter_by(email=data['email']).first()
    if not u or not check_password_hash(u.password, data['password']):
        return jsonify(msg='bad'), 401
    return jsonify(token=create_access_token(u.id), role=u.role)

# baad ki APIs
# Authorization: Bearer <token>
if current_user.role != 'admin':
    abort(403)
```
Project example: Login.vue POST /api/login → token LS → interceptor. Student token se admin route = 403. Empty form = validation, galat password = 401.
Viva tipNetwork tab mein password body dikhega localhost pe — prod HTTPS. Response mein hash/password echo mat karo.
3
Ask me created a new entry in registration form for age and print output in the terminal

Times asked 1
Official solution

SimpleORM = Object Relational Mapping. Tables → Python classes. Raw SQL kam likhte ho.
Example
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

User.query.get(5)  # SELECT ... WHERE id=5
```
4

Explain MVC and show how you implement it

Times asked 1

Official solution

SimpleMVC: Model=data (SQLAlchemy), View=Jinja HTML, Controller=Flask routes/business logic.
Flask loosely MVC follow karta hai — routes controllers, templates views, models.py models.
5
And some basic question related to route and models

Times asked 1
Official solution

Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.
Suggested flow1) Classes list karo
2) Har table ka kaam 1 line
3) Relationships (1-M / M-M)
4) Constraints (unique, nullable)
Example
```
class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
```

Advice: He is chill guy i was facing an issue in running project because of venv he gave time and guide me to install dependencies in global

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1

Viva 1 Showed ID, Downloaded the code from viva portal

Times asked 1

Official solution

SimpleExaminer portal wala submitted ZIP chahta hai. Local extra changes mat dikhana.
Suggested flow1) Portal ZIP download
2) Extract
3) venv + pip install -r requirements.txt
4) flask run / python app.py
2

Asked me to rename the zip folder name to viva_1

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
3

Showed the demo

Times asked 1

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
4
Asked about routes, blueprints

Times asked 1
Official solution

SimpleBlueprint se app ko modules mein todte ho — auth, admin, user alag files. Scale + clean structure.
Example
```
auth_bp = Blueprint('auth', __name__, url_prefix='/auth')

@auth_bp.route('/login')
def login(): ...

app.register_blueprint(auth_bp)
```
Viva tipViva: 'kyun blueprint?' → separation of concerns, badi app maintainable.
5
summary page visual dashboard (Asked for charts especially)

Times asked 1
Official solution

SimpleCounts API, bar/pie, booking ke baad number badle.
2 colors live task common.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
new Chart(ctx, {
  type: 'bar',
  data: { labels: ['Jan','Feb'], datasets: [{ data: [12, 19], backgroundColor: ['#36a','#f80'] }] }
})
```
Project example: Admin dashboard.
Viva tipBooking karke chart update dikhao. Examiner 2 colors maange to backgroundColor array chhota kar do.

Advice: Go through this excel sheet and that would be enough

See reviews Level2_132 MAD1 Level 2

Aug 16, 2026

Copy set link

1
Run checksum

Times asked 1
Official solution

Simplevenv activate → dependencies → DB create/migrate → flask run. Browser pe localhost dikhao.
Example
```
python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
flask run
```
2
Run the code

Times asked 1
Official solution

Simplevenv activate → dependencies → DB create/migrate → flask run. Browser pe localhost dikhao.
Example
```
python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
flask run
```
3
Made me change the "Cancel" booking button to "release"

Times asked 1
Official solution

SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.
Example
```
/* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }
```
Viva tipDevTools se pehle try, phir file mein permanent change.
4
Made me reduce the height of my chart

Times asked 1
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.
5

What did you use for CSS?

Times asked 1

Official solution

SimpleCSS page ko style karti hai — color, layout, font. HTML structure, CSS look.
h1 { color: navy; } .card { padding: 16px; } #logo { width: 80px; }
Selectors: element (h3), class (.btn), id (#nav), pseudo (:hover).
display:flex — ek line/row mein items, justify-content/align-items se center.
Multiple classes: saari apply, conflict pe specificity/order.
Responsive: media queries / Bootstrap grid. Bina CSS limited (old tables) — practically CSS chahiye.
6

What are the types of CSS with preference?

Times asked 1

Official solution

SimpleCSS 3 tarikon se lagti hai, priority Inline > Internal > External (same specificity pe).
Inline: style='color:red' element pe. Highest priority, lekin reuse nahi. Debugging mushkil.
Internal: <style> tag HTML head mein. Us page tak limited.
External: style.css file. Large project ke liye best — ek jagah change, saari pages update.
Example same button pe teeno:
/* external */ .btn { color: blue; }
/* internal */ .btn { color: green; }
 <button class='btn' style='color:red'> → red jeetega
ID (#box) class (.btn) se strong, class element (button) se strong.
!important sabko override karta hai — avoid karo.
Large project: external CSS preferred.
7

What tags are used for tables in HTML, create a table with 3 columns.

Times asked 1

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
8
What is HTTP full form?

Times asked 1
Official solution

SimpleORM = Object Relational Mapping. Tables → Python classes. Raw SQL kam likhte ho.
Example
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

User.query.get(5)  # SELECT ... WHERE id=5
```
9
Tell me about HTTP codes.

Times asked 1
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.
10

How are you calculating leaving_time and cost? Show and explain code for that.

Times asked 1

Official solution

SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.
Viva tipFunction signature + 3-4 important lines + edge case.
11
Did you complete DBMS course? I did so he asked about ACID properties

Times asked 1
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: If you are ever stuck somewhere he will give you time and guide you but will ask more and more questions. He also asked about AI percent and all. Also acc to him you should stick fully to the project document. Don't try to miss anything. Prepare really well and be thorough with ur code. this level 1 exp was more like level 2

See reviews Level2_132 MAD1 Level 1

Aug 14, 2026

Copy set link

1

level 1 ...vue components, Cache , some port nos, will ask to change cerely b timing and to show live working .. some other basic qs while showing demo (i cant recall more then this)

Times asked 1

Official solution

SimpleLevel = viva difficulty band. Level 1 usually demo + basics; higher pe live coding + deeper theory.
Viva tipJo level assign hai uske hisaab se demo + theory ready rakho.

Advice: very good proctor .. so dont panic

See reviews Level2_132 MAD1 Level 2

Aug 14, 2026

Copy set link

1
-> Id, GitHub check, 30 mins

Times asked 2
Official solution

SimpleGitHub repo open karo: commits, collaborators, README. Examiner check karta hai tumne khud kaam kiya.
Example
```
Settings → Collaborators
Commits: regular messages, last-day dump nahi.
```
Viva tipPrivate repo access pehle de do. Main branch submitted ZIP se match honi chahiye.
2
-> change celery beat time to 6:52(12 mins from the time he said) - I didn't remember to do it through crontab so set it at 720 seconds.

Times asked 2
Official solution

SimpleSchedule current time / har minute, beat restart, logs + MailHog.
Don't forget worker. Crontab fields. Demo ke baad revert if asked.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
crontab(hour=17, minute=20)
crontab(minute='*/1')
@celery.task
def add(a, b):
    return a + b
```
Project example: CELERY_BEAT_SCHEDULE edit. Terminal beat 'Sending due task'.
3

-> Demonstration (stopped midway)

Times asked 2

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
4
-> Caching implemented? Where? Are you deleting the cached data when anything updates. Show

Times asked 2
Official solution

SimpleCache = pehli baar hisaab karke copy rakh lo, doosri baar copy dikha do.
Baar-baar same expensive kaam (DB query, counting bookings) mat karo. Result Redis jaise store mein timeout ke saath rakh do.
Cache hit: key mil gayi, DB skip. Cache miss: DB se lao, SET karo, return karo.
Tradeoff: speed vs stale data. Admin naya venue add kare aur cache 50s ka ho to user purani list dekh sakta hai — isliye write pe invalidation zaroori hai.
Browser cache, Flask-Caching, Redis alag layers hain. MAD2 examiner Redis + @cache.cached code dekhta hai.
Example
```
@cache.cached(timeout=50, query_string=True)
@app.route('/api/shows')
def shows():
    return jsonify([s.serialize() for s in Show.query.all()])
```
Project example: Admin dashboard counts / venues list cache. Create/update/delete ke baad cache.delete('venues').
Viva tipprint('DB queried') function ke andar laga ke miss/hit demo karo — hit pe print nahi chalega.
5
-> Vue Directives

Times asked 1
Official solution

SimpleDirectives Vue ke special attributes — HTML ko superpower.
v-if/else/show, v-for, v-bind (:), v-on (@), v-model, v-html (XSS), v-cloak, v-slot.
:src = v-bind:src. @click = v-on:click.
Custom directives bhi (v-focus) — course basics kaafi.
Example
```
<p v-if="ok">Yes</p>
<li v-for="u in users" :key="u.id">{{ u.name }}</li>
<input v-model="email">
<img :src="url">
```
Project example: List v-for :key. Form v-model. Admin v-if. Image :src.
Viva tip: src ke liye v-bind:src ka shorthand. @click = v-on:click.
6
-> How does your authorization and RBAC work.(Mentioned abt tokens so question on that)

Times asked 2
Official solution

SimpleRBAC = Role Based Access Control. Roles (admin/user) se permissions milti hain, har user pe alag list nahi.
Example
```
if current_user.role != 'admin':
    flash('Not allowed')
    return redirect(url_for('user.home'))
```
7
-> Can anyone decode your token if there is data leakage. Is your token getting stored in database.

Times asked 2
Official solution

Simpledata() local diary. Store school notice board.
Search query local. Logged-in user store. Persist: store + localStorage together.
state vs data: similar concept, scope alag.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
// local
data() { return { q: '' } }
// global
this.$store.state.user
```
Project example: Login.vue local form fields. this.$store.state.user Navbar.
8
-> What are props

Times asked 1
Official solution

SimpleProps parent ki thali child ko dena. Child thali tod ke parent ki thali na badle — emit bolo.
Declare props, parent :venue="v". One-way. Mutate mat. Types/required Vue 3.
List parent, card child — classic viva.
Component = reusable UI block (Navbar, Card). Props parent→child data, emit child→parent event. Slots parent HTML inner content.
computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.
SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.
Example
```
<VenueCard :venue="v" @select="onSelect" />
props: ['venue']
this.$emit('select', this.venue.id)
```
Project example: VenueCard :venue. Child $emit('select', id).
9
-> Checked mails in mailhog

Times asked 2
Official solution

SimpleMailHog local fake post office — email internet pe nahi jaata, browser mein dikhta hai.
SMTP 1025, Web UI 8025. Viva demo gold. Credentials nahi.
Real Gmail SMTP student accounts pe block common — MailHog safer.
Flask-Mail / SMTP se mail. Local MailHog fake server: SMTP 1025, UI 8025 — internet nahi, viva safe.
Asli send Celery task mein, request thread mein nahi. Beat 6pm reminder, export ke baad CSV attach optional.
MAIL_SERVER localhost demo. Gmail SMTP student account pe block common. Body mein user name personalization examiner dekhta hai.
Example
```
MAIL_SERVER=localhost
MAIL_PORT=1025
# http://localhost:8025
```
Project example: Reminder task → MailHog list → HTML body user name ke saath.
10

-> checked patient CSV

Times asked 2

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
11

Coding question:

Times asked 2

Official solution

SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
12
In your app after patient registers, it is redirected to login page, so change the code to redirect to patient dashboard directly after registration(couldn't do)

Times asked 2
Official solution

Simpleredirect dusre URL pe bhejta hai. flash one-time message session mein rakh ke next page pe dikhata hai.
Example
```
flash('Login successful', 'success')
return redirect(url_for('user.dashboard'))
```

Advice: Was patient and gave me suggestion on the coding question. When asked for feedback he said project is good but coding question was basic check after viva. Really good proctor

See reviews Level2_132 MAD1 Level 1

Aug 14, 2026

Copy set link

1

LVL1 VIVA

Times asked 2

Official solution

SimpleLevel = viva difficulty band. Level 1 usually demo + basics; higher pe live coding + deeper theory.
Viva tipJo level assign hai uske hisaab se demo + theory ready rakho.
2

Asked for ID

Times asked 2

Official solution

SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.
3
Downloaded in front of him

Times asked 2
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.
4

Asked me to show functionality one by one

Times asked 2

Official solution

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout
Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.
5
then asked about authentication settings

Times asked 2
Official solution

SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).
Example
```
# auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
```
6
asked me about token and how it was setup-i used flask security explained unquifier

Times asked 2
Official solution

SimpleFlask lightweight Python web framework — routes, request/response, templates. MAD1 ka backend yahi hai.
Example
```
from flask import Flask
app = Flask(__name__)

@app.route('/')
def home():
    return 'Hello'
```
Viva tipFlask micro hai: jo chahiye (DB, login, forms) khud jodte ho.
7
then asked me to copy paste the home url to another browser and asked me why does the link not work there like extension to authentication

Times asked 2
Official solution

SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).
Example
```
# auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
```
8
also saw the token being generated in db

Times asked 2
Official solution

SimpleJWT teen tukde ki signed chitthi: header.payload.signature. Padhi ja sakti hai, badli nahi ja sakti.
Encoded (Base64) + signed, encrypted nahi (JWE alag). Payload mein password mat daalo — koi jwt.io pe dekh lega.
Login pe server secret se HMAC (HS256). Har API Authorization: Bearer <token>.
Expiry exp. Change payload → signature fail → 401.
Session MAD1 server yaad rakhta. JWT MAD2 client rakhta, server stateless-ish.
Example
```
eyJhbGciOiJIUzI1NiJ9.{"sub":1,"role":"admin"}.signature
# Authorization: Bearer <token>
```
Project example: POST /login → token LS. fetch interceptor header. @jwt_required APIs.
Viva tipAlgo HS256. Secret env var. jwt.io pe payload dikhao, secret public site pe mat paste.
9
asked to show csv export and open the file

Times asked 2
Official solution

SimpleClick → Celery → worker CSV → email/download. Columns verify.
csv module. Auth required. Don't freeze UI — 202 + poll.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
@celery.task
def export_venues_csv(user_id):
    rows = Venue.query.all()
    # csv.writer, mail.send
    return 'ok'
```
Project example: Admin export venues. MailHog attach ya file open.
Viva tipNetwork tab mein job trigger API dikhao, phir MailHog/file open karke columns verify karo.
10
asked me to change time in celery task to run it

Times asked 2
Official solution

SimpleCelery = background naukri. HTTP request ko 10 second email bhejne ke liye mat rokna.
Distributed task queue: aap function ko abhi nahi, worker process mein later/retry/schedule pe chalaate ho.
MAD2 typical jobs: daily reminder mail, monthly HTML report, user-triggered CSV export.
Web request 200ms hona chahiye. 10,000 emails request thread mein = timeout. Worker alag CPU pe kaam kare.
Redis broker chahiye. Beat alag process schedule ke liye.
Example
```
@celery.task
def daily_reminder():
    for u in User.query.filter_by(active=True):
        send_mail(u.email, 'Book something today!')
```
Project example: User Export click → 202 Accepted. Worker CSV + email. Daily 6pm Beat reminder.
Viva tipWorker + Redis bina Beat ke user-triggered chalega. Scheduled jobs ke liye Beat bhi chahiye.
11

checked my frontend files and asked me how would i create a new view component or view and connect it to backend

Times asked 2

Official solution

SimpleMAD1 frontend usually Jinja templates + HTML/CSS/Bootstrap (+ thoda JS). MAD2 pe Vue ho to clearly bolo.
12
asked about cache

Times asked 2
Official solution

SimpleCache = pehli baar hisaab karke copy rakh lo, doosri baar copy dikha do.
Baar-baar same expensive kaam (DB query, counting bookings) mat karo. Result Redis jaise store mein timeout ke saath rakh do.
Cache hit: key mil gayi, DB skip. Cache miss: DB se lao, SET karo, return karo.
Tradeoff: speed vs stale data. Admin naya venue add kare aur cache 50s ka ho to user purani list dekh sakta hai — isliye write pe invalidation zaroori hai.
Browser cache, Flask-Caching, Redis alag layers hain. MAD2 examiner Redis + @cache.cached code dekhta hai.
Example
```
@cache.cached(timeout=50, query_string=True)
@app.route('/api/shows')
def shows():
    return jsonify([s.serialize() for s in Show.query.all()])
```
Project example: Admin dashboard counts / venues list cache. Create/update/delete ke baad cache.delete('venues').
Viva tipprint('DB queried') function ke andar laga ke miss/hit demo karo — hit pe print nahi chalega.
13

theory asked:

Times asked 2

Official solution

SimpleTheory = concepts: ORM, MVC, auth vs authz, Jinja inheritance, sessions. 1-line def + project example.
14
difference in put and patch

Times asked 2
Official solution

SimplePOST naya janam (har baar naya id). PUT poori photo replace. PATCH sticker chipkao.
POST create, not idempotent. PUT full update, idempotent. PATCH partial.
POST ki jagah PUT se REST semantics toot. GET typically no body.
CRUD map: POST create, GET read, PUT/PATCH update, DELETE delete.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
POST /api/venues
PUT  /api/venues/1   {all fields}
PATCH /api/venues/1 {only name}
```
Project example: POST /api/venues create. PUT /venues/1 saari fields. PATCH sirf name.
15
what are vue methods and its comparison to properties not props im not sure

Times asked 2
Official solution

SimpleVue = UI ka smart assistant. Data badlo, screen khud update. MAD1 Jinja har click pe naya HTML.
Progressive frontend framework. Components, reactivity, directives.
MAD2 SPA: ek index.html, Vue Router pages, Flask sirf JSON.
Fayde: easy, SFC, docs. Vs React: templates HTML-like, course sikhata hai. Vs plain JS: baar-baar DOM mat chhedo.
Example
```

<template>
  <h1>{{ msg }}</h1>
</template>
<script>
export default { data() { return { msg: 'Hello' } } }
</script>
```
Project example: Navbar.vue + views (Login, Dashboard). data() / setup() reactive. fetch APIs.
Viva tipFayde: easy, SFC, reactivity. Vs React: chhota learning curve. Vs plain JS: UI state auto-update.
16
what are vue directives

Times asked 2
Official solution

SimpleDirectives Vue ke special attributes — HTML ko superpower.
v-if/else/show, v-for, v-bind (:), v-on (@), v-model, v-html (XSS), v-cloak, v-slot.
:src = v-bind:src. @click = v-on:click.
Custom directives bhi (v-focus) — course basics kaafi.
Example
```
<p v-if="ok">Yes</p>
<li v-for="u in users" :key="u.id">{{ u.name }}</li>
<input v-model="email">
<img :src="url">
```
Project example: List v-for :key. Form v-model. Admin v-if. Image :src.
Viva tip: src ke liye v-bind:src ka shorthand. @click = v-on:click.
17
rest i dont recall but were in middle of conversation

Times asked 2
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: be thorough with your code, know where is what

See reviews Level2_132 MAD1 Level 2

Aug 14, 2026

Copy set link

1
- change the schedule job timings

Times asked 2
Official solution

SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.
Example
```
/* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }
```
Viva tipDevTools se pehle try, phir file mein permanent change.
2

- Show the crud jobs

Times asked 2

Official solution

SimpleCRUD = Create Read Update Delete. Admin pe ek resource ke 4 ops dikhao.
3

- difference between methods and computed properties in vue js

Times asked 2

Official solution

Simplemethods: click handlers, har call run. computed: cached property jaisa.
@click save() method. {{ total }} computed. Mat computed ke andar API.
Component = reusable UI block (Navbar, Card). Props parent→child data, emit child→parent event. Slots parent HTML inner content.
computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.
SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.
Project example: book() method POST. canBook computed seats>0 && !already.
4

- How can you send data from child to parent?

Times asked 2

Official solution

SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.
Viva tipFunction signature + 3-4 important lines + edge case.
5

- How did you "TEST" frontend and backend cashing?

Times asked 2

Official solution

SimpleRole checklist, Postman, Celery logs. Test plan tick karke confidence aati hai.
Manual + maybe pytest. Examiner 'kaise test kiya' pe process sunna chahta hai, 100% guarantee nahi.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: List 5 cases: login fail, overbook, cache hit, reminder, admin 403.
6
- How did you clear the caching in both.

Times asked 2
Official solution

SimpleCache = pehli baar hisaab karke copy rakh lo, doosri baar copy dikha do.
Baar-baar same expensive kaam (DB query, counting bookings) mat karo. Result Redis jaise store mein timeout ke saath rakh do.
Cache hit: key mil gayi, DB skip. Cache miss: DB se lao, SET karo, return karo.
Tradeoff: speed vs stale data. Admin naya venue add kare aur cache 50s ka ho to user purani list dekh sakta hai — isliye write pe invalidation zaroori hai.
Browser cache, Flask-Caching, Redis alag layers hain. MAD2 examiner Redis + @cache.cached code dekhta hai.
Example
```
@cache.cached(timeout=50, query_string=True)
@app.route('/api/shows')
def shows():
    return jsonify([s.serialize() for s in Show.query.all()])
```
Project example: Admin dashboard counts / venues list cache. Create/update/delete ke baad cache.delete('venues').
Viva tipprint('DB queried') function ke andar laga ke miss/hit demo karo — hit pe print nahi chalega.
7
- diff between PUT and PATCH

Times asked 2
Official solution

SimplePOST naya janam (har baar naya id). PUT poori photo replace. PATCH sticker chipkao.
POST create, not idempotent. PUT full update, idempotent. PATCH partial.
POST ki jagah PUT se REST semantics toot. GET typically no body.
CRUD map: POST create, GET read, PUT/PATCH update, DELETE delete.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
POST /api/venues
PUT  /api/venues/1   {all fields}
PATCH /api/venues/1 {only name}
```
Project example: POST /api/venues create. PUT /venues/1 saari fields. PATCH sirf name.

Advice: Chill proctor, run the project before hand and check for all the errors. Do kill all the processes before

See reviews Level2_132 MAD1 Level 2

Aug 14, 2026

Copy set link

1
how do u do Authentication

Times asked 2
Official solution

SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).
Example
```
# auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
```
2
did u use caching? if so where? (Note: u are expected to have caching)

Times asked 2
Official solution

SimpleCache = pehli baar hisaab karke copy rakh lo, doosri baar copy dikha do.
Baar-baar same expensive kaam (DB query, counting bookings) mat karo. Result Redis jaise store mein timeout ke saath rakh do.
Cache hit: key mil gayi, DB skip. Cache miss: DB se lao, SET karo, return karo.
Tradeoff: speed vs stale data. Admin naya venue add kare aur cache 50s ka ho to user purani list dekh sakta hai — isliye write pe invalidation zaroori hai.
Browser cache, Flask-Caching, Redis alag layers hain. MAD2 examiner Redis + @cache.cached code dekhta hai.
Example
```
@cache.cached(timeout=50, query_string=True)
@app.route('/api/shows')
def shows():
    return jsonify([s.serialize() for s in Show.query.all()])
```
Project example: Admin dashboard counts / venues list cache. Create/update/delete ke baad cache.delete('venues').
Viva tipprint('DB queried') function ke andar laga ke miss/hit demo karo — hit pe print nahi chalega.
3
what did u use for generating access token

Times asked 2
Official solution

SimpleJWT teen tukde ki signed chitthi: header.payload.signature. Padhi ja sakti hai, badli nahi ja sakti.
Encoded (Base64) + signed, encrypted nahi (JWE alag). Payload mein password mat daalo — koi jwt.io pe dekh lega.
Login pe server secret se HMAC (HS256). Har API Authorization: Bearer <token>.
Expiry exp. Change payload → signature fail → 401.
Session MAD1 server yaad rakhta. JWT MAD2 client rakhta, server stateless-ish.
Example
```
eyJhbGciOiJIUzI1NiJ9.{"sub":1,"role":"admin"}.signature
# Authorization: Bearer <token>
```
Project example: POST /login → token LS. fetch interceptor header. @jwt_required APIs.
Viva tipAlgo HS256. Secret env var. jwt.io pe payload dikhao, secret public site pe mat paste.
4

difference between vue inline modifiers vs methods (not sure what the exact question was)

Times asked 2

Official solution

SimpleUngli rakhe to 4-line formula — panic ki jagah structure.
1) File ka role: model / Flask route / Vue SFC / celery task / config
2) Input kahan: JSON, params, token, props, $route
3) Kya kaam: query, cache, validation, .delay()
4) Output: jsonify, this.items, email, redirect
Unknown keyword: import, decorator, if, commit — har ka reason. Bluff mat.
Suggested flow1) Kaunsi layer?
2) Input?
3) DB/cache/task?
4) Response/UI?
Project example: Booking POST: jwt, seats check, commit, 201, Vue list push.
Viva tipUnknown keyword: import, decorator, if, commit — har ka reason. Panic mat.

Advice: Check if all the needed softwares are installed in your laptop.

See reviews Level2_132 MAD1 Level 2

Aug 14, 2026

Copy set link

1

Level 1

Times asked 12

Official solution

SimpleLevel = viva difficulty band. Level 1 usually demo + basics; higher pe live coding + deeper theory.
Viva tipJo level assign hai uske hisaab se demo + theory ready rakho.
2

He is very chill , first I downloaded from portal

Times asked 2

Official solution

SimpleExaminer portal wala submitted ZIP chahta hai. Local extra changes mat dikhana.
Suggested flow1) Portal ZIP download
2) Extract
3) venv + pip install -r requirements.txt
4) flask run / python app.py
3
Then run app

Times asked 2
Official solution

Simpleapp = Flask(__name__) app banata hai; if __name__ == '__main__' tabhi server start jab file directly run ho.
```
app = Flask(__name__)
if __name__ == '__main__':
    app.run(debug=True, port=5000)
```
__name__ module ka naam. Direct run pe '__main__', import pe filename. Import karoge to server auto-start nahi — tests/blueprints ke liye zaroori.
debug=True: auto-reload + debugger. Production mein band rakho (security).
Port: app.run(port=8000) ya flask run --port 8000. Default 5000. Haan, change ho sakta hai.
4

After proctor ask some questions

Times asked 2

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
5
What is celery where you use

Times asked 2
Official solution

SimpleCelery = background naukri. HTTP request ko 10 second email bhejne ke liye mat rokna.
Distributed task queue: aap function ko abhi nahi, worker process mein later/retry/schedule pe chalaate ho.
MAD2 typical jobs: daily reminder mail, monthly HTML report, user-triggered CSV export.
Web request 200ms hona chahiye. 10,000 emails request thread mein = timeout. Worker alag CPU pe kaam kare.
Redis broker chahiye. Beat alag process schedule ke liye.
Example
```
@celery.task
def daily_reminder():
    for u in User.query.filter_by(active=True):
        send_mail(u.email, 'Book something today!')
```
Project example: User Export click → 202 Accepted. Worker CSV + email. Daily 6pm Beat reminder.
Viva tipWorker + Redis bina Beat ke user-triggered chalega. Scheduled jobs ke liye Beat bhi chahiye.
6

Where you implement api

Times asked 2

Official solution

SimpleUngli rakhe to 4-line formula — panic ki jagah structure.
1) File ka role: model / Flask route / Vue SFC / celery task / config
2) Input kahan: JSON, params, token, props, $route
3) Kya kaam: query, cache, validation, .delay()
4) Output: jsonify, this.items, email, redirect
Unknown keyword: import, decorator, if, commit — har ka reason. Bluff mat.
Suggested flow1) Kaunsi layer?
2) Input?
3) DB/cache/task?
4) Response/UI?
Project example: Booking POST: jwt, seats check, commit, 201, Vue list push.
Viva tipUnknown keyword: import, decorator, if, commit — har ka reason. Panic mat.
7
Diffence Put vs patch

Times asked 2
Official solution

SimplePOST naya janam (har baar naya id). PUT poori photo replace. PATCH sticker chipkao.
POST create, not idempotent. PUT full update, idempotent. PATCH partial.
POST ki jagah PUT se REST semantics toot. GET typically no body.
CRUD map: POST create, GET read, PUT/PATCH update, DELETE delete.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
POST /api/venues
PUT  /api/venues/1   {all fields}
PATCH /api/venues/1 {only name}
```
Project example: POST /api/venues create. PUT /venues/1 saari fields. PATCH sirf name.
8

Css inline vs intenal vs external

Times asked 2

Official solution

SimpleUngli rakhe to 4-line formula — panic ki jagah structure.
1) File ka role: model / Flask route / Vue SFC / celery task / config
2) Input kahan: JSON, params, token, props, $route
3) Kya kaam: query, cache, validation, .delay()
4) Output: jsonify, this.items, email, redirect
Unknown keyword: import, decorator, if, commit — har ka reason. Bluff mat.
Suggested flow1) Kaunsi layer?
2) Input?
3) DB/cache/task?
4) Response/UI?
Project example: Booking POST: jwt, seats check, commit, 201, Vue list push.
Viva tipUnknown keyword: import, decorator, if, commit — har ka reason. Panic mat.
9
He ask questions in conversation

Times asked 2
Official solution

SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.
Suggested flow1) Concept kya hai?
2) Mere code mein kahan?
3) Example / demo
4) Edge case
Example
```
# related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect
```
Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.
10

Overall good experience

Times asked 2

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.

Advice: Learn theory.

See reviews Level2_132 MAD1 Level 1

Jul 30, 2026

Copy set link

1

Show your student ID.

Times asked 3

Official solution

SimpleCamera pe clearly IITM/college ID dikhao — naam photo match.
Pehle se ID haath mein rakho. Glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2

Download the project ZIP from the viva portal.

Times asked 1

Official solution

SimpleExaminer submitted ZIP chahta hai, local extra changes nahi.
Portal se ZIP download → extract → venv → pip install -r requirements.txt → flask run / python app.py.
Checksum maange to hash match karke dikhao. Camera/OPPE setup unke instructions.
Linux/Mac: paths, gunicorn; Windows paths alag ho to relative paths use karo.
Do browsers: admin + user parallel demo impressive lagta hai.
3
Rename the ZIP/folder as instructed (e.g., viva_1 or level1viva1) and extract it.

Times asked 1
Official solution

Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:
Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.
Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.
Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
Live change maange to: related model → route → template, phir browser refresh karke dikhao.
Example (generic create):
obj = Model(name=request.form.get('name'))
```
db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
```
4

Demonstrate the complete application.

Times asked 33

Official solution

SimpleDemo script pehle se practice karo, 5-7 minute, saari roles.
Suggested flow
1) Register/login user 2) Admin login — CRUD 3) Approval/blacklist 4) Booking/apply 5) Search 6) Validation edge (slots 0, duplicate) 7) Logout
Bolte-bolte dikhao: 'Yahan overbooking rokta hoon'. Code tab kholna jab poochhein.
Crash ho to debug calmly: terminal error, typo, DB path.
Mandatory features skip mat karna — examiner list tick karta hai.
5

Show the functionalities of each user role.

Times asked 1

Official solution

Yeh feature demo hai. Account ready rakho, steps bol ke dikhao.
Role ke hisaab login → action (create/approve/book) → DB/UI pe result → edge case (fail when slots=0 / blacklisted).
Do browser windows: admin + user. Search/filter alag se dikhao.
Agar feature nahi hai to sach bolo aur 2 minute mein kaise add karoge (query + template) explain karo.
6

Explain the routes.

Times asked 2

Official solution

SimpleRoutes/controllers URLs handle karte hain. app.py app banata hai, models.py data, templates/ views, static/ CSS-JS.
Typical structure:
app.py / __init__.py → Flask app, db.init, register blueprints
models.py → tables
routes.py / views → @app.route functions
templates/ → Jinja HTML
static/ → css, images
instance/*.db → SQLite
Ek route explain karne ka template:
1) URL + methods 2) Auth/role check 3) Form/query se data 4) Business rule (duplicate, slots) 5) db.session 6) render ya redirect
Example GET+POST same route: GET form, POST save.
Data HTML se: form name= → request.form. Data HTML ko: render_template(..., items=query).
Nayi .py file: import karke use karo, warna Flask ko pata nahi. Folder rename: imports/paths/templates check.
7
Explain the models.

Times asked 1
Official solution

Simplemodels.py har table ki class hai — columns, PK/FK, relationships. Yeh Model layer hai.
Viva mein file khol ke bolo:
1) Kaunsi classes/tables hain (User, Role-specific, Booking...)
2) Har table ka kaam 1 line
3) Relationships: 1-1 / 1-M / M-M, backref, cascade, lazy
4) Constraints: unique email, nullable, default status
Example skeleton
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), default='user')
    bookings = db.relationship('Booking', backref='user', cascade='all, delete-orphan')
```
ER diagram: rectangles entities, lines relationships, PK/FK mark. Schema = yahi structure.
Tables create: db.create_all() ya migrations. SQLite file SQL viewer se dikha sakte ho.

Explain the login flow and security checks.

Times asked 1

Official solution

SimpleLogin GET form dikhata hai, POST credentials check karke session set karta hai.

@app.route('/login', methods=['GET','POST'])
def login():
    if request.method == 'POST':
        u = User.query.filter_by(email=request.form.get('email')).first()
        if u and check_password_hash(u.password, request.form.get('password')):
            if getattr(u, 'blacklisted', False):
                flash('Blocked'); return redirect(url_for('login'))
            session['user_id'] = u.id
            session['role'] = u.role
            return redirect(url_for('dashboard'))
        flash('Invalid')
    return render_template('login.html')

Logout: session.clear(); redirect login. Incognito alag cookie jar — logged out dikhega.
Single login page: role se redirect alag dashboards.

9

Explain the CRUD operations from the admin side.

Times asked 1

Official solution

SimpleCRUD = Create, Read, Update, Delete — kisi bhi resource ke 4 basic operations.
Create: POST, db.session.add(new_user); commit() — register, add trek.
Read: GET, User.query.all() — dashboard list.
Update: POST/PUT, user.name = 'Ram'; commit() — edit profile.
DeletePOST/DELETE, db.session.delete(obj); commit().
REST mapping: POST create, GET read, PUT/PATCH update, DELETE delete.
Admin panel mein yeh 4 dikhana viva demo ka common task hai.
10
Explain the summary/dashboard page, especially the charts.

Times asked 1
Official solution

Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.
1) Yeh file/line kya role hai (model / route / template / config)?
2) Input kahan se aata hai (form, URL <id>, session, JSON)?
3) DB pe kya query/write?
4) Output kya (render_template / redirect / jsonify)?
Example
```
@app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.
```
Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.
11

Explain MVC architecture and show its implementation in your project.

Times asked 1

Official solution

SimpleMVC = Model-View-Controller. Code ko 3 hisson mein baant ta hai taaki mix na ho.
Model: data + DB. models.py — User, Trek, Booking classes.
View: jo user dekhta hai. templates/*.html + Jinja.
Controller: beech ka logic. routes / app.py — request lo, model se data, view ko do.
Example flow (register):
Browser form POST → Controller register() → User model save → redirect → View dashboard.html
Draw: Browser → Controller → Model → DB, phir Controller → View → Browser.
ORM na ho to bhi MVC ho sakta hai — Model raw SQL functions ho sakte hain. Structure matter karta hai, library nahi.
MVP/MVVM doosri architectures hain; MAD1 mein MVC expected hai.
12
What are Blueprints in Flask?

Times asked 2
Official solution

SimpleBlueprint Flask app ko modules mein baant ta hai — auth, admin, user alag files.
admin_bp = Blueprint('admin', __name__, url_prefix='/admin')
@admin_bp.route('/dashboard')
```
def dash(): ...
app.register_blueprint(admin_bp)
```
Bina blueprint: sab routes ek app.py — chhote MAD1 ke liye theek. Alternative: multiple modules import karke app pe route attach, ya create_app factory.
Bada project: Blueprints = clean controllers.
13

Explain the routes in your project.

Times asked 1

Official solution

SimpleRoutes/controllers URLs handle karte hain. app.py app banata hai, models.py data, templates/ views, static/ CSS-JS.
Typical structure:
app.py / __init__.py → Flask app, db.init, register blueprints
models.py → tables
routes.py / views → @app.route functions
templates/ → Jinja HTML
static/ → css, images
instance/*.db → SQLite
Ek route explain karne ka template:
1) URL + methods 2) Auth/role check 3) Form/query se data 4) Business rule (duplicate, slots) 5) db.session 6) render ya redirect
Example GET+POST same route: GET form, POST save.
Data HTML se: form name= → request.form. Data HTML ko: render_template(..., items=query).
Nayi .py file: import karke use karo, warna Flask ko pata nahi. Folder rename: imports/paths/templates check.
14
Write a Flask function to display all unapproved drives.

Times asked 1
Official solution

Patternfilter query → template/JSON. Examiner jo entity bole us class ka naam use karo.
```
@app.route('/admin/blacklisted')
def blacklisted():
    rows = User.query.filter_by(is_blacklisted=True).all()
    return render_template('list.html', rows=rows)

JSON: return jsonify([{'id': r.id, 'name': r.name} for r in rows])
ID se: User.query.get_or_404(id)
Do filters: .filter(Drive.approved==False, Drive.title=='Data Scientist')
```
Join example: students jinhone blacklisted company ke drive pe apply kiya — join Application-Drive-Company.
PUT@app.route('/x/<int:id>', methods=['PUT']) + request.get_json()
url param display: @app.route('/show/<int:id>') return render_template('show.html', id=id)
Form → next page: POST values render_template('out.html', **request.form)
Count: return str(User.query.filter_by(is_blacklisted=True).count())
15
Difference between Authentication and Authorization.

Times asked 20
Official solution

SimpleAuthentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password check karke prove karte ho ki tum genuine user ho. Success pe session/token milta hai.
Authorization: uske baad role check. Admin hi parking lot delete kar sakta hai, normal user nahi.
Example (Flask):
# Authentication
```
if user and check_password_hash(user.password, form_password):
    session['user_id'] = user.id

# Authorization
if session.get('role') != 'admin':
    abort(403)  # logged in ho, lekin allowed nahi
```
Project example: student login = authentication. Student admin dashboard nahi khol sakta = authorization.
Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+).
16
Show where Authentication and Authorization are implemented in your code.

Times asked 1
Official solution

SimpleAuthentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password check karke prove karte ho ki tum genuine user ho. Success pe session/token milta hai.
Authorization: uske baad role check. Admin hi parking lot delete kar sakta hai, normal user nahi.
Example (Flask):
# Authentication
```
if user and check_password_hash(user.password, form_password):
    session['user_id'] = user.id

# Authorization
if session.get('role') != 'admin':
    abort(403)  # logged in ho, lekin allowed nahi
```
Project example: student login = authentication. Student admin dashboard nahi khol sakta = authorization.
Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+).
17
What is ORM?

Times asked 49
Official solution

SimpleORM = Object Relational Mapping. Database tables ko Python classes/objects se map karta hai, raw SQL kam likhni padti hai.
Bina ORM: cursor.execute('SELECT * FROM user WHERE id=?', [5])
ORM se: User.query.get(5) ya db.session.get(User, 5)
Example model
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)
```
FaydePython mein soch sakte ho, SQL injection se protection (parameterized), relationships easy, DB switch thoda aasan.
Nuksaancomplex queries slow/abstract, seekhne ki layer extra, kabhi raw SQL phir bhi chahiye.
MAD1: SQLAlchemy (Flask-SQLAlchemy). Tables db.create_all() ya migrations se banti hain.
18

What is Data Normalization?

Times asked 1

Official solution

SimpleNormalization data ko split karke redundancy aur update-anomalies kam karti hai.
1NF: atomic values, repeating groups nahi (comma-separated skills mat rakho).
2NF: 1NF + non-key columns poori PK pe depend (composite keys pe).
3NF: 2NF + non-key columns ek doosre pe depend na hon (city→state alag table).
Examplehar booking mein user ka poora address copy vs user_id se User table.
MAD1 project generally 3NF ke kareeb. Higher NF (BCNF) theoretically, practical apps denormalize speed ke liye (cached counts).
Leaderboard: alag table better agar history/rank chahiye; sirf count hai to query se bhi ho sakta hai.
19
What is a RESTful API?

Times asked 4
Official solution

SimpleAPI = Application Programming Interface — do systems predefined rules se baat karti hain. REST API HTTP + JSON use karti hai.
Controller/route HTML bhi return kar sakta hai. REST API generally JSON return karti hai, frontend alag ho (Vue/Postman).
Example
```
@app.route('/api/users/<int:id>')
def get_user(id):
    u = User.query.get_or_404(id)
    return jsonify(id=u.id, name=u.name)
```
MAD1 HTML apps mein 'API' kabhi-kabhi routes ko hi keh dete hain. Agar Vue nahi to bolo: server-rendered Flask, JSON APIs optional.
Boolean return: technically jsonify(True) ho sakta hai, lekin meaningful JSON object better. Flask view None return kare to error.
Test: Postman se GET/POST.
Parsing: request.get_json() body se, request.args query se.
20

Difference between RESTful and RESTless APIs.

Times asked 1

Official solution

SimpleREST ek architecture style hai, RESTful API us style ko follow karti hai.
REST principles: client-server, stateless, cacheable, uniform interface (HTTP verbs + URLs), layered system.
RESTful: GET /users, POST /users, PUT /users/1, DELETE /users/1 — resources nouns, actions verbs.
RESTless: ek hi /api endpoint, action query mein (?action=delete) — REST rules nahi.
MAD1 mein Flask routes REST-like ho sakte hain chahe jsonify na ho. HTML forms bhi resources pe CRUD karti hain.
21

Difference between HTTP and HTTPS.

Times asked 6

Official solution

SimpleHTTP plain text bhejta hai, HTTPS encrypted bhejta hai.
HTTP: data beech mein koi padh sakta hai (password, session). Port 80. Padlock nahi.
HTTPS: SSL/TLS se encrypt. Port 443. Certificate verify hota hai. Man-in-the-middle mushkil.
Examplecafe WiFi pe HTTP login karo to password sniff ho sakta hai. HTTPS pe attacker ko garbage dikhega.
Viva: HTTPS = HTTP + encryption + identity (certificate). Production apps hamesha HTTPS.
22

Difference between Inline, Internal, and External CSS.

Times asked 3

Official solution

SimpleCSS 3 tarikon se lagti hai, priority Inline > Internal > External (same specificity pe).
Inline: style='color:red' element pe. Highest priority, lekin reuse nahi. Debugging mushkil.
Internal: <style> tag HTML head mein. Us page tak limited.
External: style.css file. Large project ke liye best — ek jagah change, saari pages update.
Example same button pe teeno:
/* external */ .btn { color: blue; }
/* internal */ .btn { color: green; }
 <button class='btn' style='color:red'> → red jeetega
ID (#box) class (.btn) se strong, class element (button) se strong.
!important sabko override karta hai — avoid karo.
Large project: external CSS preferred.
23

Add a new Age field to the registration form and print its value in the terminal.

Times asked 1

Official solution

Simple 4-step: Model → DB → Form → Route → Template. Yeh sabse common live-coding hai.
1) models.py: age = db.Column(db.Integer, nullable=True)
2) DB: SQLite viewer se column, ya DB delete karke create_all, ya ALTER TABLE user ADD COLUMN age INTEGER; production mein Flask-Migrate.
3) register.html: <input type='number' name='age' min='18' required>
4) route: user.age = request.form.get('age', type=int); commit
5) dashboard: {{ user.age }} admin table mein <td>{{ u.age }}</td>
Print terminal: print('AGE', request.form.get('age'))
Phone/city same pattern, String(20). Openings on Drive: integer column + form + create_drive route.
24
Modify the application so a company cannot create another drive if it already has one active drive.

Times asked 1
Official solution

Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:
Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.
Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.
Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
Live change maange to: related model → route → template, phir browser refresh karke dikhao.
Example (generic create):
obj = Model(name=request.form.get('name'))
```
db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
```

Student reviews

Approved viva sets

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet

My solution

Community answers

No community answers yet