Proctor level1_viva21

Student reviews

Rajeswari MAD1 Aug 16, 2026

she is good..giving enough time

Questions remembered

asked to download the project from the portal
run the project
asked to register as trekker and staff..then login
asked to do some functionalities as she said
which database have you used & and point where the database is
what is session
change the color of the heading
write the code of the route to print "hello world"
write a query to filter all the bookings

Piyush MAD1 Aug 16, 2026

practice codes changes before viva

Questions remembered

1 . First of all She asked me to show GitHub project repo.
2.Then apply as two different Staffs and approve them through admin portal.
3.Then create a two Treks and assign each of those staffs to them.
4.Then go to one of the staff dashboard and update the slot to 1.
5.Signup as two new users and login through one of them.
6.Then edit user profile;
7.Then book a trek with that user which slot has been recently updated.
8.Then login as another one and try to book for that same trek. (She wanted to check if I have prevented Overbooking, which I did).
9.Then again login to admin dashboard and show the bookings.
10.In the bookings page she told to change the color from green to some other color, which I did.
11.Then she asked to write a query to see only the blacklisted users in your admin/users route
12.change the heading color of your file
13.write a route which returns hello
14.For the theory, She asked What db did u use, what is ORM, which orm i used
15.At last she said okay bye and left

Hitesh Tiwari MAD1 Aug 16, 2026

Just a nice proctor 👍

Questions remembered

She ask me to open the GitHub repository then show collaboration.
Then ask to download the project from the viva portal.
Run the project
Open the admin dashboard in the browser then register as new two staff then approve it from the admin dashboard
Then same for user.
Means she is checking all the required things are present in the project or not.
Then ask me to change the color of completed button in admin dashboard in booking page ( I know how to do that but when I change the color it is not working then I tried multiple times then suddenly worked).
Then asked what is orm, did you used that,which orm you used.
What is session? What are the datatypes of sessions?
What is the backend validation,show me in the code.
Which database you have used?
And also ask me to change the route of bookings page in admin dashboard that it will only show the completed bookings then ask to explain what I have changed.
Then she said that's it now you can leave.

Aditya Gumgaonkar MAD1 Aug 16, 2026

Overall very chill proctor, she is mostly quiet and gives enough time to perform the task.

Questions remembered

Level1_21
Run the app
Show admin, create new staff and approve by admin
Create new trek and assign it to the new staff
Create new user and book that particular trek
Update trek status and slots
Change color of Admin dashboard
In bookings section only show pending requests
What db did u use, what is ORM, what is session, what is the data type of session

Shashwatam Shashank MAD1 Aug 16, 2026

She was not strict but also little annoying, because doesn't speak much and after I did what she said, she goes to silent mode. I have to ask each time What to do next?
As for the questions-answer time she did give time to think and doesn't seem to be in a hurry. Altogether a chill but silent proctor, do what she says.

Questions remembered

I joined 5 minutes early from the allotted time, but the proctor joined 5 minutes late
She took extra 20-25 minutes before starting the viva.
First of all She asked me to show GitHub project repo.
Then apply as two different Staffs and approve them through admin portal.
Then create a two Treks and assign each of those staffs to them.
Then go to one of the staff dashboard and update the slot to 1.
Signup as two new users and login through one of them.
Then edit his profile; ---> Here, I got a small error because I forgot to add session in db.session.commit so I told her I can fix the error and she allowed me to do so.
Then book a trek with that user which slot has been recently updated.
Then login as another one and try to book for that same trek. (She wanted to check if I have prevented Overbooking, which I did).
Then again login to admin dashboard and show the bookings.
In the bookings page she told to change the color from green to some other color, which I did.
Then she asked to explain the particular route through which the booking page is handled
Then she asked me to add a line in the code to extract the users who haven't given their mobile numbers during registration because mobile number is nullable in my project. I couldn't perform this task.
For the theory, She asked different types of http methods difference between GET POST, which database I have used, which function is used to extract data from server and view it in the frontend (something like that only)
At last she said okay bye and left

Approved viva sets

See reviews level1_viva21 MAD1 Level 1

Aug 16, 2026

Copy set link

1

asked to register as trekker and staff..then login

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.
2

asked to do some functionalities as she said

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
3
write the code of the route to print "hello world"

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'
```
4

write a query to filter all the bookings

Times asked 1

Official solution

Simplefilter manager_id / company name / approved. Same Query API. Write query fetch treks/jobs/drives.
Examiner project-specific names — same pattern.
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: Drive.query.filter_by(approved=True)

Advice: she is good..giving enough time

See reviews level1_viva21 MAD1 Level 1

Aug 16, 2026

Copy set link

1
11.Then she asked to write a query to see only the blacklisted users in your admin/users route

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'
```
2
12.change the heading color of your file

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.
3
13.write a route which returns hello

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: practice codes changes before viva

See reviews level1_viva21 MAD1 Level 1

Aug 16, 2026

Copy set link

1
She ask me to open the GitHub repository then show collaboration.

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.
2
Run the project

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

Open the admin dashboard in the browser then register as new two staff then approve it from the admin dashboard

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
Then same for user.

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
Means she is checking all the required things are present in the project or not.

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.
6

Then she said that's it now you can leave.

Times asked 1

Official solution

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

Advice: Just a nice proctor 👍

See reviews level1_viva21 MAD1 Level 1

Aug 16, 2026

Copy set link

1

Level1_21

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
Run the app

Times asked 2
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

Show admin, create new staff and approve by admin

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

Create new trek and assign it to the new staff

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

Create new user and book that particular 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
Change color of Admin dashboard

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.
7

In bookings section only show pending requests

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.

Advice: Overall very chill proctor, she is mostly quiet and gives enough time to perform the task.

See reviews level1_viva21 MAD1 Level 1

Aug 16, 2026

Copy set link

1

I joined 5 minutes early from the allotted time, but the proctor joined 5 minutes late

Times asked 1

Official solution

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

She took extra 20-25 minutes before starting the viva.

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
3
First of all She asked me to show GitHub project repo.

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.
4
Then apply as two different Staffs and approve them through admin portal.

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

Then go to one of the staff dashboard and update the slot to 1.

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
6
Signup as two new users and login through one of them.

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.
7
Then edit his profile; ---> Here, I got a small error because I forgot to add session in db.session.commit so I told her I can fix the error and she allowed me to do so.

Times asked 1
Official solution

SimpleMAD1 mein usually session-based auth: login pe session['user_id'], har request pe verify.
Example
```
session['user_id'] = user.id
uid = session.get('user_id')
user = User.query.get(uid)
```
Viva tipSECRET_KEY set karo warna session insecure. logout pe session.clear().
8

Then book a trek with that user which slot has been recently updated.

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.
9

Then login as another one and try to book for that same trek. (She wanted to check if I have prevented Overbooking, which I did).

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.
10
In the bookings page she told to change the color from green to some other color, which I did.

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.
11

Then she asked to explain the particular route through which the booking page is handled

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.
12

Then she asked me to add a line in the code to extract the users who haven't given their mobile numbers during registration because mobile number is nullable in my project. I couldn't perform this task.

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

At last she said okay bye and left

Times asked 1

Official solution

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

Advice: She was not strict but also little annoying, because doesn't speak much and after I did what she said, she goes to silent mode. I have to ask each time What to do next? As for the questions-answer time she did give time to think and doesn't seem to be in a hurry. Altogether a chill but silent proctor, do what she says.

See reviews level1_viva21 MAD1 Level 1

Aug 1, 2026

Copy set link

1

Show your College ID.

Times asked 16

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

Show your GitHub repository and collaborator.

Times asked 16

Official solution

SimpleGitHub repo public/private policy ke hisaab, MAD-1 collaborator add, commits dikhao.
Repo → Settings → Collaborators → instructor added.
Commits: git log / GitHub History — regular commits better, ek dum 1 commit suspicious.
README + report mein AI usage likha hona chahiye agar use kiya.
3

Download the project from the Viva Portal.

Times asked 7

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.
4

Run the application.

Times asked 8

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.
5

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.
6

Register and log in with different user roles (Admin, Staff, User/Trekker).

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.
7

Approve staff accounts from the Admin dashboard.

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.
8
Create and assign treks.

Times asked 1
Official solution

Yeh project-specific feature add/modify hai. 4 layers touch karo: model, route, template, validation.
1) Data chahiye to models.py mein column/relationship + DB update (ALTER / migrate / create_all).
2) Route: GET pe form/page, POST pe request.form se save, flash + redirect.
3) Template: input name=... Jinja se {{ obj.field }} display.
4) Rule: duplicate, range, role check backend pe.
Example naya field 'city':
```
user.city = db.Column(db.String(50))
user.city = request.form.get('city')
<input name='city'>  ...  {{ user.city }}
```
9
Update trek slots/status.

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'))
```
10
Edit user profile.

Times asked 1
Official solution

Yeh project-specific feature add/modify hai. 4 layers touch karo: model, route, template, validation.
1) Data chahiye to models.py mein column/relationship + DB update (ALTER / migrate / create_all).
2) Route: GET pe form/page, POST pe request.form se save, flash + redirect.
3) Template: input name=... Jinja se {{ obj.field }} display.
4) Rule: duplicate, range, role check backend pe.
Example naya field 'city':
```
user.city = db.Column(db.String(50))
user.city = request.form.get('city')
<input name='city'>  ...  {{ user.city }}
```
11

Book a trek and demonstrate overbooking prevention.

Times asked 1

Official solution

SimpleDuplicate/overbook rokne ke liye DB constraint + route check dono.
Pehle query: Booking.query.filter_by(user_id=uid, trek_id=tid).first()
Agar exists: flash('Already booked'); return
Slots: if trek.available <= 0: reject else trek.available -= 1; commit
Race condition: unique(user_id, trek_id) constraint — do tabs se double click pe bhi ek hi row.
Blacklist: login pe is_blacklisted check.
Active drive limit: if Company ke paas status=open drive hai to naya mat banne do.
12

Show bookings in the Admin dashboard.

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.
13

Modify app.py.

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

Explain a specific route (e.g., booking route).

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.
15

Explain the route logic.

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.
16
Show backend validation in your code.

Times asked 1
Official solution

SimpleValidation galat data rok ti hai — frontend turant, backend must.
Frontend: required, min='18', maxlength='8', pattern='(?=.*[A-Z]).{8,}'
Backend example:
```
pwd = request.form.get('password','')
if len(pwd) < 8 or not re.search(r'[A-Z]', pwd) or not re.search(r'[0-9]', pwd):
    flash('Weak password')
```
Haan, regex se password rules ho sakte hain.
Age 18-99, date >= today, slots <= 30 and > 0, confirm password == password, email '@' .
Duplicate username: User.query.filter_by(email=email).first() or unique=True catch IntegrityError.
Past date: if date < date.today(): reject. Negative slots: if slots < 0: reject; book pe available > 0 check.
17

Which database have you used?

Times asked 4

Official solution

SimpleSQLite file-based chhota DB, MySQL/Postgres server-based production DB.
SQLite fayde: zero setup, ek .db file, MAD1/dev ke liye perfect, portable.
Nuksaanconcurrent writes kam, user/password nahi, network access nahi, production scale nahi.
MySQL: users, permissions, concurrent, replica. App factory mein URI change karke switch: sqlite:///app.db → mysql://...
18

Where is your database configured/located?

Times asked 1

Official solution

Definition style question: 1 line simple Hinglish + project example + mini code.
Template'X ka kaam Y hai. Mere project mein Z jagah use hua.'
Example'Session login state rakhta hai. session[user_id]=u.id login pe, logout pe session.clear().'
Agar topic Vue/Celery/Redis ho aur project mein nahi hai to sach bolo, theory example do.
19
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.
20
Which ORM have you used?

Times asked 3
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.
21
Write a query to: Display only shortlisted students. Display only pending/completed bookings. Display only blacklisted users. Display bookings matching a filter condition. Display users with NULL mobile numbers.

Times asked 1
Official solution

SimpleBlacklist flag user/company ko block karta hai — login ya features band.
user.is_blacklisted = True; db.session.commit()
Login: if user.is_blacklisted: flash('Blocked'); return
Student dashboard: blacklisted company ke drives hide — query filter join Company.is_blacklisted==False.
Demo: admin blacklist → us user se login fail.
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())
22

Explain how cascading delete is implemented (e.g., deleting a company also deletes its drives).

Times asked 1

Official solution

SimpleCascade parent ke saath child pe automatic action (generally delete).
Company delete → uski drives bhi delete, warna orphan rows / FK error.
SQLAlchemy: db.relationship('Drive', cascade='all, delete-orphan', backref='company')
SQL: ForeignKey(..., ondelete='CASCADE')
Cascade sirf delete nahi: save-update, merge, refresh-expire, expunge, delete-orphan.
Cascade Update: parent PK change to child FK update (rare, PK mat badlo).
Parent delete jab children active hon: constraint error, ya cascade se children gayab, ya pehle children handle karo — design choice examiner poochta hai.
CSS cascading alag topic hai (styles inherit/override).
23
What is url_for()?

Times asked 4
Official solution

Simpleurl_for Flask function/endpoint name se URL generate karta hai, hardcode path nahi.
```
url_for('home') → '/'
url_for('edit_user', id=5) → '/user/5/edit'
Templates: href="{{ url_for('login') }}"
```
Parameter: endpoint ka naam (function name), plus route variables.
Galat naam: BuildError. Route rename karo to url_for automatic naya path dega — yahi fayda hai.
24
Which parameter is passed to url_for()?

Times asked 1
Official solution

Simpleurl_for Flask function/endpoint name se URL generate karta hai, hardcode path nahi.
```
url_for('home') → '/'
url_for('edit_user', id=5) → '/user/5/edit'
Templates: href="{{ url_for('login') }}"
```
Parameter: endpoint ka naam (function name), plus route variables.
Galat naam: BuildError. Route rename karo to url_for automatic naya path dega — yahi fayda hai.
25
What is render_template()?

Times asked 3
Official solution

Simplerender_template HTML file ko Jinja se process karke browser ko bhejta hai. Backend data ko frontend se jodta hai.
```
return render_template('dashboard.html', user=user, treks=treks)
```
File templates/dashboard.html honi chahiye.
Keyword arguments template mein variables ban jaate hain: {{ user.name }}.
Route kuch return na kare to Flask error. Boolean return typical HTML view ke liye nahi — string/Response chahiye.
26

How is data passed from the backend to the frontend?

Times asked 1

Official solution

Simple flow: Browser → Route (controller) → Model/DB → phir template (view) → Browser.
Submit example:
1) HTML form POST /register, name='email'
2) register() request.form.get('email')
3) User(email=...) ; db.session.add; commit
4) redirect dashboard
5) dashboard query + render_template
6) Jinja {{ user.email }} / {% for %}
GET search: /search?q=flask → request.args.get('q') → filter ilike → template list.
JSON API: jsonify, frontend fetch().
27
Write a basic Flask route (e.g., Hello World).

Times asked 1
Official solution

Simple Hello World — notepad mein yeh likh ke run karke dikhao:
```
from flask import Flask
app = Flask(__name__)
@app.route('/')
def home():
    return 'Hello World'
if __name__ == '__main__':
    app.run(debug=True)

Jinja version: return render_template('hello.html', name='Shubham')
```
hello.html: <h1>Hello {{ name }}</h1>
POST-only: @app.route('/x', methods=['POST'])
28

What is a session?

Times asked 1

Official solution

SimpleFlask session request-across data store karta hai, generally signed cookie mein.
session['user_id'] = user.id
uid = session.get('user_id')
session.clear() # logout
Type: dictionary-like (SecureCookieSession). SECRET_KEY se sign — tamper detect.
Store kahan: default client cookie. Server-side Redis/filesystem bhi laga sakte ho.
Browser storage: cookies, localStorage, sessionStorage. Session cookie tab-close pe jaa sakti hai.
Remember-me: permanent session ya alag token cookie.
29

What is the data type of a session?

Times asked 1

Official solution

SimpleFlask session request-across data store karta hai, generally signed cookie mein.
session['user_id'] = user.id
uid = session.get('user_id')
session.clear() # logout
Type: dictionary-like (SecureCookieSession). SECRET_KEY se sign — tamper detect.
Store kahan: default client cookie. Server-side Redis/filesystem bhi laga sakte ho.
Browser storage: cookies, localStorage, sessionStorage. Session cookie tab-close pe jaa sakti hai.
Remember-me: permanent session ya alag token cookie.
30
Explain server-side/backend validation.

Times asked 1
Official solution

SimpleValidation galat data rok ti hai — frontend turant, backend must.
Frontend: required, min='18', maxlength='8', pattern='(?=.*[A-Z]).{8,}'
Backend example:
```
pwd = request.form.get('password','')
if len(pwd) < 8 or not re.search(r'[A-Z]', pwd) or not re.search(r'[0-9]', pwd):
    flash('Weak password')
```
Haan, regex se password rules ho sakte hain.
Age 18-99, date >= today, slots <= 30 and > 0, confirm password == password, email '@' .
Duplicate username: User.query.filter_by(email=email).first() or unique=True catch IntegrityError.
Past date: if date < date.today(): reject. Negative slots: if slots < 0: reject; book pe available > 0 check.
31

Explain HTTP methods.

Times asked 3

Official solution

SimpleHTTP methods batate hain request kya karna chahti hai. Common: GET POST PUT PATCH DELETE.
GETread/fetch. Safe, URL se. Page kholna, search.
POSTcreate/submit. Form, login.
PUTpoora replace/update. Idempotent.
PATCHpartial update.
DELETEhataana.
HEAD: sirf headers. OPTIONS: CORS preflight.
Flask: @app.route('/x', methods=['GET','POST'])
Agar methods na likho to default sirf GET.
HTML form native sirf GET/POST. PUT/DELETE JS/fetch ya hidden _method se.
GET se data fetch ho sakta hai, create nahi karna chahiye. POST se theoretically fetch ho sakta hai lekin cache/semantics galat.
DELETE fetch ke liye nahi. GET POST ka kaam officially nahi karta — side effects GET pe mat rakho.
32
Difference between GET and POST.

Times asked 7
Official solution

SimpleGET data mangta hai (read), POST data bhejta hai (create/submit).
GETURL mein dikhta hai, bookmark ho sakta hai, browser back/refresh safe hai, data URL query mein jaata hai. Search, page open, login form dikhana.
POSTbody mein data jaata hai, URL mein password nahi dikhta, refresh pe dubara submit ho sakta hai. Login, register, form save.
Example
# page dikhana
```
@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'GET':
        return render_template('login.html')
    # POST: form submit
    email = request.form.get('email')
    ...
```
GET se theoretically data bhej sakte ho (?q=flask), lekin create/update ke liye nahi use karna — data log/history mein save ho jaata hai, length limit hoti hai.
HTML form default GET hota hai; method='POST' likhna zaroori hai login/register pe.
33

Change the color of a button, heading, or dashboard element.

Times asked 1

Official solution

Simpleexaminer UI tweak maangta hai — CSS class ya inline, instantly dikhao.
Button color: <button class='btn btn-success'> ya style='background:#22c55e;color:#fff'
Navbar: navbar-dark bg-success / style='background:yellow' / fixed-bottom se neeche.
Center: .wrap { display:flex; justify-content:center; align-items:center; min-height:100vh; }
text-align:center heading ke liye. Bootstrap: d-flex justify-content-center, mx-auto, text-center.
Hover: .btn:hover { opacity:0.8; transform:scale(1.02); }
Half width: class='col-6' ya width:50%. Row→column: flex-direction:column / col-12 stack.
Login card: card shadow p-4 mx-auto (max-width:400px).
Table header green: th { background:green; color:white; } Bold column: td:nth-child(2){font-weight:bold}
Box shadow: box-shadow: 4px 4px 12px rgba(0,0,0,.3);
Background image: body { background: url('/static/bg.jpg') center/cover; }
Reset button: <button type='reset'>Clear</button>
Move button: ms-auto / position / flex order.
Jinja dashboard heading: <h1>{{ user.name }}'s Dashboard</h1>
34
Modify a page to display only filtered records (e.g., shortlisted students, pending/completed bookings).

Times asked 1
Official solution

Yeh list filter/sort/display task hai. Query badlo, template same rakh sakte ho.
```
rows = Model.query.filter_by(status='approved').order_by(Model.name.asc()).all()
```
Jinja: {% for r in rows %}<tr><td>{{ r.name|upper }}</td></tr>{% endfor %}
```
{{ rows|length }} count dikhane ke liye.
```
Alphabet sort: order_by(Model.name). Status filter: filter_by(status='pending').
Assigned staff column: relationship se {{ booking.staff.name }}.
35
Add a small frontend feature or UI improvement.

Times asked 1
Official solution

Simple2-3 honest improvements + 1 security + 1 UX.
Example
```
password hashing/CSRF tighter, Redis cache, tests, pagination, email verify, rate limit login, better mobile CSS.
```
Challenges: relationships/cascade, concurrent booking, Jinja inheritance.
Rate: 7-8/10 with reason — 10/10 arrogant, 3/10 confidence khatam.
Security extra: HTTPS, hashed passwords, CSRF, SQL injection (ORM), login attempts, file type check.
36
Modify a route/query to apply filtering logic.

Times asked 1
Official solution

Yeh list filter/sort/display task hai. Query badlo, template same rakh sakte ho.
```
rows = Model.query.filter_by(status='approved').order_by(Model.name.asc()).all()
```
Jinja: {% for r in rows %}<tr><td>{{ r.name|upper }}</td></tr>{% endfor %}
```
{{ rows|length }} count dikhane ke liye.
```
Alphabet sort: order_by(Model.name). Status filter: filter_by(status='pending').
Assigned staff column: relationship se {{ booking.staff.name }}.

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