Search – Lazy IITians Viva Prep

Aug 16, 2026

Copy set link

1
What database have you used

Times asked 1
Official solution

SimpleSQLite file-based DB — setup easy, MAD1 ke liye perfect. Production heavy traffic pe Postgres better.
Example
```
SQLALCHEMY_DATABASE_URI = 'sqlite:///app.db'
```
2
Change Code to reflect appointments which are only completed and not all appointments (I was on as in dashboard at that time so changed that part only)

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.

Advice: If you download the project, the checksum won't be done. Open github to show repository. Start app and start vs code. No need to formalis the flow, the viva examiner will ask you to show functionalities one by one.

See reviews LEVEL3VIVA12 MAD1 Level 3

Aug 16, 2026

Download all Download all

Copy set link

1
the exact same code changes and and questions were asked on 13-12-2025

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: 10 mins given for code change. Expects fast answers.

See reviews Level1_14 MAD1 Level 1

Aug 16, 2026

Download all Download all

Copy set link

1

Show your app.

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
Show functionalities of all users( Admin, 1 Doctor, 1 patient)-- this will be checked in depth: -- register patient, --register a new doctor, --book an appointment, --cancel+ reschedule an appointment, --check if you can do multiple appointments at the same time. --check if a patient can access their prescription. --check if doctor can access their treatments. --check if doctor can change their availability.

Times asked 1
Official solution

SimpleEdge cases: duplicate booking, full capacity, wrong role URL, empty search, invalid id.
Example
```
if Spot.query.get_or_404(spot_id).status != 'available':
    flash('Already taken')
    return redirect(...)
```
3
What is the primary key of each model(in the code).

Times asked 1
Official solution

SimplePrimary key row ka unique identity — usually id Integer autoincrement.
Example
```
id = db.Column(db.Integer, primary_key=True)
```
4

Write a code to show the list of all doctors, their departments, their experience in years on the landing page(this list was not on my landing page).

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

Show how your changes are getting updated dynamically. Theory:

Times asked 1

Official solution

SimpleTheory = concepts: ORM, MVC, auth vs authz, Jinja inheritance, sessions. 1-line def + project example.
6

Explain all HTTP methods

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.
7
Explain how you are doing backend validation.

Times asked 1
Official solution

SimpleValidation = input rules: required, email format, length, unique. Frontend UX, backend security — dono.
Example
```
if not email or '@' not in email:
    flash('Invalid email')
    return redirect(request.url)
if User.query.filter_by(email=email).first():
    flash('Email taken')
```

Advice: Know your code. He asks almost same theory to everyone( Check other entries). But he will give coding task.

See reviews Level3_45 MAD1 Level 3

Aug 16, 2026

Download all Download all

Copy set link

1

Explain render template

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
Add disease column in patient table

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.
3
Db.relationship def

Times asked 1
Official solution

Simpledb.relationship se object graph: lot.spots, booking.user. backref reverse side auto deta hai.
Example
```
spots = db.relationship('Spot', backref='lot', cascade='all, delete-orphan')
```
4
Backref and backpopulate def

Times asked 1
Official solution

Simplebackref reverse attribute auto banata hai. back_populates dono sides explicitly naam dete ho — clearer.
Example
```
# backref
spots = db.relationship('Spot', backref='lot')
# spot.lot available

# back_populates
spots = db.relationship('Spot', back_populates='lot')
# Spot.lot = db.relationship('Lot', back_populates='spots')
```
5

Usecase of secondary

Times asked 1

Official solution

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

Go to controllers and explain route for patient

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.
7
Diff bw get and 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')
```
8
Can we send data through get

Times asked 1
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.
9
Request.form and request.args

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
```
10

Use of render template

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
11
Diff bw get and filter by

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

Use of fstring

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
13
write a piece of codee in jinja2, where the code will display a dr name and the patients assigned ..

Times asked 1
Official solution

SimpleJinja2 Flask ka template engine — HTML ke andar {{ }} variables, {% %} logic.
Example
```
{% for lot in lots %}
  <li>{{ lot.name }} — {{ lot.spots }}</li>
{% else %}
  <p>No lots</p>
{% endfor %}
```
14
Write a code in jinja2 , where it will look for appointments for a particular patient,, if there's no appointment, than show no appt available

Times asked 1
Official solution

SimpleJinja for loop list render karta hai. loop.index, else branch empty list pe.
Example
```
{% for u in users %}
  <tr><td>{{ loop.index }}</td><td>{{ u.email }}</td></tr>
{% endfor %}
```
15

Structured and unstructured database

Times asked 1

Official solution

Difference question hai — 3 cheezein bolo: meaning, kab use, 1 example.
Pehle concept A ek line, phir B ek line, phir table-jaisa farq (input/output/side-effect).
Example hamesha MAD1 se: GET search page, POST register, PUT/PATCH API update, session vs cookie login.
16
Write a route for updating patient treatment form

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'
```
17
Patient name should be clickable in dr dash,and when dr clicks on this than it should redirect to treatment .

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'))
```
18

app demo

Times asked 3

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.
19
Z index in css

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.
20
SQLALCHEMY benchmark or something .

Times asked 1
Official solution

SimpleSQLAlchemy MAD1 ka common ORM. Flask-SQLAlchemy wrapper se db.Model, db.session.
Example
```
user = User(email='a@b.com')
db.session.add(user)
db.session.commit()
users = User.query.filter_by(role='admin').all()
```
21
How do you return json in flask .

Times asked 1
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.
22

How do you change host/host no.

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.
23
Default port no. Of flask

Times asked 1
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.
24

How will you test the database without creating frontend.

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

Version control meaning

Times asked 1

Official solution

SimpleGit version control: commit history dikhao. VCS = Version Control System.
26

Use of debug=true

Times asked 1

Official solution

SimpleDebug: terminal traceback padho, print/logging, Flask debug, browser Network/Console, reproduce minimum steps.

Advice: She is helpful and friendly ,just have a deep understanding of theory concepts and few code changes ..😊

See reviews Level1_14 MAD1 Level 1

Aug 16, 2026

Download all Download all

Copy set link

1
what is jinja

Times asked 2
Official solution

SimpleJinja2 Flask ka template engine — HTML ke andar {{ }} variables, {% %} logic.
Example
```
{% for lot in lots %}
  <li>{{ lot.name }} — {{ lot.spots }}</li>
{% else %}
  <p>No lots</p>
{% endfor %}
```
2

how relations are implemented

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: honestly very cool person gave time to think helped to implement stuff and help understand clearly what he is asking and if any functionality is missing would say to you to implement that on spot make sure everything is implemented if not then just learn how to do them so you can during the viva

See reviews Level1_93 MAD1 Level 1

Aug 16, 2026

Download all Download all

Copy set link

1

• Asked for a demo (she gave me intructions what to do and i followed them)

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

• Asked me to show the main file

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

• Asked me to show where i have done the imports

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 me about sessions

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().
5
• Asked me about CSS priority

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
• Asked me about some error codes which i couldn't answer

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'
```
7
• Asked me to write a route to display my name

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: Proctor was really good and helpful. I was nervous before but got at peace as soon as viva started.

See reviews Level1_126 MAD1 Level 1

Aug 16, 2026

Download all Download all

Copy set link

1

Quick Go Through The Application. Ask you to disable your auto complete on VS code!

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

Explain hashing? if not implemented would ask to Hash your password?

Times asked 1

Official solution

SimpleJo miss hai honestly bolo + why (time). Agar examiner maange to quick plan: kahan add karoge.
3
Explain the Model.py file

Times asked 2
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)
```
4

Explain admin_dashboard Route.

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.
5
What is uselist (I have used it While defining a relationship in the model.py file, so he asked)

Times asked 2
Official solution

Simpledb.relationship se object graph: lot.spots, booking.user. backref reverse side auto deta hai.
Example
```
spots = db.relationship('Spot', backref='lot', cascade='all, delete-orphan')
```
6
What is the difference between redirect and render_template?

Times asked 1
Official solution

Simplerender_template Jinja HTML file ko data deke final HTML banata hai.
Example
```
return render_template('dashboard.html', user=user, lots=lots)
```
7
What is templet inheritance?

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

He would ask you to write SQL query in Notepad : Write an SQL query to create a table name student and with two columns age and gender. write a basic SQL query to filter.all() from patients, doctor.

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
9
He asked me to add another search functionality to filter the doctor by experience? (As I did add seperately for the Doctor Specialization)

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()
```
10
How does Jinja Access the Variable?

Times asked 2
Official solution

SimpleJinja2 Flask ka template engine — HTML ke andar {{ }} variables, {% %} logic.
Example
```
{% for lot in lots %}
  <li>{{ lot.name }} — {{ lot.spots }}</li>
{% else %}
  <p>No lots</p>
{% endfor %}
```
11
How to write a for loop in jinja? Tip : Be prepared to make any changes in your code. Especially with the Admin, Doctor and Patient dashboard. Also, search functionality.

Times asked 1
Official solution

SimpleJinja for loop list render karta hai. loop.index, else branch empty list pe.
Example
```
{% for u in users %}
  <tr><td>{{ loop.index }}</td><td>{{ u.email }}</td></tr>
{% endfor %}
```

Advice: Tip : Try Booking a slot in the night for around 8-11PM, You get the proctor level details via email a day before the viva in the Night before 10PM. This way you get approx 12 hrs to prepare according to the proctor. Refer to the Viva question asked by this proctor previously and prepare accordingly. This way for sure you will be able to clear your Viva.

See reviews Level1_92 MAD1 Level 1

Aug 16, 2026

Download all Download all

Copy set link

1
First, She would check whether you add a collaborator on GitHub?

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

Show the complete project demo : Login as Admin, Add a Doctor, Add a Patient, Book an Appointment, Show Admin, Doctor, and Patient dashboards, Verify that all features work as per requirements. This would take 20-25 minutes

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
HTTP Methods. Where is only GET request used in your routes?

Times asked 1
Official solution

SimpleHTTP verbs REST ke tools. Methods HTTP ke hain, REST unhe convention se use karta hai.
GET read cacheable. POST create payload. PUT replace. PATCH patch. DELETE remove.
GET exists bina REST ke bhi — browser address bar.
HTTP verbs + status REST ki zabaan. GET read, POST create, PUT replace, PATCH partial, DELETE remove. GET typically no body.
Status: 200 OK, 201 created, 202 accepted (Celery task), 400 bad input, 401 no/bad token, 403 role nahi, 404 missing, 409 conflict (double book), 500 server.
AJAX/fetch page reload nahi. SPA poori isi pe. Postman se bina Vue ke API prove karo — examiner pasand.
Example
```
GET /api/venues
POST /api/venues
PUT /api/venues/1
DELETE /api/venues/1
```
Project example: resources.py methods list. Postman 4-5 calls.
Viva tipGET typically no body (cacheable). POST/PUT/PATCH haan payload. PUT idempotent, POST nahi.
4
Authentication vs Authorization. Explain how authorization is implemented in your application (Role-based access: admin / doctor / patient)

Times asked 1
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)
```
5

Dashboard Functionality : Explain what each dashboard does

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

How data is stored and retrieved. How tables are related (User, Doctor, Patient, Appointment)

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

Explain any route or function she points to. Explain filtering logic used in queries

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: Final Tip (Based on Your Experience) • She is polite and supportive • Focus is on functionality, not trick questions • Know your own code • Explain in simple words • Perform exactly what she asks during the demo

See reviews Level3_11 MAD1 Level 3

Aug 16, 2026

Download all Download all

Copy set link

1

Viva lvl 2:

Times asked 1

Official solution

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

-Showed id

Times asked 1

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

-showed app demonstration

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

-explain doctor create route

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: Chill, very easy, easier then level 1,no code changes

See reviews Level3_45 MAD1 Level 3

Aug 16, 2026

Download all Download all

Copy set link

1

Explain project folder structure

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
What is ORM

Times asked 4
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
```
3

What is VCS

Times asked 2

Official solution

SimpleGit version control: commit history dikhao. VCS = Version Control System.
4

Stateless vs Stateful

Times asked 1

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

Html semantic tags

Times asked 1

Official solution

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
6
Some CSS questions (basic)

Times asked 1
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.
7
How would you load more data from another column in Jinja using a for loop

Times asked 1
Official solution

SimpleJinja for loop list render karta hai. loop.index, else branch empty list pe.
Example
```
{% for u in users %}
  <tr><td>{{ loop.index }}</td><td>{{ u.email }}</td></tr>
{% endfor %}
```
8
Add a welcome message on dashboard

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
Add a text to the navigation topbar and make it appear in the center

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

Demonstrate any one template and routes used in it

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.
11
Explain flow of any one Flask 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'
```
12
url_for() vs redirect() vs render_template()

Times asked 1
Official solution

Simplerender_template Jinja HTML file ko data deke final HTML banata hai.
Example
```
return render_template('dashboard.html', user=user, lots=lots)
```
13
request.args vs request.session vs request.json

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().
14
Flask handle files

Times asked 1
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.
15

Debug mode

Times asked 1

Official solution

SimpleDebug: terminal traceback padho, print/logging, Flask debug, browser Network/Console, reproduce minimum steps.
16
Authentication vs Authorization

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)
```
17
What is secret key

Times asked 1
Official solution

SimpleSECRET_KEY Flask ka secret jisse session cookies sign/encrypt hoti hain.
```
app.config['SECRET_KEY'] = os.getenv('SECRET_KEY', 'dev-key')
```
Iske bina session/flash unreliable ya insecure. Key leak = attacker session forge kar sakta hai.
Hardcode mat karo production mein — .env / environment variable. Flash messages bhi session use karti hain, isliye SECRET_KEY se related hain.
Hataane pe session kaam nahi / warning. Change karne pe purane sessions invalid.
18

Where are the user credentials stored when they login

Times asked 1

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

Asked me something about the login page and route, checked if admin could create a doctor

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.
20
Explain database 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)
```
21
Foreign key

Times asked 1
Official solution

SimpleForeign key dusri table ke PK ko point karti hai — relationship banati hai.
Example
```
lot_id = db.Column(db.Integer, db.ForeignKey('lot.id'), nullable=False)
```
22
Relationships one to many and many to one

Times asked 1
Official solution

Simpledb.relationship se object graph: lot.spots, booking.user. backref reverse side auto deta hai.
Example
```
spots = db.relationship('Spot', backref='lot', cascade='all, delete-orphan')
```
23
How to achieve many to many relationship

Times asked 1
Official solution

Simpledb.relationship se object graph: lot.spots, booking.user. backref reverse side auto deta hai.
Example
```
spots = db.relationship('Spot', backref='lot', cascade='all, delete-orphan')
```
24
What is the secondary parameter in relationship()

Times asked 1
Official solution

Simpledb.relationship se object graph: lot.spots, booking.user. backref reverse side auto deta hai.
Example
```
spots = db.relationship('Spot', backref='lot', cascade='all, delete-orphan')
```
25
rollback() in SQLAlchemy

Times asked 1
Official solution

SimpleSQLAlchemy MAD1 ka common ORM. Flask-SQLAlchemy wrapper se db.Model, db.session.
Example
```
user = User(email='a@b.com')
db.session.add(user)
db.session.commit()
users = User.query.filter_by(role='admin').all()
```
26
commit() vs flush() in SQLAlchemy

Times asked 1
Official solution

SimpleSQLAlchemy MAD1 ka common ORM. Flask-SQLAlchemy wrapper se db.Model, db.session.
Example
```
user = User(email='a@b.com')
db.session.add(user)
db.session.commit()
users = User.query.filter_by(role='admin').all()
```
27
get() vs filter_by() SQLAlchemy

Times asked 1
Official solution

SimpleSQLAlchemy MAD1 ka common ORM. Flask-SQLAlchemy wrapper se db.Model, db.session.
Example
```
user = User(email='a@b.com')
db.session.add(user)
db.session.commit()
users = User.query.filter_by(role='admin').all()
```
28
Write a SQLAlchemy query and Flask route for a new table called "Diseases" and update disease name for a patient

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

Demonstrate creation of new doctor and patient, book an appointment and check conflict

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

Explain how data was loaded on the dashboard

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.
31
Handling testing in a situation without front end just backend connection

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.
32
Change some stuff

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.

Advice: She was strict but supportive, questions were rapid fire and had to be answered within one minute or else she would move on. Make sure to prepare all questions in this sheet.

Search viva questions

Question 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

My solution