Search – Lazy IITians Viva Prep

See reviews level_134 MAD1 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1
Demonstrate the complete application (User, Staff, and Admin panels). Explain your models.py. Explain the Admin routes and other routes used in the project. Practical coding questions directly from your own code. Make a small query-based change in the dashboard.

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.
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.
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.
2
Explain CRUD operations. Primary Key vs Foreign Key.

Times asked 1
Official solution

SimplePrimary Key row ki unique ID hai, Foreign Key doosri table ki Primary Key ko point karti hai.
Primary Key: unique + not null. Har table mein hota hai. Example: user.id = 5
Foreign Key: relationship banati hai. post.user_id = 5 matlab yeh post user 5 ki hai.
Example
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
class Post(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
```
FK Primary Key bhi ho sakti hai (1-to-1 profile table). FK unique ho to One-to-One, nahi to One-to-Many.
3
Why is the User model used? Explain backref.

Times asked 1
Official solution

Simplebackref relationship ki reverse side automatically bana deta hai.
```
class Post(db.Model):
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    user = db.relationship('User', backref='posts')
```
Ab post.user milta hai, aur user.posts bhi — Post model pe sirf ek line.
secondary Many-to-Many junction table ke liye: relationship(..., secondary=likes_table, backref='liked_by').
Explicit chahiye to back_populates use karo.
4
What is ORM? Explain SQLAlchemy and why ORM is useful.

Times asked 1
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.
5
What does render_template() do? What is the purpose of __init__.py?

Times asked 1
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.
6
HTTP Methods (GET, POST, etc.) and their use cases.Request–Response model.

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

JSON. DOM. AJAX. Partial Refresh vs Full Refresh.

Times asked 1

Official solution

SimpleDOM = Document Object Model — HTML ka tree jo browser memory mein banata hai. JS isi ko change karta hai.
document.getElementById('btn').style.color = 'red'
Jinja server pe HTML banata hai, phir browser DOM parse karta hai. Vue DOM ko reactive update karta hai.

See reviews Level1_123 MAD1 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Show your ID card. Show your GitHub repository and verify the MAD-1 collaborator. Download the project from the portal, extract it, and run it.

Times asked 1

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.
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.
2
Show your project code. Explain the complete login page/code flow. Explain how data is fetched from the database.

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.
3
Write a Python decorator. Write a Jinja2 for loop in Notepad.

Times asked 1
Official solution

SimpleJinja2 Flask ka template engine hai. HTML ke andar Python-jaisa data print/loop/if kar sakte ho.
Bina Jinja har user ke liye alag HTML file. Jinja se ek template + data.
```
{{ user.name }} print, {% for x in items %} loop, {% if %} condition, {% extends %} layout.
```
Example routereturn render_template('dash.html', treks=treks)
dash.html: {% for t in treks %}<li>{{ t.name }}</li>{% endfor %}
HTML files templates/ folder mein isliye kyunki Flask default wahan dhundhta hai. render_template Jinja ko run karta hai.
Boolean Jinja handle karta hai: {% if user.is_admin %}.
4
Fetch attributes from the database. Explain backref and its purpose in SQLAlchemy relationships.

Times asked 1
Official solution

SimpleSQLAlchemy Python ka sabse popular ORM hai. MAD1 mein Flask-SQLAlchemy wrapper use hota hai.
db = SQLAlchemy(app)
```
class Book(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)

Operations: db.session.add(obj), .commit(), .delete(obj), Model.query.all(), .filter_by(), .get_or_404(id).
db.Model ek class hai (function nahi). db object engine + session + metadata hold karta hai.
```
SQLALCHEMY_TRACK_MODIFICATIONS=False extra signals band karta hai, performance warning hatati hai.
Simplebackref relationship ki reverse side automatically bana deta hai.
```
class Post(db.Model):
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    user = db.relationship('User', backref='posts')
```
Ab post.user milta hai, aur user.posts bhi — Post model pe sirf ek line.
secondary Many-to-Many junction table ke liye: relationship(..., secondary=likes_table, backref='liked_by').
Explicit chahiye to back_populates use karo.

See reviews Level1_96 MAD1 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

ID card verification.GitHub repository & collaborator check.

Times asked 1

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 submission/ZIP from the portal (or perform checksum) and run the project.

Times asked 1

Official solution

SimpleChecksum file ka hash (jaise SHA256) — file change hui ya nahi verify.
Portal pe submitted ZIP ka checksum diya hota hai. Local file ka hash nikaalo, match hona chahiye.
Linux: sha256sum project.zip
Mismatch = galat file / corrupt download. Examiner integrity check karta hai ki tumhari submitted copy hi run ho rahi hai.
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

Demonstrate the complete project and all core functionalities.

Times asked 1

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

Show the summaries/dashboards from different user roles.

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.
5
Explain what happens after a student clicks Apply.

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

Show where the Register route is implemented.

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
Explain ORM. What is ORM? Which ORM have you used? Explain SQLAlchemy

Times asked 1
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.
8
Explain the database relationships. Relationship between your tables. One-to-One and One-to-Many relationships. Relationship between Patient, Doctor and Appointment tables.

Times asked 1
Official solution

SimpleRelationships tables ko jodti hain taaki related data object se mil jaaye.
One-to-Many: User → kai Posts. posts = relationship('Post', backref='author'). FK post.user_id.
One-to-One: User → Profile. uselist=False + unique FK. Profile.user_id unique.
Many-to-Many: Student ↔ Drive. Junction/secondary table (student_id, drive_id).
Example 1-1:
```
class Profile(db.Model):
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), unique=True)
    user = db.relationship('User', back_populates='profile', uselist=False)
```
1-M ko 1-1: child FK pe unique=True + uselist=False.
Parent-child: parent PK, child FK. Junction table extra columns bhi rakh sakti hai (applied_on).
9

Explain Cascade.

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).
10
Explain Flask Contexts. What is Application Context? What is Request Context? Difference between Application Context and Request Context.

Times asked 1
Official solution

SimpleApplication context app-level data (config, db), Request context ek HTTP request (request, session).
Request ke andar Flask khud context push karta hai. Scripts/shell mein db query ke liye:
```
with app.app_context():
    User.query.all()
```
app.app_context().push() same, lekin with better (cleanup).
current_app proxy current Flask app ki taraf. Factory pattern mein import app cycle avoid.
Request context ke bahar request.form error dega.
11

Explain Session Management. What are Flask Sessions?

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.
12
Explain Jinja2. What is Jinja2? How have you used Jinja2 in your project?

Times asked 1
Official solution

SimpleJinja2 Flask ka template engine hai. HTML ke andar Python-jaisa data print/loop/if kar sakte ho.
Bina Jinja har user ke liye alag HTML file. Jinja se ek template + data.
```
{{ user.name }} print, {% for x in items %} loop, {% if %} condition, {% extends %} layout.
```
Example routereturn render_template('dash.html', treks=treks)
dash.html: {% for t in treks %}<li>{{ t.name }}</li>{% endfor %}
HTML files templates/ folder mein isliye kyunki Flask default wahan dhundhta hai. render_template Jinja ko run karta hai.
Boolean Jinja handle karta hai: {% if user.is_admin %}.
13

Explain MVC Architecture.

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

Which frameworks/libraries have you used in your project?

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.
15
Change the maximum parking spots and show the database updating live.

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.
16
Write a route to display all cardiologists.

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())
17
Write a query to retrieve all patient history from the Treatment table.

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())
18
Change a button colour.

Times asked 1
Official solution

Yeh live UI/CSS change hai. Examiner jo element bole uski CSS turant badlo.
Bootstrap class badlo (btn-primary → btn-success, bg-dark → bg-warning) ya inline style='color:red; background:#eee'.
Center: d-flex justify-content-center text-center. Navbar neeche: navbar fixed-bottom.
Example
```
<button class='btn btn-success' style='background:#16a34a'>Book</button>
```
Pehle browser inspect karke class dhundo, phir template mein change karke refresh.

See reviews Level1_92 MAD1 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

ID card verification.Check GitHub repository.Verify MAD-1 collaborator.

Times asked 1

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 project from Viva Booking portal and run it.

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
Register as Company.Create/Add a Drive (or Job Post).Approve Company/Drive.

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

Register as Student.Apply for a Job/Drive.Shortlist a Student.

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

Login as the shortlisted/blacklisted student.Demonstrate Blacklisting.

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.
6
Demonstrate Search functionality.

Times asked 1
Official solution

SimpleSearch box GET form, backend query filter, results template mein.
```
q = request.args.get('q', '').strip()
results = Doctor.query.filter(Doctor.name.ilike(f'%{q}%')).all() if q else []
return render_template('search.html', results=results, q=q)
```
Jinja: {{ results|length }} matches. Empty: 'No results'.
JS-only filter: saara data pehle load, client filter — chhote lists. Bada data: server search.
Search generally GET (shareable URL). Count: len(results) ya db.func.count.
7
Show only active companies.Explain Resume upload and company accessibility.

Times asked 1
Official solution

SimpleFile upload form multipart, Flask request.files, disk ya DB path store.
```
<form method='POST' enctype='multipart/form-data'>
f = request.files.get('resume')
f.save(os.path.join('uploads', secure_filename(f.filename)))
```
Sensitive docs uploads/ web se seedha serve mat karo, login check ke baad send_from_directory.
Student resume edit: policy — allowed hai to Update route, nahi to freeze after apply.
8
Explain Admin, Company and Student dashboards.

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.
9
Explain placement status flow.

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

Explain approval/rejection/blacklisting workflow.Explain what happens after rejecting a company/drive/job.

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.
11
Explain dashboard functionality.Explain database relationships.

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

Explain any route/function pointed out by the examiner.

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.
13
Explain filtering/query 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 }}.
14
Show only shortlisted students.

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

Show student application status instead of application date.

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.
16
Show only active companies.

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 }}.
17
Show only approved drives.Show only jobs with salary > ₹1 lakh.

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 }}.
18
Merge ongoing and completed drives into one table.

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'))
```
19
Show only pending appointments.Show only cancelled appointments.Show only completed appointments.

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 }}.
20
Show only applied drives (filter by status).

Times asked 2
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 }}.
21
Show only applied drives (filter by status).

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

Change button colour (green/blue/any colour).

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>
23
Explain the query after making the changes.

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

Which database did you use?

Times asked 1

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://...
25
What is ORM? Which ORM have you used? Where is ORM initialized/used in your code?

Times asked 1
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.
SimpleSQLAlchemy Python ka sabse popular ORM hai. MAD1 mein Flask-SQLAlchemy wrapper use hota hai.
db = SQLAlchemy(app)
```
class Book(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(80), nullable=False)

Operations: db.session.add(obj), .commit(), .delete(obj), Model.query.all(), .filter_by(), .get_or_404(id).
db.Model ek class hai (function nahi). db object engine + session + metadata hold karta hai.
```
SQLALCHEMY_TRACK_MODIFICATIONS=False extra signals band karta hai, performance warning hatati hai.
26
Which function connects backend and frontend? (render_template)

Times asked 1
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.
27
Authentication vs Authorization.HTTP Methods.

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+).
28
Difference between GET and POST.Where have you used GET requests?

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.
29
Frontend Validation vs Backend Validation.

Times asked 1
Official solution

SimpleFrontend validation UX ke liye, Backend validation security ke liye. Dono chahiye, backend zyada important hai.
Frontend: HTML required, minlength, JS/regex. User ko turant error dikhta hai. Bypass easy (DevTools / Postman).
Backend: Flask route mein checks. Asli security yahi hai. Hacker frontend skip karke POST bhej sakta hai.
Example frontend
```
<input type='number' min='18' max='99' required>
```
Example backend
```
age = int(request.form.get('age') or 0)
if age < 18 or age >= 100:
    flash('Invalid age')
    return redirect(url_for('register'))
```
Viva line'Frontend convenience hai, backend source of truth hai.'
30

MVC Architecture. CSS vs Bootstrap.

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.
31
Which Flask function is used for Jinja templating?

Times asked 1
Official solution

SimpleJinja2 Flask ka template engine hai. HTML ke andar Python-jaisa data print/loop/if kar sakte ho.
Bina Jinja har user ke liye alag HTML file. Jinja se ek template + data.
```
{{ user.name }} print, {% for x in items %} loop, {% if %} condition, {% extends %} layout.
```
Example routereturn render_template('dash.html', treks=treks)
dash.html: {% for t in treks %}<li>{{ t.name }}</li>{% endfor %}
HTML files templates/ folder mein isliye kyunki Flask default wahan dhundhta hai. render_template Jinja ko run karta hai.
Boolean Jinja handle karta hai: {% if user.is_admin %}.
32
Explain ORM implementation in your project.

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

Explain frontend/backend validation in your code.

Times asked 1

Official solution

SimpleFrontend user jo dekhta/click karta hai, Backend server logic + database.
Frontend: HTML, CSS, Bootstrap, Jinja templates, thoda JS. Browser pe chalta hai.
Backend: Flask routes, SQLAlchemy, session, validation. Python server pe.
Data flow: form POST → Flask request.form → DB save → render_template/redirect → HTML dikha.
MAD1 typical stack: Flask + Jinja + SQLAlchemy + SQLite + Bootstrap.
34
Explain authorization implementation.

Times asked 1
Official solution

SimpleAuthentication session se, Authorization role/ownership check se.
```
def admin_required(f):
    @wraps(f)
    def wrap(*a,**k):
        if session.get('role') != 'admin':
            abort(403)
        return f(*a,**k)
    return wrap
```
Jinja: {% if session['role']=='admin' %}<a href='/admin'>Admin</a>{% endif %}
Yeh hide hai, security nahi — route pe check zaroori. Admin authenticated bhi hai (logged in) aur authorized bhi (role).
35
Explain search functionality. Explain filtering queries.

Times asked 1
Official solution

SimpleSearch box GET form, backend query filter, results template mein.
```
q = request.args.get('q', '').strip()
results = Doctor.query.filter(Doctor.name.ilike(f'%{q}%')).all() if q else []
return render_template('search.html', results=results, q=q)
```
Jinja: {{ results|length }} matches. Empty: 'No results'.
JS-only filter: saara data pehle load, client filter — chhote lists. Bada data: server search.
Search generally GET (shareable URL). Count: len(results) ya db.func.count.
36

Explain how student duplicate applications are prevented.

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.
37
Explain how CGPA update works.Explain how placement status changes across dashboards.

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

Explain how admin approves/rejects/blacklists users.

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.
39
Explain how data is stored and retrieved.

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.
40
Explain relationships between tables.

Times asked 3
Official solution

SimpleRelationships tables ko jodti hain taaki related data object se mil jaaye.
One-to-Many: User → kai Posts. posts = relationship('Post', backref='author'). FK post.user_id.
One-to-One: User → Profile. uselist=False + unique FK. Profile.user_id unique.
Many-to-Many: Student ↔ Drive. Junction/secondary table (student_id, drive_id).
Example 1-1:
```
class Profile(db.Model):
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), unique=True)
    user = db.relationship('User', back_populates='profile', uselist=False)
```
1-M ko 1-1: child FK pe unique=True + uselist=False.
Parent-child: parent PK, child FK. Junction table extra columns bhi rakh sakti hai (applied_on).
41
Explain a portion of your code.

Times asked 1
Official solution

SimpleFlask default port 5000. Change: app.run(port=8000) ya env PORT, ya flask run --port 8000.
```
if __name__ == '__main__':
    app.run(debug=True, host='0.0.0.0', port=8000)
```
Do apps ek saath: alag ports. Occupied port: error, doosra number try.

See reviews Level1_132 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Download the project and run it.

Times asked 1

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
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.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
2

Demonstrate the application.

Times asked 4

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
3

Explain your project structure.

Times asked 3

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.
4
Explain models.py.

Times asked 21
Official solution

Simplemodels.py tables ki blueprint. Har class ek table, har Column ek field.
PK id, FK dusri table, relationship dono taraf, serialize() JSON (password mat).
app factory db.init. resources APIs use models.
Examiner random line: type, nullable, unique, ondelete.
Suggested flow1) Har table → class
2) PK id
3) FK
4) relationship()
5) serialize()
Example
```
class Booking(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    user = db.relationship('User', back_populates='bookings')
```
Project example: User, Role, Venue/Show/Booking (ya Drive/Application). Draw 1-M.
Viva tipExaminer random line poochhe: column type, FK, constraint. Draw 1-M / M-M on paper mentally.
5
Explain table relationships (One-to-One, One-to-Many, Many-to-Many).

Times asked 1
Official solution

Simple1-1 uselist=False. 1-M list. M-M association table roles_users.
back_populates both sides. Draw viva.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Example
```
roles_users = db.Table('roles_users',
    db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
    db.Column('role_id', db.Integer, db.ForeignKey('role.id')),
)
class User(db.Model):
    roles = db.relationship('Role', secondary=roles_users, backref='users')
```
Project example: User-Booking 1-M. User-Role M-M.
6
Create a new model.py model.

Times asked 1
Official solution

Simple
```
class X(db.Model) create_all/migrate relationship restart. Create new model.py model.
```
Register import.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: models.py.
7

Explain the CSS file line by line.

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

Explain db and how it differs from model.py.

Times asked 1

Official solution

Simpledb engine/session. models.py classes. Tables metadata.create_all.
db and how differs from model.py.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: extensions.py db, models import db.
9

Vue 2 vs Vue 3.

Times asked 1

Official solution

SimpleVue 3 naya engine: Composition API, fragments, better TS, tree-shaking. Vue 2 Options + filters.
mounted vs onMounted. Filters Vue 3 mein hata — computed/methods.
Version package.json / Vue.version se dikhao. Jo use kiya uske hooks bolo.
SPA = ek HTML, Vue Router se views, full reload nahi. MPA = MAD1 Jinja har URL naya HTML.
Vue Router: routes array, router-view, router-link, meta.auth + beforeEach guard. Dynamic /venues/:id → $route.params.id.
Vite/CLI SFC + npm build dist/. CDN script tag, no SFC. Jo tumne use kiya wahi justify. Flask send_from_directory('dist') production pattern.
Project example: package.json vue ^3.x. setup() + onMounted fetch.
Viva tipVersion package.json / Vue.version se dikhao. MAD2 dono allowed usually — jo use kiya uske hooks bolo (mounted vs onMounted).
10
Vue CLI vs Vue CDN.

Times asked 6
Official solution

SimpleCDN = Vue script tag se, jaise pen drive. CLI/Vite = poori factory (SFC, npm, bundle).
CDN: no build, chhote apps, exam PC pe Node nahi to bhi chal. Weak: no .vue compile, 3rd-party cache, scale/team.
CLI/Vite: Single File Components, env, code-split, production dist/. Scalable.
Examiner 'which + why' — jo use kiya wahi justify, doosra naam rato mat.
Example
```

<script src="https://unpkg.com/vue@3/dist/vue.global.js"></script>

# Vite
npm run dev
npm run build
```
Project example: CDN: index.html unpkg vue. CLI: package.json, npm run serve / vite.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai — jo use kiya wahi justify karo.
11
Why did you choose CDN over CLI?

Times asked 1
Official solution

SimpleCDN = Vue script tag se, jaise pen drive. CLI/Vite = poori factory (SFC, npm, bundle).
CDN: no build, chhote apps, exam PC pe Node nahi to bhi chal. Weak: no .vue compile, 3rd-party cache, scale/team.
CLI/Vite: Single File Components, env, code-split, production dist/. Scalable.
Examiner 'which + why' — jo use kiya wahi justify, doosra naam rato mat.
Example
```

<script src="https://unpkg.com/vue@3/dist/vue.global.js"></script>

# Vite
npm run dev
npm run build
```
Project example: CDN: index.html unpkg vue. CLI: package.json, npm run serve / vite.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai — jo use kiya wahi justify karo.
12

Which is more scalable: CLI or CDN?

Times asked 1

Official solution

SimpleCLI/Vite bundle split env more scalable. CDN widget/prototype.
Which more scalable: CLI. Which you used: honest.
SPA = ek HTML, Vue Router se views, full reload nahi. MPA = MAD1 Jinja har URL naya HTML.
Vue Router: routes array, router-view, router-link, meta.auth + beforeEach guard. Dynamic /venues/:id → $route.params.id.
Vite/CLI SFC + npm build dist/. CDN script tag, no SFC. Jo tumne use kiya wahi justify. Flask send_from_directory('dist') production pattern.
Project example: If CDN, admit tradeoff.
13
What is Vue Router?

Times asked 3
Official solution

SimpleRouter URL ko component se map karta hai. Google Maps for pages.
routes array path+component. router-view jagah. router-link reload nahi.
meta.auth + beforeEach guard. Dynamic /venues/:id.
Nayi page: SFC + routes entry + link.
Example
```
const routes = [
  { path: '/', component: Home },
  { path: '/login', component: Login },
  { path: '/venues/:id', component: VenueDetail, meta: { auth: true } },
]
```
Project example: routes.js Login, Register, UserHome, AdminHome, 404.
Viva tipNayi page: component banao, routes array mein path, router-link se jao.
14
Difference between createWebHistory and createWebHashHistory.

Times asked 1
Official solution

SimpleHash #/login server config nahi. History /login pretty, Flask SPA fallback chahiye.
createWebHashHistory vs createWebHistory. Exam static hash easy.
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
```
createRouter({ history: createWebHashHistory(), routes })
```
Project example: router history mode file. URL bar dikhao.
15

What is meta in Vue Router? What alternatives exist?

Times asked 1

Official solution

Simplemeta extra flags auth role. Guards read. Alt: each component check repeat, wrapper, server 403.
What is meta alternatives.
SPA = ek HTML, Vue Router se views, full reload nahi. MPA = MAD1 Jinja har URL naya HTML.
Vue Router: routes array, router-view, router-link, meta.auth + beforeEach guard. Dynamic /venues/:id → $route.params.id.
Vite/CLI SFC + npm build dist/. CDN script tag, no SFC. Jo tumne use kiya wahi justify. Flask send_from_directory('dist') production pattern.
Project example: meta: { auth: true, role: 'admin' }.
16
What is Vuex?

Times asked 3
Official solution

SimpleVuex/Pinia ghar ka notice board. Har room (component) same user/token dekhe.
State data, mutations sync change, actions async API phir commit.
Local data() sirf us component. Token/user global.
Pinia Vue 3 official, kam boilerplate. Vuex older MAD2 still common.
Example
```
state: { user: null }
mutations: { setUser(s, u) { s.user = u } }
actions: { async login({ commit }, form) {
  const u = await api.login(form); commit('setUser', u)
}}
```
Project example: store user + token login action. Navbar getters isAdmin. Logout clear LS+state.
Viva tipLocal/Session storage persist ke liye, reactive share ke liye store. Pinia Vue 3 official, Vuex older.
17
Difference between data and store.

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

Difference between state and data.

Times asked 1

Official solution

Simpledata() local. Vuex state global. Similar, scope alag.
Difference state and data.
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: q in data, user in store.
Project example: q in data, user in store.
19

Difference between props and emit.

Times asked 1

Official solution

SimpleProps parent→child values. Emit child→parent signal. Basic communication.
Difference props and emit.
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: Card props venue emit select.
20
Show how to send data from child to parent using emit.

Times asked 1
Official solution

Simpleemit = child parent ko chillata hai: 'delete 5'. Props down, events up.
this.$emit('delete', id). Parent @delete="removeRow".
Grandchild: chain emit ya Vuex/provide.
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
```
this.$emit('delete', id)
// parent: <Child @delete="removeRow" />
```
Project example: BookingRow emit cancel → parent list se hata + API DELETE.
21

What is ref?

Times asked 1

Official solution

Simpletemplate ref $refs OR composition ref() primitive. Two meanings — ask context.
What is ref in Vue.
SPA = ek HTML, Vue Router se views, full reload nahi. MPA = MAD1 Jinja har URL naya HTML.
Vue Router: routes array, router-view, router-link, meta.auth + beforeEach guard. Dynamic /venues/:id → $route.params.id.
Vite/CLI SFC + npm build dist/. CDN script tag, no SFC. Jo tumne use kiya wahi justify. Flask send_from_directory('dist') production pattern.
Project example: If Options this.$refs.form. If composition ref(0).
22
Difference between ref and reactive.

Times asked 1
Official solution

Simpleref() wrap .value, primitive. reactive() object proxy. Destructure ref toot sakta.
Options API this.x. Composition choose one style.
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
```
const count = ref(0)
count.value++
const form = reactive({ email: '' })
```
Project example: If Options only, bolo nahi use, Options data().
23
What are Vue Lifecycle Hooks?

Times asked 5
Official solution

SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho — mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya — fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
Composition: onMounted(() => {}) setup ke andar.
Example
```
export default {
  async mounted() {
    const r = await fetch('/api/venues')
    this.venues = await r.json()
  }
}
```
Project example: Venues.vue mounted fetch list. Clock component unmounted pe interval clear.
Viva tipcreated: data setup, DOM nahi. mounted/onMounted: $el mil gaya — fetch yahi. Dashboards isliye onMounted use karti hain.
24

What is an Object in Vue and why is it used?

Times asked 1

Official solution

SimpleOptions object data methods computed hooks. Reactivity observes object. JSON subset key-value.
What is an Object in Vue why used. JS object.
SPA = ek HTML, Vue Router se views, full reload nahi. MPA = MAD1 Jinja har URL naya HTML.
Vue Router: routes array, router-view, router-link, meta.auth + beforeEach guard. Dynamic /venues/:id → $route.params.id.
Vite/CLI SFC + npm build dist/. CDN script tag, no SFC. Jo tumne use kiya wahi justify. Flask send_from_directory('dist') production pattern.
Project example: export default { data() { return {} } }
25
Token-based vs Session-based authentication (with code example).

Times asked 1
Official solution

SimpleSession school id card office mein rakha. Token photocopy jo tum har baar dikhate ho.
Session: Set-Cookie, server store, MAD1 Flask-Login. CSRF risk cookies auto-send.
Token/JWT: SPA + alag port Vue/Flask, scale easy, mobile. XSS if localStorage.
MAD2 typically JWT/Flask-Security token. httpOnly cookie safer lekin CORS+CSRF extra.
Example
```
# session
login_user(user)  # Set-Cookie
# token
return jsonify(token=create_access_token(identity=user.id))
```
Project example: login jsonify token. Vue LS. MAD1 session cookie nahi dikhana unless used.
Viva tipToken localStorage XSS risk; httpOnly cookie safer. Session CSRF risk. MAD2 APIs ke liye JWT/Flask-Security token common.
26
What is UserDatastore?

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.
27
HTTP status codes.

Times asked 1
Official solution

Simple2xx jeet, 4xx teri galti, 5xx meri (server) galti.
200 OK, 201 Created, 400 validation, 401 no/invalid token (authentication fail), 403 role (authorization fail), 404 missing, 409 conflict, 500 crash.
403 vs IntegrityError: 403 permission. Duplicate unique → 400/409, 500 mat chhodo.
Example
```
return jsonify(msg='ok'), 200
return jsonify(msg='login required'), 401
```
Project example: Login fail 401. User admin API 403. Duplicate booking 400.
Viva tip403 vs IntegrityError: 403 permission, IntegrityError DB constraint (duplicate unique) — 400/409 banao, 500 mat chhodo.
28
Forbidden (403) vs Integrity Errors.

Times asked 1
Official solution

Simple2xx jeet, 4xx teri galti, 5xx meri (server) galti.
200 OK, 201 Created, 400 validation, 401 no/invalid token (authentication fail), 403 role (authorization fail), 404 missing, 409 conflict, 500 crash.
403 vs IntegrityError: 403 permission. Duplicate unique → 400/409, 500 mat chhodo.
Example
```
return jsonify(msg='ok'), 200
return jsonify(msg='login required'), 401
```
Project example: Login fail 401. User admin API 403. Duplicate booking 400.
Viva tip403 vs IntegrityError: 403 permission, IntegrityError DB constraint (duplicate unique) — 400/409 banao, 500 mat chhodo.
29

Is Redis server-side or client-side?

Times asked 1

Official solution

SimpleRedis server-side daemon hai. Browser usko directly nahi bolta.
Flask/Celery redis-py se localhost:6379. Client-side localStorage alag.
Examiner confuse kare: 'Redis frontend?' — nahi, backend process.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: redis-server terminal. Vue sirf fetch Flask.
30

Difference between server-side and client-side storage.

Times asked 1

Official solution

SimpleServer DB Redis sessions authoritative. Client cache UX. Never trust client role.
Difference server-side and client-side storage.
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: Bookings DB. Token LS. Cache Redis server.
31
Explain Celery initialization.

Times asked 1
Official solution

SimpleCelery instance, broker URL, @celery.task, worker command, Beat schedule.
DB use karte waqt with app.app_context():. .delay() JSON-serializable args.
Examiner files: celery.py / tasks.py / config beat dict / README commands.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Example
```
celery = Celery(__name__, broker='redis://localhost:6379/0')
@celery.task
def ping():
    return 'ok'
```
Project example: jobs.py daily_reminder, monthly_report, export_csv. config.py broker.
32

Explain Celery Beat.

Times asked 1

Official solution

SimpleCelery Beat = app-level cron. OS crontab se alag, Windows pe bhi chal jaata hai.
CELERY_BEAT_SCHEDULE dict. Beat process continuously. Timezone naive UTC issues common — demo ke liye current minute set karo.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: monthly_report crontab(day_of_month=1, hour=8, minute=0).
33

How do you change a Crontab schedule?

Times asked 1

Official solution

SimpleCELERY_BEAT_SCHEDULE edit, beat restart. Dynamic: PeriodicTask table (redbeat/django-celery-beat) — student apps static dict.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: tasks.py reminder + export. Worker + Beat terminals. MailHog 8025.
34
Change the reminder/monthly report schedule to the current time.

Times asked 1
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'.
35
Write the scheduling code for the monthly report.

Times asked 1
Official solution

Simplebeat monthly crontab day_of_month. Write scheduling code monthly report.
Restart beat.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Example
```
'monthly-report': {'task': 'jobs.monthly', 'schedule': crontab(day_of_month=1, hour=8, minute=0)}
```
Project example: CELERY_BEAT_SCHEDULE.
36

Show Celery-generated emails.

Times asked 1

Official solution

SimpleMAIL config Message MailHog. Show how emails sent SMTP. Show Celery-generated emails. Where email sending logic.
tasks.py + MailHog.
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.
Project example: screenshot 8025.
37
Where can you view sent emails?

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

How do you verify that an email has been sent?

Times asked 1

Official solution

SimpleMailHog UI, sent log, Celery SUCCESS, SMTP debug.
Don't need real inbox.
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: localhost:8025 after reminder.
Project example: localhost:8025 after reminder.
39
Difference between cache.cached and cache.memoize key prefixes.

Times asked 1
Official solution

Simplecached poori view ko yaad rakhta hai, memoize function ke arguments ke hisaab se.
@cache.cached URL / key_prefix (optional query_string) se key banata hai — list endpoints ke liye.
@cache.memoize arguments se key banata hai — get_user(5) aur get_user(9) alag cache.
Prefix clash se galat data mil sakta hai. Dono ka timeout same idea hai. Invalidation: delete_memoized(fn, args) vs cache.delete(prefix).
Example
```
@cache.cached(timeout=30, key_prefix='home')
def home(): ...

@cache.memoize(30)
def get_user(user_id): ...  # alag key per user_id
```
Project example: Venues list = cached. User-wise report function = memoize(user_id).
Viva tipList endpoint: cached. Function with arguments: memoize. Prefix alag rakho warna clash.
40

Write a fetch() request without referring to your project.

Times asked 1

Official solution

Simplefetch(url).then(r=>r.json()).then(console.log).catch. Write fetch without referring project.
async/await also OK.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Project example: Notepad.
Project example: Notepad.
41
Write a fetch() request to delete a subject.

Times asked 1
Official solution

Simplefetch DELETE + Authorization then refresh list. Write fetch delete a subject.
method DELETE.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Example
```
await fetch('/api/subjects/'+id,{method:'DELETE', headers:{Authorization:'Bearer '+t}})
```
Project example: admin table delete btn.
42
Implement the fetch() request in a Vue component.

Times asked 1
Official solution

Simplefetch browser ka daakia. res.ok khud throw nahi karta — check karo.
JSON header, Authorization Bearer. try/catch network. 400 pe message toast.
Axios interceptors token auto. fetch verbose lekin native.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Example
```
async mounted() {
  const res = await fetch('/api/hello', {
    headers: { Authorization: 'Bearer ' + token }
  })
  if (!res.ok) throw new Error(res.status)
  this.msg = (await res.json()).message
}
```
Project example: api.js wrapper. Har component usse. Error banner.
43

Create a new API route to fetch data.

Times asked 1

Official solution

SimpleGET list jsonify. Vue new component display. Create new API route fetch data.
CORS token.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Project example: Hello World then real query.
Project example: Hello World then real query.
44
Create a new DELETE route.

Times asked 1
Official solution

Simple
```
@app.route DELETE get delete commit 200. Create new DELETE route.
```
Auth. 404 if missing.
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: Postman DELETE.
Project example: Postman DELETE.
45

Create an API to update a user's username and email.

Times asked 1

Official solution

SimplePUT /api/me {username,email} unique check commit 200. Create API update username email.
Auth current_user.
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: profile form.
Project example: profile form.
46
Write the API for the export feature.

Times asked 1
Official solution

SimplePOST export.delay 202 task_id. Write API export feature.
@auth_required.
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
```
@auth_required()
@app.route('/api/export', methods=['POST'])
def export():
    t = export_csv.delay(current_user.id)
    return jsonify(task_id=t.id), 202
```
Project example: export route.
47

Write a SQL query to fetch all registered users.

Times asked 1

Official solution

SimpleSELECT id, email FROM user; ORM User.query.all(). Write SQL fetch all registered users.
Don't SELECT password.
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: sqlite3 or ORM.
Project example: sqlite3 or ORM.
48

Write the SQLAlchemy relationship for a Many-to-Many relationship.

Times asked 1

Official solution

SimpleTable secondary relationship. Write SQLAlchemy Many-to-Many. User↔Role example.
association table.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: roles_users.
49
Recreate the Admin Dashboard sidebar.

Times asked 1
Official solution

SimpleLive CSS/Vue: sabse chhota change jo dikhe. Logic/API mat todo unless poochhein.
Inspect element se class dhoondo. btn-success, navbar bottom fixed, center flex.
Save, refresh, dikhao. Break mat karo layout poora.
Example
```
<button class="btn btn-success">Login</button>
nav { position: fixed; bottom: 0; width: 100%; }
.wrap { min-height: 100vh; display: flex; align-items: center; justify-content: center; }
```
Project example: Jo button/navbar poocha usi file (Navbar.vue / App.vue / css).
Viva tipDevTools se element inspect. Logic/API mat todo unless poochhein.
50

Fix a browser console error.

Times asked 1

Official solution

SimpleF12 Console CORS, undefined, 404. Network status. Fix origin/typo.
Vue warn extra.
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: Reproduce error, fix, refresh clean console.
Project example: Reproduce error, fix, refresh clean console.
51

Change the application port and run the application.

Times asked 1

Official solution

Simpleflask run -p 8000. Vite server.port. CORS axios baseURL. Run and open new URL.
Change application port.
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: Don't forget Vue proxy.
Project example: Don't forget Vue proxy.
52
Relationship implementation in SQLAlchemy (One-to-One, One-to-Many, Many-to-Many).

Times asked 1
Official solution

Simple1-1 uselist=False. 1-M list. M-M association table roles_users.
back_populates both sides. Draw viva.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Example
```
roles_users = db.Table('roles_users',
    db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
    db.Column('role_id', db.Integer, db.ForeignKey('role.id')),
)
class User(db.Model):
    roles = db.relationship('Role', secondary=roles_users, backref='users')
```
Project example: User-Booking 1-M. User-Role M-M.
53

What is scalability?

Times asked 1

Official solution

SimpleLoad badhe to handle: scale up/out, cache, async, DB tune.
SQL scale: indexes, pool, replicas, partition, cache hot queries.
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: If 10k: URI postgres, gunicorn, cache, celery concurrency.
54

Difference between Horizontal and Vertical Scaling.

Times asked 2

Official solution

SimpleVertical badi machine. Horizontal aur boxes + load balancer. JWT stateless horizontal friendly.
10k users: Postgres, Redis, gunicorn, CDN, pagination, indexes.
Millions: replicas, queue partition, more workers.
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: Course app vertical enough. Design answer scale-out.

See reviews Level3_48 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
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.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2

Download the project from the portal.

Times asked 4

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
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.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
3
Run the application.

Times asked 8
Official solution

SimpleMAD2 orchestra: Redis, Flask, Vue, worker, beat — 5 terminals.
Ports: Flask 5000, Vite 8080/5173, Redis 6379. CORS isliye.
Order: Redis first. Worker bina Redis fail. Beat bina worker queue bharti.
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
```
redis-server
flask run --port 5000
npm run serve
celery -A app.celery worker -l info
celery -A app.celery beat -l info
```
Project example: README local_run. Dikhao 5 processes + browser two roles.
Viva tipPorts batao: Flask 5000, Vite 8080/5173, Redis 6379. CORS isi liye chahiye.
4

Demonstrate all the functionalities of the application.

Times asked 2

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
5

Explain the database models.

Times asked 2

Official solution

SimpleTables + lines (FK) + 1-M / M-M. Draw mentally, phir models.py.
Har class: PK, important columns, relationships. Why normalized (no duplicate venue name in every show as only string without FK).
Indexes search columns. Unique email. Cascade policy bookings pe.
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: User-Role M-M. User-Booking 1-M. Venue-Show 1-M. Show-Booking 1-M.
6

Explain the backend implementation.

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
Explain the Celery and Redis tasks.

Times asked 1
Official solution

SimpleRedis box hai, Celery us box se kaam uthane wala worker hai — same cheez nahi.
Redis: store (cache keys) + queue (broker lists).
Celery: Python library jo tasks define karti hai, .delay() se queue mein daalti hai, worker execute karta hai.
Dono localhost pe ho sakte hain. Alag Redis DB index use karo. Redis band = cache miss + Celery stuck.
Example
```
Celery: broker_url='redis://localhost:6379/0'
Cache:  CACHE_REDIS_URL='redis://localhost:6379/1'
```
Project example: export_csv.delay(user_id) Flask se. Worker Redis se task uthata hai, CSV+email. Cache alag keys venues.
Viva tipAgar possible ho to cache db=1, broker db=0 — keys mix nahi hoti.
8

Show the Celery command.

Times asked 1

Official solution

SimpleTask function, beat dict, delay() call, worker+beat terminals, MailHog/CSV.
App context DB. Args serializable. How many jobs: reminder, monthly, export — gino honestly.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: tasks.py + config schedule + POST export.
9

Modify the backend logic in the Admin Dashboard.

Times asked 1

Official solution

SimpleFind admin stats query change filter JSON Vue same keys. Modify backend admin dashboard.
Modify admin dashboard functionality.
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: summary API.
Project example: summary API.
10

Update the database model to satisfy an additional condition.

Times asked 1

Official solution

SimpleAdd column/constraint migrate serialize form. Update model additional condition.
Favorites extra field same idea.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: models.py + API.
11

Modify the application so that occupied parking spots also display the associated vehicle number (API + Frontend).

Times asked 1

Official solution

SimpleSpot.vehicle_no column serialize Vue extra td. Occupied spots display vehicle.
API + Frontend.
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: model + serialize + table.
Project example: model + serialize + table.
12

Implement a Cancel Appointment feature for doctors (Frontend + Backend).

Times asked 1

Official solution

SimpleStatus=cancelled seats++. Doctor/user role. Vue button PATCH. Implement Cancel Appointment FE+BE.
Authz.
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: new endpoint + button.
Project example: new endpoint + button.

See reviews Level1_94 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
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.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub collaborator.

Times asked 3
Official solution

SimpleRepo = evidence tumne kaam kiya: commits, collaborators, README.
Regular messages, last-day dump nahi. Private access pehle de do. Main branch submitted ZIP se match.
Collaborator settings. Commit dates.
Example
```
Settings → Collaborators: apna + teammate (agar allowed).
Commits: regular messages, last-day dump nahi.
```
Project example: Settings → Collaborators. git log --oneline. README run steps.
Viva tipPrivate repo access de do pehle. Main branch latest submitted ZIP se match honi chahiye.
3

Demonstrate the complete application.

Times asked 33

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
4
Demonstrate all CRUD operations.

Times asked 3
Official solution

SimpleCRUD 4 operations live: add list edit delete, list refresh.
REST mapping. Related bookings after delete ready answer.
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
```
POST /api/venues → add
GET /api/venues → list
PUT /api/venues/3 → edit
DELETE /api/venues/3
```
Project example: Admin venues. Postman + UI dono.
Viva tipUpdate ke baad list refresh hoke naya data dikhe. Delete ke baad related bookings kya hoti hain, ready raho.
5
Demonstrate charts and summary statistics (Admin/User dashboard).

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

Times asked 1
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.
7
Show scheduled backend jobs (daily reminders, monthly reports).

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
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.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
8

Show CSV export functionality.

Times asked 1

Official solution

Simplecsv celery trigger. Explain export theatres CSV which library. Show CSV export open file.
csv module standard.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: export task + sample file.
9

Explain what happens when a frontend button is clicked until the backend completes the task.

Times asked 1

Official solution

SimpleClick → Vue method → fetch → Flask auth → DB → jsonify → Vue state → template. Celery: delay Redis worker email.
Button until backend completes: include jobs path if export.
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: Book button sequence 6 steps aloud.
10
Explain how the Admin user is created.

Times asked 1
Official solution

SimpleSeed create_app user_datastore admin. Hash password. Role attach. Static env vs DB.
How admin created. Show code.
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
```
if not User.query.filter_by(email='admin@x.com').first():
    user_datastore.create_user(email='admin@x.com', password=hash_password('Admin@123'))
```
Project example: if not User.query.filter admin: create.
11
Explain how Celery is implemented and executed.

Times asked 1
Official solution

SimpleCelery instance, broker URL, @celery.task, worker command, Beat schedule.
DB use karte waqt with app.app_context():. .delay() JSON-serializable args.
Examiner files: celery.py / tasks.py / config beat dict / README commands.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Example
```
celery = Celery(__name__, broker='redis://localhost:6379/0')
@celery.task
def ping():
    return 'ok'
```
Project example: jobs.py daily_reminder, monthly_report, export_csv. config.py broker.
12

Explain how the CSV export job is implemented.

Times asked 1

Official solution

Simplecsv celery trigger. Explain export theatres CSV which library. Show CSV export open file.
csv module standard.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: export task + sample file.
13

Explain the API and route flow when a new booking is created.

Times asked 1

Official solution

SimpleSelect → qty → POST {id,qty} → auth seats duplicate → commit → 201 → UI ticket.
API route flow new booking.
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: book endpoint + Vue.
Project example: book endpoint + Vue.
14

Explain the models.py file.

Times asked 5

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

Explain db.Model.

Times asked 1

Official solution

Simpledb = SQLAlchemy instance. db.Model base — inherit mapping. db engine/session/metadata alag.
Explain db vs model.py. Where init db object.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: db = SQLAlchemy(); db.init_app(app); class X(db.Model).
16

Explain the difference between your MAD1 and MAD2 projects.

Times asked 1

Official solution

SimpleMAD1 Jinja MPA sessions. MAD2 Vue SPA REST JWT Redis Celery. Same domain CRUD, architecture jump.
Improvements: SPA, cache, jobs, JWT. Still add tests/cancel.
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: Reuse models idea, rewrite UI APIs jobs.
17

Is there any core feature you have not implemented?

Times asked 1

Official solution

SimpleJo nahi kiya sach + reason + kaise add (model API Vue). Bluff worse.
Core feature not implemented? Milestone vs code.
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: If complete, polish only. If missing export, plan celery csv.
18

What is something new you learned while building this project?

Times asked 1

Official solution

SimpleEk concrete: JWT vs session, invalidation, beat vs worker, reactivity gotcha.
Something new while building.
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: Don't say 'everything'. One story.
19
Token-based vs Session-based authentication.

Times asked 4
Official solution

SimpleSession school id card office mein rakha. Token photocopy jo tum har baar dikhate ho.
Session: Set-Cookie, server store, MAD1 Flask-Login. CSRF risk cookies auto-send.
Token/JWT: SPA + alag port Vue/Flask, scale easy, mobile. XSS if localStorage.
MAD2 typically JWT/Flask-Security token. httpOnly cookie safer lekin CORS+CSRF extra.
Example
```
# session
login_user(user)  # Set-Cookie
# token
return jsonify(token=create_access_token(identity=user.id))
```
Project example: login jsonify token. Vue LS. MAD1 session cookie nahi dikhana unless used.
Viva tipToken localStorage XSS risk; httpOnly cookie safer. Session CSRF risk. MAD2 APIs ke liye JWT/Flask-Security token common.
20

Did you configure email notifications after backend tasks completed?

Times asked 1

Official solution

SimpleYes task end mail / no would add. Show code honestly.
on_success optional.
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.
Project example: export task last lines mail.send.
Project example: export task last lines mail.send.
21
What is Vue?

Times asked 6
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.
22
Vue CLI vs Vue CDN. Which one did you use and why?

Times asked 3
Official solution

SimpleCDN = Vue script tag se, jaise pen drive. CLI/Vite = poori factory (SFC, npm, bundle).
CDN: no build, chhote apps, exam PC pe Node nahi to bhi chal. Weak: no .vue compile, 3rd-party cache, scale/team.
CLI/Vite: Single File Components, env, code-split, production dist/. Scalable.
Examiner 'which + why' — jo use kiya wahi justify, doosra naam rato mat.
Example
```

<script src="https://unpkg.com/vue@3/dist/vue.global.js"></script>

# Vite
npm run dev
npm run build
```
Project example: CDN: index.html unpkg vue. CLI: package.json, npm run serve / vite.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai — jo use kiya wahi justify karo.
23
What are Query Parameters?

Times asked 1
Official solution

SimpleURL ?q=park&page=2 filters search pagination. Path params id.
What are Query Parameters.
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
```
request.args.get('q')
// Vue: this.$route.query.q
```
Project example: request.args.get('q'). Vue $route.query.q.
24
What is Celery?

Times asked 19
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.
25

Why do we use Celery?

Times asked 2

Official solution

SimpleIsliye ki user wait na kare, retry mil jaaye, 6pm automatic ho jaaye.
Slow work (mail, CSV, PDF) request se alag. Schedule crontab. Scale = aur workers.
JS async/await alag cheez hai (browser event loop). Celery server-side process.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: Reminder 6pm, monthly 1st, export button. Teen alag tasks.py functions.
26

Why are asynchronous jobs needed?

Times asked 1

Official solution

SimpleSync line pe ruk jao (2+2). Async I/O pe wait karte hue baaki kaam chalte (fetch, Celery).
JS async ≠ Celery async jobs. Context se bolo.
Why async jobs: slow/scheduled/bulk off request thread.
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: Login sync hash check fast. Email Celery async. Vue fetch async.
27
What is Redis?

Times asked 21
Official solution

SimpleRedis fridge pe sticky note hai — poori kitchen (database) kholne ki zarurat nahi.
Redis in-memory key-value store hai. Data RAM mein rehta hai, isliye disk wale SQLite/Postgres se kai guna tez.
MAD2 mein Redis do kaam karta hai:
1) Cache — same venue/show/dashboard JSON baar-baar DB se mat nikaalo.
2) Celery message broker — Flask task queue mein daalta hai, worker uthata hai.
Source of truth database hi hai. Redis band ho to cache miss ho jaata hai aur Celery queue ruk sakti hai. Crash pe cache gayab ho sakta hai — isliye important data sirf Redis mein mat rakho.
Example
```
import redis
r = redis.Redis(host='localhost', port=6379, db=0)
r.set('venues', json.dumps(data), ex=30)
print(r.get('venues'))
```
Project example: GET /api/venues pehle Redis dekho. Miss pe SQLAlchemy query, phir SET with timeout. Celery worker Redis list se daily reminder uthata hai.
Viva tipCache ke liye db=1, broker ke liye db=0 rakhna smart hai taaki keys mix na hon. Viva mein redis-cli ping → PONG dikhana strong hai.
28

Why do we use Redis?

Times asked 2

Official solution

SimpleMAD2 course Redis isliye: ek tool mein cache + Celery broker.
Memcached sirf cache. RabbitMQ sirf queue. Redis dono + easy install.
Student project size pe SQLite + Redis kaafi. Production mein hosted Redis, persistence optional.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: requirements.txt: redis, Flask-Caching, celery. README: redis-server pehle chalao.
29
Difference between Celery Worker and Celery Beat.

Times asked 2
Official solution

SimpleBeat clock hai, Worker haath hai. Clock kaam nahi karti, haath nahi sochte kab.
Worker: @celery.task execute. Beat: crontab padhke due time pe queue mein daal.
Sirf worker = scheduled nahi. Sirf beat = queue bhar jaaye, koi run nahi.
Dono ke saath redis-server. Logs mein 'Sending due task' Beat, 'Task succeeded' Worker.
Example
```
celery -A app.celery worker -l info
celery -A app.celery beat -l info
```
Project example: daily_reminder Beat 18:00. Worker MailHog. Export worker-only (button).
Viva tipSirf worker = scheduled jobs nahi chalenge. Sirf beat = queue bhar jaaye, koi run nahi karega.
30
Celery Beat and Worker commands.

Times asked 1
Official solution

SimpleBeat clock hai, Worker haath hai. Clock kaam nahi karti, haath nahi sochte kab.
Worker: @celery.task execute. Beat: crontab padhke due time pe queue mein daal.
Sirf worker = scheduled nahi. Sirf beat = queue bhar jaaye, koi run nahi.
Dono ke saath redis-server. Logs mein 'Sending due task' Beat, 'Task succeeded' Worker.
Example
```
celery -A app.celery worker -l info
celery -A app.celery beat -l info
```
Project example: daily_reminder Beat 18:00. Worker MailHog. Export worker-only (button).
Viva tipSirf worker = scheduled jobs nahi chalenge. Sirf beat = queue bhar jaaye, koi run nahi karega.
31

Change the scheduled jobs to run every minute.

Times asked 1

Official solution

SimpleTest ke liye dono jobs crontab(minute='*/1'), demo ke baad wapas original.
Beat restart. MailHog spam ho sakta hai — ek-do mails dikha ke revert.
Examiner scheduling samajh check karta hai, production cron 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: Change config, restart beat, worker log Task succeeded, MailHog UI.
32
Show that reminders are working.

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
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.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
33
What is ORM?

Times asked 49
Official solution

SimpleORM = translator. Python object bolo, woh SQL mein baat kare.
Object Relational Mapper. Class User ↔ table user. Raw SQL kam.
SQLAlchemy MAD1/MAD2. Fayde: portable SQLite→Postgres, relationships, parameterized queries (injection kam).
Nuksaan: N+1, hidden SQL, complex reports pe raw better.
Direct sqlite3 se SQLAlchemy isliye: models, switch DB, safer queries.
Example
```
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(128), unique=True)
User.query.filter_by(email='a@b.com').first()
```
Project example: models.py db.Model. resources User.query.filter_by. Koi f-string SQL nahi.
Viva tipFayde: safe-ish, portable (SQLite→Postgres). Nuksaan: complex queries, N+1, leaky abstractions. Direct SQLite se SQLAlchemy isliye: models + injection protection + switch DB.
34
Difference between backref and back_populates.

Times asked 10
Official solution

Simplebackref jaadu se reverse attribute. back_populates dono taraf likho — clear.
backref='author' Post.author auto. New code back_populates preferred.
Examiner difference almost guaranteed.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Example
```
posts = db.relationship('Post', backref='author')
# vs
posts = db.relationship('Post', back_populates='author')
Post.author = relationship('User', back_populates='posts')
```
Project example: User.bookings / Booking.user dono explicit back_populates.
35

Difference between Client-Server and Distributed Architecture.

Times asked 1

Official solution

SimpleDistributed kai hosts: API, DB, Redis, workers. Client-server 2-tier simple.
MAD2 chhota distributed (processes). Not full microservices.
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: 5 processes localhost = mini distributed.
36

Difference between cellspacing and cellpadding.

Times asked 1

Official solution

Simplecellpadding andar gap. cellspacing beech (old HTML). Aaj CSS padding/border-spacing.
Difference cellspacing cellpadding.
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: We use CSS tables/bootstrap.
37

Is caching implemented?

Times asked 2

Official solution

SimpleHaan Redis routes X demo hit miss. Nahi: kaise add karte — decorator + redis + invalidation.
Don't lie. Examiner code dekhega.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: If yes open decorator. If no 4-step plan.
38
Explain cache invalidation.

Times asked 1
Official solution

SimpleDB badli to purani copy phenk do, warna user jhooth dekhega.
Invalidation = cache key delete/update after create/update/delete.
Options: (1) cache.delete('venues') targeted (2) timeout auto-expire (3) cache.clear() nuclear — baaki routes bhi miss ho jaayenge.
Examiner: 'naya record insert kiya, cache purana' — write route mein delete dikhao, phir GET miss+hit demo.
Example
```
@app.route('/api/venues', methods=['POST'])
def create_venue():
    db.session.add(v)
    db.session.commit()
    cache.delete('venues')
    return jsonify(msg='created'), 201
```
Project example: POST /api/venues commit ke baad cache.delete. PUT/DELETE pe bhi same prefix.
Viva tipTimeout se auto-expire bhi hota hai. Create/update/delete ke baad related keys hatao.
39
Write a Vue v-if example.

Times asked 1
Official solution

SimpleComponent + route ya template v-if/v-for/fetch. :key dena.
Clock interval + clear. Add numbers v-model.number. New page routes.js.
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
```
<input v-model.number="a"><input v-model.number="b">
<p>{{ a + b }}</p>
```
Project example: views/Foo.vue + path. mounted fetch if API.
40

Write a random Flask route.

Times asked 1

Official solution

SimpleAny GET jsonify. Mention methods return tuple status. Write a random Flask route.
Keep tiny.
Flask Python micro web framework. Route decorator URL → function. MAD2 mein JSON API: request.get_json(), jsonify, JWT.
WSGI: server (Werkzeug) app ko call. if __name__ == '__main__' sirf direct run. Factory create_app() test/celery ke liye.
Blueprint/resources folders. @app.route vs MethodView. Debug=True viva local, prod nahi. CORS alag port Vue ke liye.
Project example: /ping.
Project example: /ping.
41

Write an endpoint to book an appointment.

Times asked 1

Official solution

SimplePOST book slot checks seats. Write endpoint book appointment.
400 overbook.
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: bookings.
Project example: bookings.
42

Write an endpoint to apply for a drive.

Times asked 1

Official solution

SimplePOST apply drive_id unique+elig. Write endpoint apply for drive.
201.
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: applications.
Project example: applications.
43
Write a frontend form.

Times asked 1
Official solution

Simpleform @submit.prevent inputs v-model button. Write a frontend form.
Don't full page reload.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Example
```
<form @submit.prevent="save">
  <input v-model="email" type="email" required>
  <button type="submit">Login</button>
</form>
```
Project example: Login.vue pattern.
44

Write the frontend code to display available appointments.

Times asked 1

Official solution

Simplemounted fetch /api/slots?available=1 v-for Book. Frontend display available appointments.
Auth header.
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: Appointments.vue.
Project example: Appointments.vue.
45
Change the button color.

Times asked 3
Official solution

SimpleLive CSS/Vue: sabse chhota change jo dikhe. Logic/API mat todo unless poochhein.
Inspect element se class dhoondo. btn-success, navbar bottom fixed, center flex.
Save, refresh, dikhao. Break mat karo layout poora.
Example
```
<button class="btn btn-success">Login</button>
nav { position: fixed; bottom: 0; width: 100%; }
.wrap { min-height: 100vh; display: flex; align-items: center; justify-content: center; }
```
Project example: Jo button/navbar poocha usi file (Navbar.vue / App.vue / css).
Viva tipDevTools se element inspect. Logic/API mat todo unless poochhein.
46

Move the Sign Up button to the top-right.

Times asked 1

Official solution

SimpleNavbar d-flex; ms-auto on signup. Bootstrap right push.
Move button vs CSS only.
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: Navbar.vue link order + ms-auto.
Project example: Navbar.vue link order + ms-auto.
47

Modify the application to display all users.

Times asked 1

Official solution

SimpleAdmin GET /api/users no passwords. Table v-for. Modify display all users.
RBAC admin.
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: serialize without hash.
Project example: serialize without hash.
48

Fix the monthly report scheduler.

Times asked 1

Official solution

Simplecrontab day, timezone, beat not running, empty query, logs.
Schedule now to demo. Restart beat.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: Fix schedule + worker log error read.
49

Verify APIs using Thunder Client/Postman.

Times asked 1

Official solution

SimpleMethod URL Headers Authorization JSON body. 200/401 bina Vue — backend prove.
Login copy token. Collection. Thunder Client same.
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: Show 3 requests. Examiner loves this.
50

Show browser cookies.

Times asked 1

Official solution

SimpleApplication Cookies. JWT LS ho to cookies empty — dono jagah dikhao. Whether cookies created.
Show browser cookies.
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.
Project example: If session cookie name. If not explain JWT.

See reviews Level1_14 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1
Show your GitHub repository and collaborator.

Times asked 16
Official solution

SimpleRepo = evidence tumne kaam kiya: commits, collaborators, README.
Regular messages, last-day dump nahi. Private access pehle de do. Main branch submitted ZIP se match.
Collaborator settings. Commit dates.
Example
```
Settings → Collaborators: apna + teammate (agar allowed).
Commits: regular messages, last-day dump nahi.
```
Project example: Settings → Collaborators. git log --oneline. README run steps.
Viva tipPrivate repo access de do pehle. Main branch latest submitted ZIP se match honi chahiye.
2

Show your Student ID.

Times asked 2

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
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.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
3
Run the project.

Times asked 1
Official solution

SimpleMAD2 orchestra: Redis, Flask, Vue, worker, beat — 5 terminals.
Ports: Flask 5000, Vite 8080/5173, Redis 6379. CORS isliye.
Order: Redis first. Worker bina Redis fail. Beat bina worker queue bharti.
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
```
redis-server
flask run --port 5000
npm run serve
celery -A app.celery worker -l info
celery -A app.celery beat -l info
```
Project example: README local_run. Dikhao 5 processes + browser two roles.
Viva tipPorts batao: Flask 5000, Vite 8080/5173, Redis 6379. CORS isi liye chahiye.
4

Demonstrate the complete application.

Times asked 33

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
5

Explain the code for the features the examiner asks about.

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.
6
Demonstrate backend jobs (Celery).

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
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.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
7
Demonstrate CSV export.

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.
8
Send an email from the application.

Times asked 2
Official solution

SimpleSMTP + template + Celery. MailHog inbox dikhao, Gmail nahi chahiye.
Dynamic HTML user name. Live: schedule now.
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
```
msg = Message(subject='Daily reminder', recipients=[user.email])
msg.html = render_template('reminder.html', user=user)
mail.send(msg)
```
Project example: reminder.html Jinja. tasks send_mail.
Viva tipLive demo ke liye Celery beat crontab current time pe set karo, worker + beat dono chalu rakho.
9
Demonstrate the search functionality.

Times asked 4
Official solution

SimpleSearch demo cases.
See earlier essay.
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
```
q = request.args.get('q', '').strip()
items = Venue.query.filter(Venue.name.ilike(f'%{q}%')).all()
return jsonify([v.serialize() for v in items])
```
Project example: UI + API.
Viva tipEmpty search, no-match, case-insensitive (ilike) teen cases dikhao.
10
Explain the login flow in the Vue frontend.

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

Can two patients book the same doctor at the same time?

Times asked 1

Official solution

SimpleShould not if unique slot PK. Two patients same doctor time prevented.
Can two patients same time.
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: Demo second 400.
12

Can a blocked patient still log in?

Times asked 1

Official solution

SimpleAgar flag login pe check hai to nahi. Demo set flag 403.
Can blocked patient still log in? Should not.
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: Postman login after blacklist.
Project example: Postman login after blacklist.
13

Can the admin search for doctors and patients?

Times asked 1

Official solution

SimpleAdmin API ilike name doctor/patient role check. Can admin search doctors patients?
If built demo. Else would add q=.
MAD2 architecture: Vue SPA (client) → HTTP JSON → Flask API (server) → SQLAlchemy DB. Side path: Flask → Redis broker → Celery worker → MailHog/CSV.
Client-server alag ports. State: Vue memory + LS token. Persistent: SQLite. Cache: Redis. MVC-ish: models.py, API views, Vue templates.
Scale: more workers, Postgres, cache, not 'bigger SQLite file'.
Project example: Admin search component.
14

What happens if a doctor is deleted?

Times asked 1

Official solution

SimpleAppointments cascade or block. Show ondelete. Patients reassign.
What happens if doctor deleted.
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: Domain-specific same FK idea.
Project example: Domain-specific same FK idea.
15

Demonstrate profile update functionality.

Times asked 1

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
16

Demonstrate treatment-related functionality.

Times asked 1

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
17
Verify that duplicate booking is prevented logically and technically.

Times asked 1
Official solution

SimpleDoosri booking same slot: unique constraint + query.exists + 400 message.
Frontend disable UX. Backend source of truth. Race: two users unique(slot).
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
```
if Booking.query.filter_by(user_id=uid, slot_id=sid).first():
    return jsonify(message='Already booked'), 400
```
Project example: Click book twice. Second 400 Already booked. DB unique.
18

What type of authentication have you implemented?

Times asked 1

Official solution

SimpleToken JWT / Security token + RBAC. Session if used clearly. What type authentication.
What authentication mechanism. Token type JWT. Which library requirements.txt.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: flask-jwt-extended or flask-security-too.
19
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 / venue / drive delete kar sakta hai, normal user nahi.
MAD2 mein yeh alag layers hain: login API = authentication (JWT milta hai). @roles_required('admin') ya Vue v-if="isAdmin" = authorization.
Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+). Authentication identity hai, authorization permission, validation input quality.
Example
```
# Authentication
if user and check_password_hash(user.password, form_password):
    token = create_access_token(identity=user.id)

# Authorization
if current_user.role != 'admin':
    abort(403)  # logged in ho, lekin allowed nahi
```
Project example: Student login = authentication. Student admin dashboard nahi khol sakta = authorization. Frontend button hide sirf UX hai — asli check backend pe hona chahiye.
Viva tip401 = not logged in / bad token. 403 = logged in, role galat. Examiner yeh difference bahut poochta hai.
20

What type of token are you using (e.g., JWT)?

Times asked 1

Official solution

SimpleJWT HS256 flask-jwt-extended / security token. Named library.
Which library token generation / token-based.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: requirements.txt line.
21

Show where JWT/authentication is implemented.

Times asked 1

Official solution

Simplecreate_access_token, @jwt_required, frontend header. Show where JWT/Flask-Security.
Open three places.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: auth.py resources login.vue.
22
What are RESTful APIs?

Times asked 2
Official solution

SimpleREST: resource URLs, HTTP verbs, stateless, JSON. /venues/1 not /getVenue?id=1.
Stateless: har request token. Meaningful status. HATEOAS optional course.
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
```
@app.route('/api/venues/<int:id>', methods=['GET', 'PUT', 'DELETE'])
def venue(id):
    v = Venue.query.get_or_404(id)
```
Project example: MethodView/Resource GET POST PUT DELETE.
23
What are HTTP headers?

Times asked 2
Official solution

SimpleHeaders metadata chitthi ke upar: kaun bhej raha, kaisa data, token.
Content-Type JSON, Authorization Bearer, Accept, CORS Origin.
GET usually no body. POST JSON body + header.
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
```
fetch(url, {
  method: 'POST',
  headers: {
    'Content-Type': 'application/json',
    'Authorization': 'Bearer ' + token
  },
  body: JSON.stringify({ name: 'A' })
})
```
Project example: Network tab login POST headers. Later GET list Authorization.
24
What are Vue Lifecycle Hooks?

Times asked 5
Official solution

SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho — mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya — fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
Composition: onMounted(() => {}) setup ke andar.
Example
```
export default {
  async mounted() {
    const r = await fetch('/api/venues')
    this.venues = await r.json()
  }
}
```
Project example: Venues.vue mounted fetch list. Clock component unmounted pe interval clear.
Viva tipcreated: data setup, DOM nahi. mounted/onMounted: $el mil gaya — fetch yahi. Dashboards isliye onMounted use karti hain.
25

Show where lifecycle hooks are implemented.

Times asked 1

Official solution

Simplemounted/onMounted block. Why not created. Show where implemented.
Show frontend async await mounted.
Lifecycle = component ki zindagi: created (instance, DOM nahi) → mounted/onMounted (DOM ready — fetch, Chart.js yahi) → updated → unmounted (clearInterval).
Dashboard API created mein isliye nahi ki $el/canvas missing ho sakta. Composition API: onMounted(() => {}) setup ke andar. Options: mounted() method. Mix mat.
Examiner 'konsa hook use kiya' — related .vue kholo, line padh ke bolo.
Project example: Dashboard.vue.
26
What is Axios?

Times asked 2
Official solution

SimpleAxios HTTP library: JSON auto, interceptors, timeout. fetch built-in alternative.
Na use kiya: 'fetch native, extra lib nahi' valid.
Use kiya: interceptor mein token. Why didn't: deps kam.
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
```
axios.get('/api/venues', { headers: { Authorization: 'Bearer ' + token } })
```
Project example: axios.defaults.headers.common.Authorization. baseURL :5000.
Viva tipNa use kiya to bolo: fetch native hai, extra lib nahi. Use kiya to interceptor mein token set karna dikhao.
27
Explain the login handling code in Vue.

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

Why is caching used?

Times asked 2

Official solution

SimpleCache isliye taaki 100 users same dashboard pe DB ko 100 baar na maror dein.
Problem: repeated reads, slow page, extra load. Cache seconds ke liye snapshot deta hai.
Nahi use karna: har second badalne wala live stock, user-private secret data bina soch ke (key mein user_id hona chahiye).
Memoization caching ka subset hai (function args). HTTP 304 / browser cache alag layer.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: Shows list har user dekhta hai — perfect cache. Booking POST cache nahi — har baar write.
29

Show where caching is implemented.

Times asked 6

Official solution

SimpleDecorator + Redis ping + invalidation line + miss/hit demo idea.
Kaunsi routes, timeout, key_prefix, query_string. POST pe nahi.
print after set sirf miss. Timeout chhota karke expiry.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: resources list GET cached. create_venue delete key.
30

Explain the caching code.

Times asked 1

Official solution

SimpleKaunsi routes, timeout, key, invalidation, hit/miss demo.
Stale story. print miss only.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: Open cached view + write delete.
31

Explain how Redis is used.

Times asked 1

Official solution

Simpledb indexes cache vs broker, ping, which keys, why used.
Physical RAM. Vue nahi. Hit miss. Celery alag.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: config URLs + decorator + celery broker.
32

What is Local Storage?

Times asked 4

Official solution

Simplewindow.localStorage key-value strings origin persist. Advantages: persist 5MB simple. Nuksaan XSS no expiry strings.
What is Local Storage. Advantages.
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: setItem token.
33

Which libraries have you used in your project?

Times asked 1

Official solution

Simplerequirements.txt + package.json top ones. Which libraries used in project.
6 names why.
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: Don't recite 40.
Project example: Don't recite 40.

See reviews Level1_146 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
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.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2

Demonstrate your application.

Times asked 8

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
3

Explain the project structure.

Times asked 2

Official solution

Simplebackend create_app models api jobs. frontend src router. config env. README.
Don't read every file. 6 roles.
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: tree command or VSCode explorer.
4

Explain the file structure.

Times asked 1

Official solution

Simplebackend create_app models api jobs. frontend src router. config env. README.
Don't read every file. 6 roles.
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: tree command or VSCode explorer.
5

Explain your database models.

Times asked 8

Official solution

SimpleTables + lines (FK) + 1-M / M-M. Draw mentally, phir models.py.
Har class: PK, important columns, relationships. Why normalized (no duplicate venue name in every show as only string without FK).
Indexes search columns. Unique email. Cascade policy bookings pe.
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: User-Role M-M. User-Booking 1-M. Venue-Show 1-M. Show-Booking 1-M.
6

Explain the database design.

Times asked 2

Official solution

SimpleTables + lines (FK) + 1-M / M-M. Draw mentally, phir models.py.
Har class: PK, important columns, relationships. Why normalized (no duplicate venue name in every show as only string without FK).
Indexes search columns. Unique email. Cascade policy bookings pe.
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: User-Role M-M. User-Booking 1-M. Venue-Show 1-M. Show-Booking 1-M.
7

Explain the backend jobs flow.

Times asked 1

Official solution

SimpleUser click vs beat. Redis. Worker. Side effect email/file. Explain backend jobs flow. Data flow user-triggered Celery.
Diagram.
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: export vs reminder.
8
Explain where caching is implemented.

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

Explain how Redis is used in your project.

Times asked 1

Official solution

Simpledb indexes cache vs broker, ping, which keys, why used.
Physical RAM. Vue nahi. Hit miss. Celery alag.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: config URLs + decorator + celery broker.
10
Explain the Celery and Redis code.

Times asked 1
Official solution

SimpleRedis box hai, Celery us box se kaam uthane wala worker hai — same cheez nahi.
Redis: store (cache keys) + queue (broker lists).
Celery: Python library jo tasks define karti hai, .delay() se queue mein daalti hai, worker execute karta hai.
Dono localhost pe ho sakte hain. Alag Redis DB index use karo. Redis band = cache miss + Celery stuck.
Example
```
Celery: broker_url='redis://localhost:6379/0'
Cache:  CACHE_REDIS_URL='redis://localhost:6379/1'
```
Project example: export_csv.delay(user_id) Flask se. Worker Redis se task uthata hai, CSV+email. Cache alag keys venues.
Viva tipAgar possible ho to cache db=1, broker db=0 — keys mix nahi hoti.
11

Show the frontend routes.

Times asked 1

Official solution

SimpleVue router.js. Flask @app.route / resources.py.
Both if asked frontend vs backend.
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: Don't mix.
Project example: Don't mix.
12
What is Cascade Delete (ON DELETE CASCADE)?

Times asked 1
Official solution

SimpleCASCADE = parent gaya to bacche bhi. Restrict = pehle bacche sambhalo.
ON DELETE CASCADE SQL. SQLAlchemy cascade='all, delete-orphan' collection se orphans.
Opposite auto nahi — child delete se parent nahi marata.
Venue delete: bookings restrict (safer viva) ya cascade+cancel policy. Examiner design poochta hai.
ON UPDATE CASCADE PK change — rare. SET NULL, RESTRICT bhi options.
Example
```
shows = db.relationship('Show', cascade='all, delete-orphan', back_populates='venue')
```
Project example: Show belongs Venue delete-orphan. Booking venue pe restrict — 'reassign first'.
Viva tipVenue delete pe bookings: restrict (mat delete) ya cascade+refund policy. Examiner design poochta hai. Cascade UPDATE bhi hota hai (PK change) — rare.
13

Explain database keys (Primary Key, Foreign Key, Candidate Key, etc.).

Times asked 1

Official solution

SimpleCandidate key koi bhi unique ID (email, id). PK unme se election jeetne wala.
Email candidate. Hum id PK rakhte hain kyunki email change ho sakta.
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: User: id PK, email unique candidate.
14

Explain database relationships.

Times asked 4

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

Difference between STRING and TEXT data types.

Times asked 1

Official solution

SimpleString limited. Text unlimited. Descriptions TEXT, emails String.
Difference STRING and TEXT.
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: movie description Text.
Project example: movie description Text.
16
Difference between v-if and v-show.

Times asked 10
Official solution

Simplev-if ghar se nikaal deta hai (DOM se). v-show sirf light band karta hai (display:none).
v-if false → element exist hi nahi — costly create/destroy, lekin secret HTML DOM mein nahi.
v-show → hamesha DOM, CSS hide, toggle tez.
Rare / permission UI: v-if (admin panel). Dropdown bar-bar: v-show.
: shorthand v-bind ka, v-if ka nahi.
Example
```
<div v-if="isAdmin">Admin panel</div>
<div v-show="open">Dropdown</div>
```
Project example: Admin links v-if="role==='admin'". FAQ accordion v-show="open".
Viva tipSecurity ke liye sirf v-if kaafi nahi — API 403 bhi chahiye.
17

Difference between Vuex Store, Session Storage, and Local Storage.

Times asked 1

Official solution

SimpleStore reactive RAM. LS/SS persist strings. Combine rehydrate store from LS on boot.
Difference Vuex Store Session Local Storage.
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: login commit + setItem. main.js getItem commit.
18

Why is Vuex better than Session Storage/Local Storage?

Times asked 1

Official solution

SimpleSame API getItem/setItem. SS tab close pe saaf. LS survive. Shared computer pe SS thoda safer.
Token LS common. Session storage quiz in-progress bhi.
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: token localStorage. Don't mix randomly.
19

What are the new features in Vue 3?

Times asked 1

Official solution

SimpleVue 3 naya engine: Composition API, fragments, better TS, tree-shaking. Vue 2 Options + filters.
mounted vs onMounted. Filters Vue 3 mein hata — computed/methods.
Version package.json / Vue.version se dikhao. Jo use kiya uske hooks bolo.
SPA = ek HTML, Vue Router se views, full reload nahi. MPA = MAD1 Jinja har URL naya HTML.
Vue Router: routes array, router-view, router-link, meta.auth + beforeEach guard. Dynamic /venues/:id → $route.params.id.
Vite/CLI SFC + npm build dist/. CDN script tag, no SFC. Jo tumne use kiya wahi justify. Flask send_from_directory('dist') production pattern.
Project example: package.json vue ^3.x. setup() + onMounted fetch.
Viva tipVersion package.json / Vue.version se dikhao. MAD2 dono allowed usually — jo use kiya uske hooks bolo (mounted vs onMounted).
20
Difference between POST, PUT, and PATCH.

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

Difference between HTTP and HTTPS.

Times asked 6

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

Create an API that returns the sum of two numbers.

Times asked 1

Official solution

SimpleGET args a,b or POST JSON jsonify sum.
Create API sum two numbers.
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: request.args or json.
Project example: request.args or json.
23
Create a POST API that returns the start and end index of a substring within a parent string.

Times asked 1
Official solution

Simples.find(sub) start end. not found -1. POST start end index of substring.
Handle missing.
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
```
i = parent.find(sub)
return jsonify(start=i, end=i+len(sub)-1 if i>=0 else None)
```
Project example: Postman parent+sub.
24

Test the API using Postman or Thunder Client.

Times asked 1

Official solution

SimpleMethod URL Headers Authorization JSON body. 200/401 bina Vue — backend prove.
Login copy token. Collection. Thunder Client same.
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: Show 3 requests. Examiner loves this.
25

Set a default value in a form field.

Times asked 1

Official solution

Simplev-model initial data(){ city: 'Chennai' }. Set default value form field.
or :value.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: form data().
26

Fix a small bug/debugging task.

Times asked 1

Official solution

SimpleConsole/terminal padho, reproduce, smallest fix, regression na todo.
Examiner patience. Think aloud. Copilot band.
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: F12 / celery log / flask traceback.
27

Modify parking charge calculation to always charge for a full hour, even for partial usage.

Times asked 1

Official solution

Simplemath.ceil(minutes/60)*rate even 1 min = 1 hour.
Modify parking charge full hour.
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: ceil import math.
Project example: ceil import math.
28
Create a Vue component that displays a real-time clock.

Times asked 1
Official solution

SimplesetInterval mounted clearInterval unmounted. Real-time clock. Display server time refresh optional.
{{ now.toLocaleTimeString() }}.
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
```
data() { return { now: new Date() } },
mounted() { this.t = setInterval(() => this.now = new Date(), 1000) }
```
Project example: Clock.vue.
29

Implement text rotation logic in the backend.

Times asked 1

Official solution

SimpleBackend s[n:]+s[:n] rotate. API POST {text,n}. Implement text rotation backend.
Validate n.
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: new route.
Project example: new route.
30

Difference between Horizontal Scaling and Vertical Scaling.

Times asked 3

Official solution

SimpleVertical badi machine. Horizontal aur boxes + load balancer. JWT stateless horizontal friendly.
10k users: Postgres, Redis, gunicorn, CDN, pagination, indexes.
Millions: replicas, queue partition, more workers.
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: Course app vertical enough. Design answer scale-out.
31
What is SMTP?

Times asked 3
Official solution

SimpleSMTP = email bhejne ka protocol, jaise HTTP web ka.
Ports: 587 STARTTLS, 465 SMTPS, 25 server-server. Dev: MailHog 1025.
Flask-Mail wrap. Sync send slow — Celery task se bhejo.
Fayda: universal. Nuksaan: spam, deliverability (SPF/DKIM), no guarantee like API.
Example
```
app.config['MAIL_SERVER'] = 'localhost'
app.config['MAIL_PORT'] = 1025
mail.send(Message('Hi', recipients=['a@b.com'], body='Hello'))
```
Project example: MAIL_SERVER=localhost MAIL_PORT=1025. Production later SendGrid/SES.
Viva tipFayda: universal. Nuksaan: deliverability, spam, sync send slow — isliye Celery + MailHog in dev.
32
Disable GitHub Copilot during the viva.

Times asked 1
Official solution

SimpleViva Copilot/ChatGPT band. Docs OK usually. Original soch live coding.
VS Code disable extension workspace.
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
```
VS Code: Extensions → GitHub Copilot → Disable (Workspace).
```
Project example: Extensions disable. Second screen clear.
Viva tipDocs/MDN khol sakte ho usually, paste-from-ChatGPT nahi.

See reviews Level2_142 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
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.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub repository.

Times asked 9
Official solution

SimpleRepo = evidence tumne kaam kiya: commits, collaborators, README.
Regular messages, last-day dump nahi. Private access pehle de do. Main branch submitted ZIP se match.
Collaborator settings. Commit dates.
Example
```
Settings → Collaborators: apna + teammate (agar allowed).
Commits: regular messages, last-day dump nahi.
```
Project example: Settings → Collaborators. git log --oneline. README run steps.
Viva tipPrivate repo access de do pehle. Main branch latest submitted ZIP se match honi chahiye.
3

Download the project from the portal and run it.

Times asked 6

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
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.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
4

Explain your project statement.

Times asked 1

Official solution

SimpleProblem: users book X admin manage Y. Your instance parking/jobs/tickets. Explain project statement.
1 minute.
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: README first paragraph.
Project example: README first paragraph.
5
Demonstrate all CRUD operations.

Times asked 3
Official solution

SimpleCRUD 4 operations live: add list edit delete, list refresh.
REST mapping. Related bookings after delete ready answer.
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
```
POST /api/venues → add
GET /api/venues → list
PUT /api/venues/3 → edit
DELETE /api/venues/3
```
Project example: Admin venues. Postman + UI dono.
Viva tipUpdate ke baad list refresh hoke naya data dikhe. Delete ke baad related bookings kya hoti hain, ready raho.
6
Demonstrate the search functionality.

Times asked 4
Official solution

SimpleSearch demo cases.
See earlier essay.
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
```
q = request.args.get('q', '').strip()
items = Venue.query.filter(Venue.name.ilike(f'%{q}%')).all()
return jsonify([v.serialize() for v in items])
```
Project example: UI + API.
Viva tipEmpty search, no-match, case-insensitive (ilike) teen cases dikhao.
7

Demonstrate all core features of the application.

Times asked 1

Official solution

SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.
Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.
Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.
Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search + charts
6) CSV export / email job
7) Logout
Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.
Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.
8

Demonstrate backend jobs (scheduled and user-triggered).

Times asked 1

Official solution

SimpleButton POST .delay() 202. Poll status. Beat nahi, worker haan.
Export vs daily reminder difference.
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: Export CSV button. Network 202.
Project example: Export CSV button. Network 202.
9
Demonstrate CSV export.

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

Times asked 1
Official solution

SimpleMiss print/DB, hit silent, timeout expiry, write delete.
Best viva demo Redis.
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
```
@cache.cached(timeout=30, key_prefix='venues')
def get_venues():
    print('DB queried')
    return jsonify(...)
```
Project example: GET twice + POST + GET.
Viva tipprint() ya SQL echo se miss/hit dikhao. Timeout 10–30s karke expiry bhi demo kar sakte ho.
11
Demonstrate daily reminders and monthly reports.

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
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.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
12

Show how frontend and backend are connected.

Times asked 1

Official solution

SimpleClick → Vue method → fetch → Flask auth → DB → jsonify → Vue state → template. Celery: delay Redis worker email.
Button until backend completes: include jobs path if export.
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: Book button sequence 6 steps aloud.
13

Extend the deadline of an existing entity (project-specific live change).

Times asked 1

Official solution

SimplePATCH entity.deadline future admin. Extend deadline existing entity.
Validate date.
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: admin edit.
Project example: admin edit.
14

Show the generated authentication token.

Times asked 1

Official solution

SimpleLogin Network JSON token. LS. jwt.io payload. Don't paste secret public.
Show generated authentication token.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: Copy token jwt.io.
15

Show where the authentication token is generated.

Times asked 1

Official solution

SimpleLogin/register success return create_access_token. Show generated token Network + LS.
Where tokens generated.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: login response.
16

Show where the token is stored on the frontend.

Times asked 1

Official solution

SimpleDevTools Application LS. Key name. Logout clears. How JWT stored browser.
Show where token stored frontend.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: Application tab.
17

What security mechanism have you used?

Times asked 2

Official solution

SimplePassword hash, JWT, RBAC, CORS whitelist, HTTPS prod, no secrets Vue.
Least privilege. Don't CORS *.
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 4 you actually coded.
Project example: List 4 you actually coded.
18

Is auth_required() necessary if roles_required() is already used? Can they be combined?

Times asked 1

Official solution

Simpleroles_required usually login imply. Extra auth_required explicit stacking OK.
Is auth_required necessary if roles_required? Can combine? Yes.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: We stacked both admin.
19
Vue CLI vs Vue CDN.

Times asked 6
Official solution

SimpleCDN = Vue script tag se, jaise pen drive. CLI/Vite = poori factory (SFC, npm, bundle).
CDN: no build, chhote apps, exam PC pe Node nahi to bhi chal. Weak: no .vue compile, 3rd-party cache, scale/team.
CLI/Vite: Single File Components, env, code-split, production dist/. Scalable.
Examiner 'which + why' — jo use kiya wahi justify, doosra naam rato mat.
Example
```

<script src="https://unpkg.com/vue@3/dist/vue.global.js"></script>

# Vite
npm run dev
npm run build
```
Project example: CDN: index.html unpkg vue. CLI: package.json, npm run serve / vite.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai — jo use kiya wahi justify karo.
20
What are Vue Lifecycle Hooks?

Times asked 5
Official solution

SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho — mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya — fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
Composition: onMounted(() => {}) setup ke andar.
Example
```
export default {
  async mounted() {
    const r = await fetch('/api/venues')
    this.venues = await r.json()
  }
}
```
Project example: Venues.vue mounted fetch list. Clock component unmounted pe interval clear.
Viva tipcreated: data setup, DOM nahi. mounted/onMounted: $el mil gaya — fetch yahi. Dashboards isliye onMounted use karti hain.
21

Explain each lifecycle hook.

Times asked 1

Official solution

SimplebeforeCreate/created init. beforeMount/mounted DOM. beforeUpdate/updated patch. beforeUnmount/unmounted cleanup. setup composition.
Explain each lifecycle hook. Which used: mounted + unmount cleanup.
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: Don't claim unused beforeCreate.
22
What are 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.
23
What is v-model?

Times asked 4
Official solution

Simplev-model do tarfa glue: input likho to data, data badlo to input.
Shorthand :value + @input. Forms ke liye. Display ke liye {{ }} / v-bind kaafi.
v-model.number number input. checkbox boolean. select string.
Directives Vue ke special attributes hain — HTML ko superpower: v-if/v-show, v-for, v-bind (:), v-on (@), v-model.
v-if DOM se hataata/jodta. v-show sirf CSS display. Rare/permission: v-if. Bar-bar toggle: v-show. v-model two-way form. v-bind one-way JS→attribute.
:key v-for pe zaroori warna Vue galat reuse. v-html XSS. Secret UI ke liye sirf v-if kaafi nahi — API 403 bhi.
MAD1 Jinja server HTML. MAD2 yeh directives browser mein reactive.
Example
```
<input v-model="email">

<input :value="email" @input="email = $event.target.value">
```
Project example: Login email/password v-model, submit pe JSON POST.
24

Difference between one-way and two-way binding.

Times asked 1

Official solution

SimpleTwo-way = UI aur data sync. Vue mein v-model. One-way mustache/v-bind.
Parent→child props one-way. Child change emit se. v-model on component = prop + emit update.
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: Booking qty input v-model. Seats left sirf {{ available }}.
25
What is Vuex?

Times asked 3
Official solution

SimpleVuex/Pinia ghar ka notice board. Har room (component) same user/token dekhe.
State data, mutations sync change, actions async API phir commit.
Local data() sirf us component. Token/user global.
Pinia Vue 3 official, kam boilerplate. Vuex older MAD2 still common.
Example
```
state: { user: null }
mutations: { setUser(s, u) { s.user = u } }
actions: { async login({ commit }, form) {
  const u = await api.login(form); commit('setUser', u)
}}
```
Project example: store user + token login action. Navbar getters isAdmin. Logout clear LS+state.
Viva tipLocal/Session storage persist ke liye, reactive share ke liye store. Pinia Vue 3 official, Vuex older.
26

What is State Management?

Times asked 2

Official solution

SimpleShared state across components — Vuex/Pinia. Props hell avoid.
How share globally.
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: token user cart.
Project example: token user cart.
27

What is an async function?

Times asked 1

Official solution

Simpleasync hamesha Promise. return 1 → Promise.resolve(1).
What async returns. Incorrect use SyntaxError or unresolved promise.
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: async mounted.
Project example: async mounted.
28

What does an async function return?

Times asked 1

Official solution

SimpleAlways a Promise.
Even return 5.
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: Don't console.log(asyncFn()) expecting 5 without await.
Project example: Don't console.log(asyncFn()) expecting 5 without await.
29

Difference between synchronous and asynchronous functions.

Times asked 1

Official solution

SimpleSync line pe ruk jao (2+2). Async I/O pe wait karte hue baaki kaam chalte (fetch, Celery).
JS async ≠ Celery async jobs. Context se bolo.
Why async jobs: slow/scheduled/bulk off request thread.
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: Login sync hash check fast. Email Celery async. Vue fetch async.
30
What is a Promise?

Times asked 4
Official solution

SimplePromise IOU hai: abhi nahi, baad mein value ya error.
States: pending, fulfilled, rejected. fetch() promise return. then/catch/finally.
async function hamesha Promise return. await usko unwrap. Galat: await without async; missing await to Promise object milta data nahi.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Example
```
fetch('/api/hello')
  .then(r => r.json())
  .then(d => console.log(d))
  .catch(err => console.error(err))
```
Project example: fetch venues .then json. Ya async mounted await.
31

Explain the stages/states of a Promise.

Times asked 1

Official solution

Simplepending → fulfilled value / rejected error. then catch finally.
async/await sugar same states.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Project example: Network pending then 200.
Project example: Network pending then 200.
32
What are Higher-Order Functions? Give an example.

Times asked 1
Official solution

SimpleHOF: function in or out. map filter forEach.
multiply by 70: .map(x => x*70). filter score.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Example
```
nums.map(n => n * 70)
users.filter(u => u.score > 15)
```
Project example: Live array tasks.
33

What happens if async is used incorrectly?

Times asked 1

Official solution

SimpleForgot await, uncaught reject, setState after unmount, race.
try/catch. loading flag.
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: Show a catch you wrote.
Project example: Show a catch you wrote.
34

What happens when a parent record is deleted?

Times asked 1

Official solution

SimpleDepends ondelete: CASCADE children jaate, RESTRICT fail, SET NULL.
Bookings/venue: business. Soft-delete safer. Doctor deleted similarly.
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: Explain YOUR models ondelete. Don't guess opposite cascade.
35
Explain Cascading (ON DELETE CASCADE).

Times asked 1
Official solution

SimpleCASCADE = parent gaya to bacche bhi. Restrict = pehle bacche sambhalo.
ON DELETE CASCADE SQL. SQLAlchemy cascade='all, delete-orphan' collection se orphans.
Opposite auto nahi — child delete se parent nahi marata.
Venue delete: bookings restrict (safer viva) ya cascade+cancel policy. Examiner design poochta hai.
ON UPDATE CASCADE PK change — rare. SET NULL, RESTRICT bhi options.
Example
```
shows = db.relationship('Show', cascade='all, delete-orphan', back_populates='venue')
```
Project example: Show belongs Venue delete-orphan. Booking venue pe restrict — 'reassign first'.
Viva tipVenue delete pe bookings: restrict (mat delete) ya cascade+refund policy. Examiner design poochta hai. Cascade UPDATE bhi hota hai (PK change) — rare.
36

Can cascading be used for operations other than DELETE?

Times asked 1

Official solution

SimpleON UPDATE CASCADE, SET NULL, RESTRICT besides DELETE.
Can cascading other operations. Yes.
ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: We used delete cascade/restrict.
37

Show where Celery is configured.

Times asked 1

Official solution

SimpleTask function, beat dict, delay() call, worker+beat terminals, MailHog/CSV.
App context DB. Args serializable. How many jobs: reminder, monthly, export — gino honestly.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: tasks.py + config schedule + POST export.
38

Show the Celery tasks.

Times asked 1

Official solution

SimpleTask function, beat dict, delay() call, worker+beat terminals, MailHog/CSV.
App context DB. Args serializable. How many jobs: reminder, monthly, export — gino honestly.
Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.
Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: tasks.py + config schedule + POST export.
39

Show user-triggered tasks.

Times asked 1

Official solution

SimpleButton POST .delay() 202. Poll status. Beat nahi, worker haan.
Export vs daily reminder difference.
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: Export CSV button. Network 202.
Project example: Export CSV button. Network 202.
40
Show scheduled tasks.

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
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.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
41

Change the cache timeout and demonstrate cache expiry.

Times asked 1

Official solution

Simpletimeout=10, wait, third request phir miss. Restart after change.
Or cache.delete after update faster.
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.
Project example: Decorator timeout chhota temporarily.
42
Create a new API that returns "Hello World".

Times asked 1
Official solution

Simplejsonify(message='Hello World'). Create API Hello World. Write Hello World API.
Simple.
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
```
@app.route('/api/hello')
def hello():
    return jsonify(message='Hello World')
```
Project example: GET /api/hello.
43
Create an API that returns the current server time (time.time()).

Times asked 1
Official solution

Simple
```
jsonify(server_time=time.time()) epoch. Create API current server time. Display frontend refresh button clock.
```
time vs datetime.
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: GET /api/time Vue button.
44

Create an API route and display the response on the frontend.

Times asked 1

Official solution

SimpleFlask jsonify then Vue fetch display. CORS if ports differ. Create API display frontend.
Connectivity test examiner loves.
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: /api/hello + Hello.vue.
45

Add a new Vue component that: Fetches data from the backend. Displays the response. Includes a button to fetch the data again.

Times asked 1

Official solution

SimpleNew .vue button @click load data items fetch v-for. Route optional.
Add new Vue component fetches...
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: components/ApiBox.vue.
46

Display a backend message ("Hello") on the frontend.

Times asked 1

Official solution

SimpleGET /api/hello {message} Vue mounted {{ message }}. Fetch Hello World backend display.
Display backend message Hello.
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: Simplest full stack proof.
47
Display the current server time on the frontend with a Refresh button.

Times asked 1
Official solution

SimplesetInterval mounted clearInterval unmounted. Real-time clock. Display server time refresh optional.
{{ now.toLocaleTimeString() }}.
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
```
data() { return { now: new Date() } },
mounted() { this.t = setInterval(() => this.now = new Date(), 1000) }
```
Project example: Clock.vue.
48

What frameworks have you used in your project?

Times asked 1

Official solution

SimpleHar lib ek line why — list 40 mat.
Flask, SQLAlchemy, JWT/Security, CORS, Caching+Redis, Celery, Vue+Router, Vuex/Pinia, Axios/fetch, Chart.js, Bootstrap.
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: requirements.txt + package.json top 6 open karke bolo.
Viva tipHar lib ek line why: CORS alag origin, Redis tez, Celery async, Chart.js dashboard.
49
Explain models.py.

Times asked 21
Official solution

Simplemodels.py tables ki blueprint. Har class ek table, har Column ek field.
PK id, FK dusri table, relationship dono taraf, serialize() JSON (password mat).
app factory db.init. resources APIs use models.
Examiner random line: type, nullable, unique, ondelete.
Suggested flow1) Har table → class
2) PK id
3) FK
4) relationship()
5) serialize()
Example
```
class Booking(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    user = db.relationship('User', back_populates='bookings')
```
Project example: User, Role, Venue/Show/Booking (ya Drive/Application). Draw 1-M.
Viva tipExaminer random line poochhe: column type, FK, constraint. Draw 1-M / M-M on paper mentally.
50

Explain resources.py.

Times asked 1

Official solution

SimpleFlask-RESTful Resource GET POST. marshal fields. Alternative plain routes.
Explain resources.py.
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: class VenueAPI(Resource).
Project example: class VenueAPI(Resource).
51

How much AI did you use in your project?

Times asked 1

Official solution

SimpleSach % + kahan + kaise verify + kya seekha. Report se contradict mat.
Boilerplate vs business logic. Examiner process poochta. 'Sab ChatGPT' red flag.
Verify: docs, run, edge case. Seekha: CORS, JWT exp, beat vs worker.
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: Jo number form/PDF mein hai wahi. Example file jo AI se start kiya, khud debug kiya.
Viva tipExaminer 'kya seekha / kaise check kiya' pe marks. 'Sab ChatGPT' red flag. Jo khud debug kiya woh story ready rakho.

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