Search – Lazy IITians Viva Prep

See reviews proctor_101 MAD2 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1

Demonstrate the Admin module first, then the User module.

Times asked 1

Official solution

SimpleAdmin CRUD first then user consume. Examiner flow follow skip mat. Demonstrate Admin module first then User.
Roles.
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: Two logins.
2

Include HTML tags in the movie description.

Times asked 1

Official solution

SimpleStore tags v-html XSS warn whitelist. Include HTML tags movie description.
Sanitize.
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: v-html description.
Project example: v-html description.
3

Explain your codebase, starting with: Models APIs Celery tasks Vue frontend

Times asked 1

Official solution

SimpleOrder models → APIs/auth → celery → Vue router/pages → fetch.
Each layer 1 example. Entire codebase request.
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.
Suggested flow1) models.py
2) auth login/JWT
3) CRUD
4) cache
5) celery
6) Vue + store
Project example: 6 file tour.
4
How do you create an index in SQLAlchemy?

Times asked 1
Official solution

SimpleIndex kitab ki suchi — search tez, write thoda mehnga.
B-tree typically. filter wale columns, FKs. Over-index mat.
joinedload N+1 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
```
db.Column(db.String(80), index=True)
db.Index('ix_name_city', User.name, User.city)
```
Project example: email index, venue.name search index.
5

Explain Celery and Celery Beat.

Times asked 1

Official solution

SimpleTasks list, schedule, broker, trigger, verify MailHog/logs.
Beat vs worker. User vs scheduled. App context.
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: Three tasks. Commands README.
6

What are the components of Celery?

Times asked 1

Official solution

SimpleClient (Flask .delay), Broker (Redis), Worker. Optional Beat + result backend.
Viva line'Flask produce, Redis transport, worker consume.'
include task modules, app context ke andar DB session. Windows pe eventlet/gevent issues — docs se command.
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: create_app ke baad celery.conf.update. tasks import taaki register hon.
Viva tip
Viva line'Flask task produce karta hai, Redis transport, worker consume.'
7

How do you stop/shutdown a Celery worker without using the terminal?

Times asked 1

Official solution

SimpleCTRL+C terminal. celery control shutdown. Unacked requeue config.
Viva terminal hi. Bina terminal pid kill.
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: Don't kill -9 first, graceful.
8
What is caching?

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

What is the difference between Memcached and Redis?

Times asked 2

Official solution

SimpleDono RAM cache. Redis zyada smart: lists, hashes, pub/sub, persistence, Celery broker.
Memcached: simple key-value, yahi. Redis: data structures + expire + optional disk dump.
MAD2 Redis choose — cache aur broker ek hi process. Memcached Celery nahi chalaata.
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: Tumhare config mein CACHE_TYPE RedisCache, CELERY broker redis://. Memcached nahi.
Viva tipMAD2 mein Redis isliye — cache + broker ek hi tool. Memcached Celery nahi chalaata.
10

What is memoization?

Times asked 4

Official solution

SimpleMemoize = function(args) ka answer copy. Caching broader (HTTP, Redis, page).
Fibonacci textbook. Flask @cache.memoize. cached whole view.
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: get_user(id) memoize. venues list cached.
11

What is the base Exception class in Python?

Times asked 1

Official solution

SimpleBaseException sabka base. Usual catch Exception. Base includes SystemExit KeyboardInterrupt.
Base class of all exceptions. Base Exception class Python.
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 except: bare.
12

Is Flask open source?

Times asked 1

Official solution

SimpleHaan, BSD-licensed open source.
Is Flask open source? Yes.
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: Don't overthink.
Project example: Don't overthink.
13

Can Flask be used for large-scale applications?

Times asked 1

Official solution

SimpleHaan blueprints gunicorn DB. Ops matter. Many companies started Flask. Not magic unlimited.
Can Flask large-scale? Yes with architecture.
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: Course app small. Prod pattern known.
14

Show where you have used the v-for directive in your code.

Times asked 1

Official solution

SimpleList pages v-for :key. Show where used v-for. Show list students loop.
Open template.
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.
Project example: Dashboard.vue.
15

What are filters in Vue?

Times asked 1

Official solution

SimpleVue2 filters | capitalize. Vue3 hata — methods/computed. Backend filters query params.
Frontend API filters computed or ?q=
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 Vue3 no | filter syntax.
16
What are slots in Vue?

Times asked 1
Official solution

SimpleSlots = dabbe ke andar parent apna HTML daal de. Props data, slots markup.
Default slot, named slots. App.vue router-view layout jaisa outlet.
Agar nahi use kiya: 'layout router-view se kiya' valid.
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
```
<div class="card"><slot>Default</slot></div>
<Card><p>Custom body</p></Card>
```
Project example: Card.vue <slot>Default</slot>. Parent custom body.

See reviews Level2_100 MAD2 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1
Introduce yourself.

Times asked 7
Official solution

Simple30s: naam, city, degree, project, stack Vue Flask Redis Celery.
1 unique feature. No rattu script. Currently doing short then project.
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
```
Main Priya, IITM BS. MAD2 SPA — Vue, Flask REST, JWT, Redis cache, Celery reports.
```
Project example: Parking/ticket/job-portal one-liner.
Viva tipScript ratt ke mat bolo. Project ka 1 unique feature highlight karo.
2

What are you doing apart from this degree? Why are you pursuing this degree?

Times asked 1

Official solution

SimpleShort honest job/family/other. Why degree 20s then project wapas.
Don't ramble.
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: Bridge to MAD2 skills.
Project example: Bridge to MAD2 skills.
3

Demonstrate your complete project.

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

Explain the search implementation in your project.

Times asked 1

Official solution

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

What frameworks and technologies have you used?

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

What's the backbone/architecture of your application?

Times asked 1

Official solution

SimpleClient-server SPA + background workers. Boxes: Vue | HTTP JSON | Flask | SQLite | Redis | Celery.
Not microservices. Layered REST. Cache aur queue extra.
Scale story alag: gunicorn, Postgres, more workers.
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'.
Suggested flowBrowser Vue → HTTP JSON → Flask → SQLAlchemy → DB
Extra: Redis cache; Celery via Redis
Project example: Draw 6 boxes viva mein. Point to folders.
7

Show your data models.

Times asked 1

Official solution

Simplemodels.py tour + draw. Design decisions unique/cascade.
SQL models = same.
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: 3 relationships explain.
8

Show your Celery jobs and reports.

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

Show how emails are being sent from your application.

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

What styling approach have you used on the frontend?

Times asked 1

Official solution

SimpleBootstrap utilities and/or custom.css. Grid responsive. Colors variables.
d-flex container btn navbar. Custom for brand. Chart.js 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.
Project example: Inspect a button class. bootstrap CDN or npm.
11
What is Flask?

Times asked 6
Official solution

SimpleFlask halka Python web framework. MAD2 REST API. Open source BSD.
Large apps possible blueprints+gunicorn. Flask(__name__) paths. Dev server not prod.
create_app factory tests/celery.
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.
Example
```
app = Flask(__name__)
@app.route('/api/hello')
def hello():
    return jsonify(message='Hello World')
```
Project example: create_app register db cache cors jwt celery.
Viva tipOpen source haan. Flask(__name__) root path/templates locate karta hai — hataoge to config confuse.
12

What is an API?

Times asked 8

Official solution

SimpleInterface programs use. REST JSON over HTTP MAD2.
What is an API.
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/hello.
Project example: GET /api/hello.
13
Explain HTTP verbs (GET, POST, PUT, PATCH, DELETE).

Times asked 1
Official solution

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

Times asked 1
Official solution

Simplejsonify Flask ka JSON response + sahi Content-Type. dumps sirf string.
marshal schema. serialize models. pickle APIs pe nahi.
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.
Example
```
return jsonify(users=[{'id': u.id, 'email': u.email} for u in User.query.all()])
```
Project example: return jsonify(users=[u.serialize() for u in users])
15

What security mechanism have you implemented?

Times asked 1

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

What other authentication mechanisms are available in Flask besides JWT?

Times asked 1

Official solution

SimpleFlask-Login sessions, HTTP Basic, OAuth. We used JWT. Available besides JWT.
What other authentication Flask.
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: Not implemented OAuth.
17

How is JWT built?

Times asked 1

Official solution

Simpleheader+payload base64 HMAC secret → signature three segments. How JWT built.
HS256.
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: jwt.io.
18

How is JWT validated?

Times asked 1

Official solution

SimpleSplit decode hmac compare exp < now user exists. Invalid 401. How JWT validated.
Library does it @jwt_required.
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: Wrong token Postman 401.
19
JWT vs Session-based authentication.

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.
20
What is RBAC (Role-Based Access Control)?

Times asked 3
Official solution

SimpleRBAC = role ka badge. Admin badge se delete, user badge se sirf book.
Role-Based Access Control. Har user pe alag permission list nahi — roles.
Models: User M-M Role association. Decorators @roles_required. Vue v-if + router meta.
Frontend hide UX. Backend 403 real security.
Example
```
if current_user.roles[0].name != 'admin':
    return jsonify(msg='Forbidden'), 403
```
Project example: roles_users table. admin stats API roles_required. User booking POST user role.
Viva tipCode mein roles_required, Vue meta.role, models User↔Role many-to-many (roles_users table).
21
What is SQLAlchemy?

Times asked 8
Official solution

SimpleSQLAlchemy toolkit + ORM. Flask-SQLAlchemy wrapper db.
URI sqlite:///app.db. Postgres postgresql://. Dialects MySQL MSSQL.
Session add/commit/rollback. IntegrityError catch.
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
```
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db'
# migrate: URI postgres://user:pass@host/db  + psycopg2
```
Project example: config SQLALCHEMY_DATABASE_URI. db.create_all() ya migrate.
22

Why do we use SQLAlchemy instead of directly using SQLite?

Times asked 1

Official solution

SimpleModels safety portability. Raw OK reports. text()+format still inject.
SQLAlchemy injection possible if you raw concat.
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: No f"SELECT ... {name}".
23

Which databases are supported by SQLAlchemy?

Times asked 1

Official solution

SimpleSQLite MySQL Postgres MSSQL Oracle via dialects + drivers.
Which DBs supported by SQLAlchemy. Can MSSQL? Yes pyodbc.
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 used sqlite. Could switch URI.
24
What is ORM? What are its advantages?

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

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

What SQL constraints are available?

Times asked 1

Official solution

SimpleNOT NULL UNIQUE PK FK CHECK. Integrity even if API bug. Two writers safer.
Why required. SQL constraints available.
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: email unique. user_id FK.
27

Is there any one-to-one relationship in your models?

Times asked 1

Official solution

SimpleHaan Profile / nahi only 1-M. Don't invent.
Is there one-to-one.
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: Open models.
Project example: Open models.
28

Explain relationships between your tables.

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.
29
What are SQL aggregate functions?

Times asked 1
Official solution

SimpleCOUNT SUM AVG MIN MAX. Dashboard stats.
SQL aggregate functions.
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
```
db.session.query(func.count(Booking.id)).scalar()
```
Project example: func.count(Booking.id).
30

Explain GROUP BY.

Times asked 1

Official solution

SimpleGROUP BY collapse + aggregates per group. Dashboard count per venue.
Explain GROUP BY.
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: stats API func.count group venue_id.
Project example: stats API func.count group venue_id.
31

Explain HAVING.

Times asked 1

Official solution

SimpleHAVING after group. WHERE before. users with >5 bookings HAVING COUNT>5.
Explain HAVING. WHERE cannot use COUNT same way.
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: Venues having count>10.
32

Explain SQL joins.

Times asked 1

Official solution

SimpleJOIN ON fk=pk. inner match dono. left left saari. SQLAlchemy .join(User.roles).
What are joins. Explain SQL joins.
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: bookings join user email list.
33

Explain subqueries.

Times asked 1

Official solution

SimpleQuery inside query. Exists / in_. Users bookings>3.
Explain subqueries.
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: Maybe not used — theory + how would.
Project example: Maybe not used — theory + how would.
34

What happens to AUTO_INCREMENT values after deleting a record?

Times asked 1

Official solution

SimpleDelete ke baad AUTOINCREMENT wapas nahi. Sequence aage. Gaps normal.
Last auto-increment sqlite_sequence. Not needed usually.
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 rely on ids 1,2,3 after deletes.
35

What is the last auto-increment value?

Times asked 1

Official solution

Simplesqlite_sequence / information_schema. Last auto-increment value. Not needed usually.
SELECT seq FROM sqlite_sequence.
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 rely.
Project example: Don't rely.
36

How can you migrate data from one database to another?

Times asked 1

Official solution

SimpleDump SQL/CSV new URI alembic import. sqlite3 .dump | psql careful types.
How migrate data one DB to another.
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: Not done, steps known.
37
What is Vue.js?

Times asked 5
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.
38
What is the difference between Vue CDN and Vue 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.
39

Which one did you use and why?

Times asked 2

Official solution

SimpleJo actually use kiya: CDN vs CLI / Vuex vs Pinia / fetch vs Axios — 1 reason + tradeoff.
Examiner vague 'which one' previous question se jodo. Package.json dikhao.
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 invent unused library.
40
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.
41

What is Pinia?

Times asked 2

Official solution

SimplePinia naya store: mutations nahi, seedha state. Vue 3 recommended.
defineStore. Vuex vs Pinia: naya project Pinia. Purana Vuex valid.
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: stores/user.js. Agar Vuex hai to Pinia ka naam mat lo unless used.
42

Vuex vs Pinia.

Times asked 1

Official solution

SimplePinia naya store: mutations nahi, seedha state. Vue 3 recommended.
defineStore. Vuex vs Pinia: naya project Pinia. Purana Vuex valid.
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: stores/user.js. Agar Vuex hai to Pinia ka naam mat lo unless used.
43
What are Vue lifecycle hooks?

Times asked 11
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.
44

Why are lifecycle hooks useful?

Times asked 1

Official solution

SimpleRight time side effects fetch timers. Cleanup unmount leak. Fetch after DOM.
Why lifecycle hooks useful.
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: mounted fetch, beforeUnmount clearInterval.
45

What is data binding in Vue?

Times asked 1

Official solution

SimpleMustache {{ }}, v-bind attrs, v-model forms, v-html careful.
Data binding in Vue.
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: Form + text + image.
Project example: Form + text + image.
46
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.
47
What is v-bind?

Times asked 1
Official solution

Simplev-bind one-way: JS → HTML attribute. UI se data automatic nahi aata.
Images src, disabled, class object, href. Colon shorthand.
Dynamic class :class="{ active: isOn }".
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
```
<img :src="posterUrl" :alt="title">
<button :disabled="loading">Save</button>
<div :class="{ active: isOn }">
```
Project example: Poster :src="show.poster". Submit :disabled="loading".
48
Difference between v-model and v-bind.

Times asked 4
Official solution

SimpleBind = ek tarfa poster lagana. Model = form jo typed text wapas data mein likhe.
Display/image/disabled → v-bind. Input/textarea/select → v-model.
Dono mix: <input v-bind:placeholder="hint" v-model="q">.
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
```
<p>{{ price }}</p>
<img :src="url">
<input v-model="price">
```
Project example: Search box v-model q. Result images :src.
49
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.
50
What are Vue directives?

Times asked 6
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.
51
How do components communicate in Vue?

Times asked 2
Official solution

SimpleBaat: props se neeche, emit se upar. Door ke rishte: store ya provide/inject.
Grandparent→grandchild props drilling ugly. Vuex/Pinia ya provide('user').
Did you use? List+card files naam lo.
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
```
provide('user', user)
const user = inject('user')
```
Project example: Dashboard v-for BookingCard. Card emit 'cancel'.
Viva tip3+ level props drilling se better store. Navbar user info store se lo.
52
Explain Props.

Times asked 1
Official solution

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

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

Explain Slots.

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

How do you pass data from parent to child and child to parent?

Times asked 1

Official solution

SimpleProps down emit up. Store distant. provide inject. Grandparent chain or store.
Parent to child and back. Grandparent grandchild.
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: 3+ levels store better.
56

What is the Composition API?

Times asked 1

Official solution

SimpleOptions: data methods computed alag. Composition: setup() logic group, reuse.
Vue 3 both. Course either. Don't claim unused API.
Component = reusable UI block (Navbar, Card). Props parent→child data, emit child→parent event. Slots parent HTML inner content.
computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.
SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.
Project example: script setup vs export default options — open file.
57

Composition API vs Options API.

Times asked 1

Official solution

SimpleOptions: data methods computed alag. Composition: setup() logic group, reuse.
Vue 3 both. Course either. Don't claim unused API.
Component = reusable UI block (Navbar, Card). Props parent→child data, emit child→parent event. Slots parent HTML inner content.
computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.
SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.
Project example: script setup vs export default options — open file.
58

What changed from Vue 2 to 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).
59

What is v-memo?

Times asked 1

Official solution

Simplev-memo Vue3 skip re-render if deps same. Big lists.
Optimization. Tree shaking Vue3 modular.
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 unused, theory. v-for :key more important.
60

What Vue 3 optimizations (e.g., Tree Shaking) are available?

Times asked 1

Official solution

SimpleOptions: data methods computed watch props components mounted. Tree shaking fragments proxy v-once v-memo Vue3.
Which you used name. New Vue3 features list honestly used.
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: Open SFC options vs setup.
61
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.
62
How does Celery work?

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

How many Celery jobs/tasks have you implemented?

Times asked 1

Official solution

SimpleGino jo implement: generally reminder, monthly, export. Beat schedule dikhao.
Don't claim 5 if 2.
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: Open beat dict count keys + extra delay() tasks.
64
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.
65
What is caching?

Times asked 23
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.
66

Why do we use caching?

Times asked 5

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

Difference between Redis and Memcached.

Times asked 1

Official solution

SimpleDono RAM cache. Redis zyada smart: lists, hashes, pub/sub, persistence, Celery broker.
Memcached: simple key-value, yahi. Redis: data structures + expire + optional disk dump.
MAD2 Redis choose — cache aur broker ek hi process. Memcached Celery nahi chalaata.
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: Tumhare config mein CACHE_TYPE RedisCache, CELERY broker redis://. Memcached nahi.
Viva tipMAD2 mein Redis isliye — cache + broker ek hi tool. Memcached Celery nahi chalaata.
68
What are Webhooks?

Times asked 7
Official solution

SimpleWebhook = woh tumhe call karta hai. API = tum unhe call karte ho.
Payment success pe Stripe tumhare /webhooks/payment pe POST. Tum poll nahi karte.
API pull, webhook push. WebSocket dono taraf live connection. SSE server→client stream.
MAD2 mostly REST APIs. Webhook theory + example kaafi. Verify signature production mein.
Example
```
@app.route('/webhooks/payment', methods=['POST'])
def hook():
    event = request.json
    ...
```
Project example: Agar implement nahi: 'course REST. Webhook design: POST /webhooks/booking-paid'.
Viva tipAPI pull, webhook push. WebSocket dono taraf live. SSE server → client stream.
69
Difference between Webhooks and APIs.

Times asked 1
Official solution

SimpleWebhook = woh tumhe call karta hai. API = tum unhe call karte ho.
Payment success pe Stripe tumhare /webhooks/payment pe POST. Tum poll nahi karte.
API pull, webhook push. WebSocket dono taraf live connection. SSE server→client stream.
MAD2 mostly REST APIs. Webhook theory + example kaafi. Verify signature production mein.
Example
```
@app.route('/webhooks/payment', methods=['POST'])
def hook():
    event = request.json
    ...
```
Project example: Agar implement nahi: 'course REST. Webhook design: POST /webhooks/booking-paid'.
Viva tipAPI pull, webhook push. WebSocket dono taraf live. SSE server → client stream.
70

Difference between APIs, Webhooks, and WebSockets.

Times asked 1

Official solution

SimpleAPI you call them. Webhook they call you. WebSocket both stay connected.
Difference APIs Webhooks WebSockets.
HTTP postcard (request-response). WebSocket phone call (dono taraf live). SSE radio (server→client stream). Webhook unka server tumhe POST karta hai (payment).
MAD2 mostly REST. Live dashboard = poll + Redis cache kaafi. Agar implement nahi kiya to design bolo, jhoot mat.
Project example: We REST. Others theory.
Project example: We REST. Others theory.
71

Difference between AJAX and Fetch.

Times asked 1

Official solution

SimpleAJAX idea hai, Fetch uska modern tool, Axios optional wrapper.
Examiner difference poochhe: AJAX umbrella, fetch function, axios package.
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.
Project example: Tumhare components fetch ya axios — jo file hai woh dikhao.
72

Difference between Local Storage and Session Storage.

Times asked 2

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

Send an email whenever a new show is created.

Times asked 1

Official solution

Simplecommit ke baad .delay(show.id) ya mail.send. Don't before commit (id nahi).
Failure shouldn't rollback booking unless 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.
Project example: create_show route end.
74

Display the remaining number of tickets on the booking page.

Times asked 1

Official solution

Simplecapacity - booked_sum server. Display remaining on booking page.
Don't cache too long if live 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: show.available field maintain.
Project example: show.available field maintain.
75

Show the number of tickets booked in each booking summary.

Times asked 1

Official solution

Simplefunc.count / len(user.bookings). Header bookings page. Display total/current count. Tickets booked each summary.
Show number tickets. Remaining tickets capacity-booked server compute.
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 available. Don't trust client.
76

Prevent duplicate category/service/campaign names.

Times asked 1

Official solution

Simplequery.filter_by(name).first() 409. DB unique=True. Prevent duplicate category/product.
Case: lower() before save.
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: unique constraint + 409.
Project example: unique constraint + 409.
77

Make uniqueness case-sensitive or case-insensitive as required.

Times asked 1

Official solution

Simpleemail.lower() before save. Unique index. SQLite LIKE case. Make uniqueness case-sensitive/insensitive as required.
Examiner specify.
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: normalize on write.
78

Prevent duplicate products/categories/services from being added.

Times asked 1

Official solution

Simplequery.filter_by(name).first() 409. DB unique=True. Prevent duplicate category/product.
Case: lower() before save.
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: unique constraint + 409.
Project example: unique constraint + 409.
79
Validate manufacturing and expiry dates before saving.

Times asked 1
Official solution

SimplePehle task repeat karke confirm, smallest diff, run, 2 line explain.
Model? API? sirf CSS? Edge case ek. Docs if they allow.
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) Confirm
2) Layer choose
3) Change → demo
4) Edge
Example
```
@app.route('/api/hello')
def hello():
    return jsonify(message='Hello World')
```
Project example: Jo feature domain (parking/jobs/tickets) usi language mein variable names.
80
Prevent users from booking the same service/appointment/parking slot twice.

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

Prevent users from booking multiple appointments at the same time.

Times asked 1

Official solution

Simpleoverlap query same user time 400. Prevent multiple appointments same time.
Frontend disable not enough.
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 time range.
Project example: Booking time range.
82

Prevent users from creating drives for past dates.

Times asked 1

Official solution

Simpleif drive.date < today abort 400. Frontend min=today. Prevent past dates.
Both layers.
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: create drive.
Project example: create drive.
83

Prevent users from applying to multiple drives/jobs after selection.

Times asked 1

Official solution

Simpleif selected_elsewhere 400. Unique where status=selected. Prevent applying multiple drives after selection.
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: Application model.
Project example: Application model.
84

Add an Admin activation route.

Times asked 1

Official solution

SimpleGET/POST /activate/<token> set active True. Add Admin activation route.
Auth admin.
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: new route.
85

Add or modify review disable functionality.

Times asked 1

Official solution

SimpleFlag can_review false after time/status. v-if + backend 400. Add or modify review disable.
Both layers.
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: Review.vue.
Project example: Review.vue.
86

Accept or reject offers from the dashboard.

Times asked 1

Official solution

SimpleAdmin PATCH application status. Notify email optional. Accept or reject offers dashboard.
Demo.
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 applications table.
Project example: Admin applications table.
87
Remove department matching criteria from the code.

Times asked 1
Official solution

SimplePehle task repeat karke confirm, smallest diff, run, 2 line explain.
Model? API? sirf CSS? Edge case ek. Docs if they allow.
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) Confirm
2) Layer choose
3) Change → demo
4) Edge
Example
```
@app.route('/api/hello')
def hello():
    return jsonify(message='Hello World')
```
Project example: Jo feature domain (parking/jobs/tickets) usi language mein variable names.
88
Modify UI elements (button, color, card/table view, etc.).

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

Debug and fix an existing bug.

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

Explain why you did not implement ticket cancellation.

Times asked 1

Official solution

SimpleTime. Design: status cancelled, seats restore, refund none in course.
Why not ticket cancellation.
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: Would add PATCH status + available++.
Project example: Would add PATCH status + available++.
91

Explain why some project features were 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.

See reviews Level2_98 MAD2 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1
What is ON DELETE CASCADE?

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

In the browser's Network tab, after logging in, the password is visible in the request payload. How would you prevent or hide it?

Times asked 1

Official solution

SimpleHTTPS encrypt transit. Network tab YOUR machine dikhega. Prod HTTPS. Never log passwords. Type=password UI only.
In Network tab password visible how prevent/hide.
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: Can't hide from user's own DevTools. HTTPS + don't echo password response.
3

How would you implement template inheritance (MAD1) in Vue? (For example, displaying the Navbar on every page.)

Times asked 1

Official solution

SimpleApp.vue Navbar + router-view. v-if isLoggedIn links.
MAD1 extends equivalent.
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: Navbar.vue.
Project example: Navbar.vue.

See reviews Level2_101 MAD2 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1

Demonstrate your project.

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

Explain all the features implemented in your application.

Times asked 1

Official solution

SimpleMilestone list tick. Extra last. Honest missing.
Core: auth rbac crud search cache celery charts.
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 features.
Project example: README features.
3

Explain your database schema and how the tables are connected.

Times asked 1

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.
4
Explain the search functionality in your project.

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

Explain the API endpoints implemented in your project and why they are used.

Times asked 1

Official solution

Simple3–4 routes deep: auth, validation, status, cache? Method body response error.
Login, list, create. Why each.
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: Open resources, pick examiner's choice.
6

Show the Celery jobs and explain the data flow.

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.
7
Where did you use Flask-Security in your project?

Times asked 2
Official solution

SimpleFlask-Security-Too: login, roles, hash, token, UserDatastore. Mixins models pe.
create_user, add_role, hash_password. JWT-extended alternative. Jo use kiya import dikhao.
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.
Example
```
user_datastore = SQLAlchemyUserDatastore(db, User, Role)
security = Security(app, user_datastore)
```
Project example: __init__ Security(app, user_datastore). User(UserMixin).
8

Have you referred to AI while writing your code?

Times asked 1

Official solution

SimpleHaan/kitna, kahan, verification story. Report match.
Same as AI percentage questions. Concrete bug you caught in AI 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: Celery Windows / cache stale AI galat tha, docs se fix.
9
What is a Blueprint in Flask?

Times asked 1
Official solution

SimpleBlueprint modules routes auth_bp api_bp. register_blueprint. Large structure.
What is Blueprint.
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.
Example
```
api = Blueprint('api', __name__, url_prefix='/api')
app.register_blueprint(api)
```
Project example: If used api = Blueprint url_prefix /api. If not, all app.route OK course.
10

What is Flask(__name__)? Can we remove the __name__ parameter?

Times asked 1

Official solution

Simple__name__ tells Flask package location. Remove → config/templates confuse.
Flask(__name__) can we remove? Don't casually.
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: create_app Flask(__name__).
11

What is WSGI?

Times asked 2

Official solution

SimpleWSGI contract: server Flask ko call kare. Werkzeug routing URL→view.
gunicorn WSGI prod. Flask dev server nahi prod. How Flask decides function: URL map + method.
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: Dev flask run. Prod idea gunicorn wsgi:app.
12
What is a Python decorator?

Times asked 1
Official solution

SimpleDecorator wrap function @app.route @cache @celery.task @auth. Reusable cross-cut.
Different from normal function: HOF wrap, miss easy if manual if. DRY order readable.
Why use decorator: one place policy. @roles_required instantly.
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.
Example
```
def hello_world(fn):
    def wrapper(*a, **k):
        print('Hello World')
        return fn(*a, **k)
    return wrapper

@hello_world
def ping():
    return 'pong'
```
Project example: Stack jwt then role. Explain trio route cached task.
13

How is a decorator different from a normal function?

Times asked 1

Official solution

SimpleDecorator HOF wrap vs helper inside each fn — forget easy. Order matters.
How decorator different normal function.
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: @auth_required vs if not token in every view.
14
Write a simple "Hello World" decorator.

Times asked 1
Official solution

SimpleWrapper print Hello World phir fn. wraps keep name.
Write simple Hello World decorator live.
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
```
from functools import wraps
def hello(fn):
    @wraps(fn)
    def w(*a,**k):
        print('Hello World')
        return fn(*a,**k)
    return w
```
Project example: Notepad.
15

What are dunder methods in Python?

Times asked 1

Official solution

SimpleDunder __name__ special. __init__ __repr__ __tablename__. _private convention not encryption.
Why underscores in Python. Dunder methods.
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 __name__ == '__main__'.
16
What is __repr__()? How is it different from __str__()?

Times asked 1
Official solution

Simple__repr__ debug unambiguous. __str__ readable. Fallback repr if no str. Dunder.
How different repr str.
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
```
def __repr__(self):
    return f'<User {self.email}>'
```
Project example: User __repr__ email.
17
What is serialize() in models?

Times asked 1
Official solution

Simplemodel → dict JSON. Hide password roles maybe. marshal alternative.
What is serialize in models.
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
```
def serialize(self):
    return {'id': self.id, 'email': self.email, 'role': self.roles[0].name}
```
Project example: def serialize return id email.
18
What is exception handling?

Times asked 1
Official solution

Simpletry/except. Catch Exception not BaseException (SystemExit). IntegrityError 404 abort.
Exception handling. Types ValueError TypeError KeyError IntegrityError HTTPException.
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
```
try:
    db.session.commit()
except IntegrityError:
    db.session.rollback()
    return jsonify(msg='duplicate'), 400
```
Project example: commit except rollback 400.
19

What are the different types of exceptions in Python?

Times asked 1

Official solution

SimpleValueError TypeError KeyError IntegrityError HTTPException. Specific catch.
Different types of exceptions.
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: Name 3 you used.
Project example: Name 3 you used.
20

What is the base class of all exceptions?

Times asked 1

Official solution

SimpleBaseException sabka base. Usual catch Exception. Base includes SystemExit KeyboardInterrupt.
Base class of all exceptions. Base Exception class Python.
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 except: bare.
21

What is a dataclass in Python?

Times asked 1

Official solution

Simple@dataclass boilerplate-less. Models ke liye db.Model not dataclass alone.
What is dataclass. Not replacement ORM.
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 unused theory. Maybe DTOs.
22

What are the default ports for Flask and Vue (CLI/Vite)?

Times asked 1

Official solution

SimpleFlask 5000. Vue CLI 8080 Vite 5173 Redis 6379. Change flask run -p 8000 CORS update.
Default ports Flask and Vue. Change port 5000 to 8000.
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: baseURL and CORS origin together.
23
What is SMTP, and what port does it use?

Times asked 1
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.
24
What is the difference between a Primary Key and a Unique Key?

Times asked 3
Official solution

SimplePK row ka aadhaar number. FK doosre ke aadhaar ka reference. Unique alag constraint.
PK chosen candidate key, identity, ORM expect. UNIQUE+NOT NULL+AUTO_INCREMENT almost lekin PK use karo.
Relationship FK+PK. Unique email alag.
Example
```
user_id = db.Column(db.Integer, db.ForeignKey('user.id', ondelete='CASCADE'))
```
Project example: id PKs. FKs user_id. email unique.
Viva tipPK = chosen candidate key. UNIQUE+NOT NULL+AUTO_INCREMENT almost PK jaisa but PK table ka identity + default cluster/index + ORM expect karta hai.
25

Can a Primary Key be replaced with UNIQUE + NOT NULL + AUTO_INCREMENT? Why or why not?

Times asked 2

Official solution

SimpleUNIQUE+NOT NULL+AUTO_INCREMENT almost PK lekin PK identity ORM/FK expect. Use real PK.
Can PK be replaced with that combo. Why not conceptually.
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 have primary_key=True.
26
What is indexing, and why is it used?

Times asked 1
Official solution

SimpleIndex kitab ki suchi — search tez, write thoda mehnga.
B-tree typically. filter wale columns, FKs. Over-index mat.
joinedload N+1 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
```
db.Column(db.String(80), index=True)
db.Index('ix_name_city', User.name, User.city)
```
Project example: email index, venue.name search index.
27
How do you create an index on multiple columns in SQLAlchemy?

Times asked 1
Official solution

SimpleIndex kitab ki suchi — search tez, write thoda mehnga.
B-tree typically. filter wale columns, FKs. Over-index mat.
joinedload N+1 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
```
db.Column(db.String(80), index=True)
db.Index('ix_name_city', User.name, User.city)
```
Project example: email index, venue.name search index.
28

What does db.String(128) mean? How is 128 stored internally?

Times asked 1

Official solution

SimpleString(128) VARCHAR max 128. TEXT unbounded. 128 metadata length.
How 128 stored internally — varchar.
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: password hash column 128/256 enough.
Project example: password hash column 128/256 enough.
29

What does lazy="dynamic" do in SQLAlchemy relationships?

Times asked 1

Official solution

SimpleReturns query not list — further filter. Big collections.
lazy=dynamic.
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: If used, show filter on relationship.
30

What does cascade="all, delete-orphan" do? Can it work the opposite way?

Times asked 1

Official solution

Simplecascade all = save-update merge refresh-expire expunge delete. delete-orphan extra.
cascade='all' options.
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: Show string in models.
31

What are joins in databases?

Times asked 1

Official solution

SimpleJOIN ON fk=pk. inner match dono. left left saari. SQLAlchemy .join(User.roles).
What are joins. Explain SQL joins.
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: bookings join user email list.
32

Can database models be changed after the application is deployed to production? If yes, how?

Times asked 1

Official solution

SimpleHaan migrations Alembic expand-contract. Direct drop dangerous. Backward compatible deploys.
Can models change after production? Yes how.
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: Flask-Migrate / create_all only dev.
33
What is caching, and why is it used?

Times asked 1
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.
34
What is the difference between cache.cached and cache.memoize?

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

What is the difference between Memcached and Redis?

Times asked 2

Official solution

SimpleDono RAM cache. Redis zyada smart: lists, hashes, pub/sub, persistence, Celery broker.
Memcached: simple key-value, yahi. Redis: data structures + expire + optional disk dump.
MAD2 Redis choose — cache aur broker ek hi process. Memcached Celery nahi chalaata.
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: Tumhare config mein CACHE_TYPE RedisCache, CELERY broker redis://. Memcached nahi.
Viva tipMAD2 mein Redis isliye — cache + broker ek hi tool. Memcached Celery nahi chalaata.
36

What exactly is cached when using the @cache.cached decorator?

Times asked 1

Official solution

Simple@cache.cached view ka return value (JSON) Redis mein rakhta hai.
Key typically prefix + URL path (+ query_string agar True). Function body hit pe skip.
POST pe decorator mat lagaana — writes cache nahi karte. Auth-specific data cache karoge to user A ko user B ka data mil sakta hai — key mein user id ya cache hi mat karo.
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: Public/admin list GET pe decorator. User bookings list usually cache mat, ya user-specific key.
37

What are the main components of Celery?

Times asked 2

Official solution

SimpleClient (Flask .delay), Broker (Redis), Worker. Optional Beat + result backend.
Viva line'Flask produce, Redis transport, worker consume.'
include task modules, app context ke andar DB session. Windows pe eventlet/gevent issues — docs se command.
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: create_app ke baad celery.conf.update. tasks import taaki register hon.
Viva tip
Viva line'Flask task produce karta hai, Redis transport, worker consume.'
38

How do you prioritize Celery tasks?

Times asked 2

Official solution

SimpleAlag queues high/low. Worker -Q high,default. Redis limited priority.
Student apps rarely. Concept bolo.
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: If not implemented: would add queue='high' for emails.
39

What happens if you swap the order of @jwt_required and @role_required decorators?

Times asked 1

Official solution

Simplejwt_required pehle identity, phir role. Ultima fail/crash. Test 401/403.
Swap jwt and role_required.
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: Don't swap in demo unless asked then restore.
40

What fallback mechanisms have you implemented to prevent data leakage?

Times asked 1

Official solution

SimpleDefault deny. Catch generic message. No stack to client. Don't leak users exist. Fallback prevent data leakage.
403 vs 404 users. Generic 500 message.
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: error handlers.
41

What is the difference between json, jsonify, json.dumps, and marshal?

Times asked 1

Official solution

Simpledumps str. json parse. jsonify Response. marshal schema. pickle nahi.
json jsonify dumps marshal 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: We jsonify(serialize()).
Project example: We jsonify(serialize()).
42
What is the 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.
43
Explain HTTP status codes: 400, 401, 403, and 404.

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

What is the difference between WebSockets and Webhooks?

Times asked 1

Official solution

SimpleWebSocket ek phone call hai (dono bolte rehte). HTTP postcard hai (ek request-response).
Persistent two-way. Chat, live scores. MAD2 generally REST + kabhi poll.
Webhook ≠ WebSocket. ws:// / wss://.
HTTP postcard (request-response). WebSocket phone call (dono taraf live). SSE radio (server→client stream). Webhook unka server tumhe POST karta hai (payment).
MAD2 mostly REST. Live dashboard = poll + Redis cache kaafi. Agar implement nahi kiya to design bolo, jhoot mat.
Project example: Humne REST use kiya. Live dashboard ke liye poll/cache. WebSocket extra hota.
Viva tipMAD2 mein mostly REST + polling. Webhook ≠ WebSocket.
45

How do WebSockets work?

Times asked 1

Official solution

SimpleWebSocket ek phone call hai (dono bolte rehte). HTTP postcard hai (ek request-response).
Persistent two-way. Chat, live scores. MAD2 generally REST + kabhi poll.
Webhook ≠ WebSocket. ws:// / wss://.
HTTP postcard (request-response). WebSocket phone call (dono taraf live). SSE radio (server→client stream). Webhook unka server tumhe POST karta hai (payment).
MAD2 mostly REST. Live dashboard = poll + Redis cache kaafi. Agar implement nahi kiya to design bolo, jhoot mat.
Project example: Humne REST use kiya. Live dashboard ke liye poll/cache. WebSocket extra hota.
Viva tipMAD2 mein mostly REST + polling. Webhook ≠ WebSocket.
46

What is the difference between Sessions and Cookies?

Times asked 1

Official solution

SimpleCookie transport. Session server data us cookie id se. Theme cookie bina server session.
Auth session cookie httpOnly. JWT often not a cookie in MAD2.
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: Agar JWT LS: cookies empty explain. Agar Flask-Login: session cookie dikhao.
47

What is the difference between synchronous and asynchronous programming?

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.
48
What are Vue routes, and why do we use them?

Times asked 1
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.
49
What are Vue slots?

Times asked 1
Official solution

SimpleSlots = dabbe ke andar parent apna HTML daal de. Props data, slots markup.
Default slot, named slots. App.vue router-view layout jaisa outlet.
Agar nahi use kiya: 'layout router-view se kiya' valid.
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
```
<div class="card"><slot>Default</slot></div>
<Card><p>Custom body</p></Card>
```
Project example: Card.vue <slot>Default</slot>. Parent custom body.
50
What are Vue props?

Times asked 1
Official solution

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

Times asked 1
Official solution

SimpleSlots = dabbe ke andar parent apna HTML daal de. Props data, slots markup.
Default slot, named slots. App.vue router-view layout jaisa outlet.
Agar nahi use kiya: 'layout router-view se kiya' valid.
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
```
<div class="card"><slot>Default</slot></div>
<Card><p>Custom body</p></Card>
```
Project example: Card.vue <slot>Default</slot>. Parent custom body.
52
What are Vue lifecycle hooks?

Times asked 11
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.
53
What are Vue directives?

Times asked 6
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.
54

What is pagination, and why is it used?

Times asked 1

Official solution

SimpleBadi list pages. Fast kam payload. page per_page. Offset or keyset.
Why used. Scale.
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 not: would add .paginate. If yes show.
Project example: If not: would add .paginate. If yes show.
55

How would you scale your application to support millions of users?

Times asked 1

Official solution

SimpleAll 10k + shards replicas queue partition multi region hard.
Scale millions users. Load millions requests without scale: down.
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: Design answer not implemented.
56

What happens if the application load increases to millions of requests?

Times asked 1

Official solution

SimpleWithout scale down. With LB gunicorn Redis cluster PG replica CDN celery scale-out.
What happens load millions.
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: Bottleneck SQLite+dev server first.
57
Optimize a piece of code containing multiple if conditions without using if-else.

Times asked 1
Official solution

Simpledict dispatch early return mapping status→handler. Optimize multiple if without if-else.
Table-driven.
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
```
ops = {'add': a+b, 'mul': a*b}
return ops.get(op)
```
Project example: ops = {'add': a+b}.
58

Implement a search by username feature.

Times asked 1

Official solution

Simplefilter User.username.ilike. Admin only. Implement search by username.
q param.
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 users.
Project example: admin users.
59
Implement a dropdown menu in a form.

Times asked 1
Official solution

Simpleselect v-model option v-for. Implement dropdown menu form. Age dropdown >30 <30.
Both.
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
```
<select v-model="ageBand"><option>>30</option><option><30</option></select>
```
Project example: dept select.
60

Add a timestamp column to a table and display it in the dashboard.

Times asked 1

Official solution

SimpleDateTime default now Vue format. Add timestamp column display dashboard.
created_at.
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 + td.
Project example: model + serialize + td.
61

Change Celery scheduling so that the daily reminder always executes before the monthly report.

Times asked 2

Official solution

SimpleDaily ko pehle time do, monthly ko baad mein — Beat sequential guarantee nahi karta.
Same minute pe dono fire ho sakte hain parallel workers se. Order chahiye to times alag rakho (17:00 vs 17:30) ya ek task doosre ko chain kare.
Examiner logic: reminder pehle, badi report baad.
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: daily crontab(hour=17, minute=0), monthly hour=17 minute=30.
62

Change Celery scheduling so that the daily reminder always executes before the monthly report.

Times asked 2

Official solution

SimpleDaily ko pehle time do, monthly ko baad mein — Beat sequential guarantee nahi karta.
Same minute pe dono fire ho sakte hain parallel workers se. Order chahiye to times alag rakho (17:00 vs 17:30) ya ek task doosre ko chain kare.
Examiner logic: reminder pehle, badi report baad.
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: daily crontab(hour=17, minute=0), monthly hour=17 minute=30.
63

Make changes to the Admin Dashboard functionality.

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.

See reviews Level3_41 MAD2 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1
What are Vue lifecycle hooks, and which ones did you use?

Times asked 1
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.
2
Explain how watch works in Vue and where you used it.

Times asked 1
Official solution

Simplewatch = 'jab yeh badle tab yeh karo'. Computed nahi, kyunki return value nahi, kaam hai.
deep: true objects. immediate: true first run. Composition watch().
Search, $route.params.id load user.
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
```
watch(() => route.params.id, (id) => loadUser(id))
```
Project example: watch query debounce 300ms search API. Nahi use to 'computed kaafi'.
3
If you want to change the database from SQLite to another database (e.g., MySQL/PostgreSQL), what changes would you make in the code?

Times asked 1
Official solution

SimpleURI badlo, types BOOLEAN, migrations, dump/load. Models almost same.
SQLite to Postgres. Production gunicorn+hosted Redis.
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
```
SQLALCHEMY_DATABASE_URI = 'postgresql://user:pass@localhost/mad2'
```
Project example: SQLALCHEMY_DATABASE_URI postgresql://...
Viva tipProduction: Postgres + gunicorn + Redis hosted. SQLite file locking 10k users pe nahi.
4

What is the need for a virtual environment?

Times asked 1

Official solution

Simplevenv isolated Python packages. system Python safe. requirements.txt freeze.
Need virtual environment. Node not inside it.
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: .venv pip install -r.

See reviews proctor785 MAD1 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1

Run the application and give a complete project demonstration.

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

Explain the project folder structure.

Times asked 2

Official solution

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

How many controllers/routes do you have?

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

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

Explain the authentication routes (login and registration).

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.
6
Explain the Jinja2 code used in your templates.

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 %}.
7
If used, explain template inheritance.

Times asked 1
Official solution

Simpleextends poora layout inherit karta hai, include chhota piece insert karta hai.
extends: child page base.html ka structure use karti hai, blocks override karti hai. Ek hi parent.
include: navbar.html / footer.html jahan chaho insert. Kai baar use ho sakta hai.
base.html:
```
{% block content %}{% endblock %}

home.html:
{% extends 'base.html' %}
{% block content %}<h1>Home</h1>{% endblock %}

{% include 'navbar.html' %}  → navbar har page pe
```
Fayda: header/footer ek jagah, change once — saari pages update. MAD1 mein almost har project use karta hai.
8
What does cascade="all, delete" mean in SQLAlchemy?

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

Difference between redirect() and render_template().

Times asked 2

Official solution

Simplerender_template HTML page bana ke turant dikhata hai, redirect user ko doosre URL pe bhej deta hai.
render_template('home.html', user=user) → server template fill karke 200 response deta hai. URL same rehta hai.
redirect(url_for('dashboard')) → 302 response, browser naya GET karta hai. URL change ho jaata hai.
Examplelogin POST successful hone ke baad render_template mat use karo, warna refresh pe form dubara submit ho jaayega.
Sahi tarika: redirect(url_for('dashboard')) — yeh Post-Redirect-Get pattern hai.
render_template tab: page dikhana hai with data.
redirect tab: kaam ho gaya, ab doosre page pe le jaana hai (login, delete, update ke baad).
10
What are the advantages and disadvantages of Flask-SQLAlchemy ORM?

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

Difference between Horizontal Scaling and Vertical Scaling.

Times asked 3

Official solution

SimpleVertical = same machine ko powerful banao. Horizontal = aur machines add karo.
Vertical (scale up): RAM/CPU badhao. Simple, lekin ek limit hai, downtime ho sakta hai, single point of failure.
Horizontal (scale out): 5 servers + load balancer. Sasta long-term, fault tolerant, lekin session/DB sharing sochna padta hai.
Example10k users aaye to Flask app ke 4 copies chalao nginx peeche, DB alag machine pe.
Thousands of requests on one machine: caching (Redis), DB indexes, gunicorn workers, phir horizontal.
12
What is Time Complexity?

Times asked 1
Official solution

SimpleTime complexity input size ke saath time kaise badhta hai.
O(1): dict lookup. O(n): list mein loop. O(n^2): nested loops.
Example
```
User.query.all() phir Python mein filter = O(n). DB pe indexed WHERE tez.
```
Search suggestions: prefix index / ILIKE, nai to har keypress pe poori table mat ghumao.
13
Write a Flask route for admin_delete_trek_staff.

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())

See reviews Level2_141 MAD1 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1

Show ID card.

Times asked 6

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

Verify GitHub collaborator access.

Times asked 3

Official solution

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

Choose either Portal Download or Checksum Verification.

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.
4
Run the application and demonstrate the core functionalities: User Registration & Login Trek CRUD (Create, Update, Delete) Search functionality Staff assignment Staff approval Admin blacklist functionality

Times asked 1
Official solution

SimpleCRUD = Create, Read, Update, Delete — kisi bhi resource ke 4 basic operations.
Create: POST, db.session.add(new_user); commit() — register, add trek.
Read: GET, User.query.all() — dashboard list.
Update: POST/PUT, user.name = 'Ram'; commit() — edit profile.
DeletePOST/DELETE, db.session.delete(obj); commit().
REST mapping: POST create, GET read, PUT/PATCH update, DELETE delete.
Admin panel mein yeh 4 dikhana viva demo ka common task hai.
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.
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.
5

Open routes.py and explain the registration route using your project code.

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.
6
What is ORM?

Times asked 49
Official solution

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

Explain MVC architecture.

Times asked 9

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.
8
Difference between Authentication and Authorization.

Times asked 20
Official solution

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

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

Write a Flask registration route in Notepad/VS Code.

Times asked 1

Official solution

@app.route('/register', methods=['GET','POST'])
def register():
    if request.method == 'POST':
        if User.query.filter_by(email=request.form['email']).first():
            flash('Exists'); return redirect(url_for('register'))
        u = User(email=request.form['email'],
                 password=generate_password_hash(request.form['password']))
        db.session.add(u); db.session.commit()
        return redirect(url_for('login'))
    return render_template('register.html')

See reviews Proctor 784 MAD1 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1

Download the submission from the portal and perform checksum verification.

Times asked 2

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

Complete project demonstration.

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

Explain every feature/functionality of the website.

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

Demonstrate different user roles (Staff → Admin approval → User booking flow).

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.
5
Did you use any APIs in your project?

Times asked 1
Official solution

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

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

Explain your project using the 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.
8
Did you use ORM? If not, how does your project still follow MVC architecture?

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

How did you protect your project from SQL Injection attacks?

Times asked 1

Official solution

SimpleSQL Injection user input ko SQL bana ke DB hack. ORM/parameterized queries se bachao.
Galat: f"SELECT * FROM user WHERE email='{email}'" # email = ' OR 1=1 --
Sahi: User.query.filter_by(email=email) # bound parameters
Raw: db.session.execute(text('SELECT * FROM user WHERE id=:id'), {'id': i})
Extra: least privilege DB user, input validate, error messages generic.
10

Which HTTP methods did you use in your project?

Times asked 1

Official solution

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

Which other HTTP methods do you know?

Times asked 1

Official solution

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

What is a Client and a Server?

Times asked 1

Official solution

SimpleClient maangta hai, Server jawab deta hai.
Client: browser (Chrome). HTML/CSS/JS run, request bhejta hai.
Server: Flask app. Route handle, DB query, response.
Request-response: GET /dashboard → Flask HTML return → browser render.
MAD1 project client-server hai kyunki browser aur Flask alag processes hain, HTTP se baat karte hain. Distributed tab kehlata jab kai servers/services alag machines pe hon.
13
What is the purpose of @app.route?

Times asked 1
Official solution

Simple@app.route URL ko Python function se jodta hai. @ wala cheez decorator hai.
```
@app.route('/hello/<name>', methods=['GET'])
def hello(name):
    return f'Hello {name}'
```
Decorator function ko wrap karke extra behaviour deta hai (route register, login_required).
Endpoint generally function name. Path /hello/Ram.
<int:id> type converter — sirf integer. Bina converter string. ID chahiye to int safer.
methods=['POST'] only POST. Default GET.
functools.wraps custom decorator mein original function name/docs preserve karta hai.
14
Difference between Authentication and Authorization.

Times asked 20
Official solution

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

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

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'))
```
16
What is the use of {{ }}, {% %}, and {# #} in Jinja?

Times asked 1
Official solution

Simple{{ }} value print, {% %} logic (if/for), {# #} comment.
```
{{ user.name }} → HTML mein naam dikhega
{% if user.role == 'admin' %} ... {% endif %} → condition
{% for t in treks %} {{ t.name }} {% endfor %} → loop
{# yeh comment browser mein nahi jaata #}
```
Object access: {{ reservation.spot.lot.name }} — relationship follow karke nested data.
List pass kiya to loop, single object to .field.
17
Display the logged-in staff member's name on the Staff Dashboard.

Times asked 2
Official solution

Simplecurrent user object template ko do, Jinja se naam print.
```
@app.route('/staff/dashboard')
def staff_dash():
    staff = Staff.query.get(session['user_id'])
    return render_template('staff_dash.html', staff=staff)

<h2>Welcome, {{ staff.name }}</h2>
```
Flask-Login: {{ current_user.name }} — context_processor se har template mein user inject ho sakta hai.
Roll/dept extra fields same tarah pass karo.
18
Display the logged-in staff member's name on the Staff Dashboard.

Times asked 2
Official solution

Simplecurrent user object template ko do, Jinja se naam print.
```
@app.route('/staff/dashboard')
def staff_dash():
    staff = Staff.query.get(session['user_id'])
    return render_template('staff_dash.html', staff=staff)

<h2>Welcome, {{ staff.name }}</h2>
```
Flask-Login: {{ current_user.name }} — context_processor se har template mein user inject ho sakta hai.
Roll/dept extra fields same tarah pass karo.
19
Display start date and end date on trek cards.

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
Add a new Age column to the User table.

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

Add the Age field to the registration form.

Times asked 2

Official solution

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

Update the registration route to save the age in the database.

Times asked 2

Official solution

Simple 4-step: Model → DB → Form → Route → Template. Yeh sabse common live-coding hai.
1) models.py: age = db.Column(db.Integer, nullable=True)
2) DB: SQLite viewer se column, ya DB delete karke create_all, ya ALTER TABLE user ADD COLUMN age INTEGER; production mein Flask-Migrate.
3) register.html: <input type='number' name='age' min='18' required>
4) route: user.age = request.form.get('age', type=int); commit
5) dashboard: {{ user.age }} admin table mein <td>{{ u.age }}</td>
Print terminal: print('AGE', request.form.get('age'))
Phone/city same pattern, String(20). Openings on Drive: integer column + form + create_drive route.
23
Add validation so only users younger than 50 years can register.

Times asked 1
Official solution

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

Be prepared for questions involving adding a new database field and updating the frontend, backend, and business logic accordingly.

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.

See reviews Level2 Viva Proctor 785 MAD1 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1

Show ID card.

Times asked 6

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 and run the project.

Times asked 2

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

Demonstrate all project features.

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

Explain the project folder structure.

Times asked 2

Official solution

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

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.
6
Explain any randomly selected line of code from your project.

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.
7
What is ORM? What are its advantages and disadvantages?

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

Times asked 9

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.
9
Difference between backref and back_populates.

Times asked 10
Official solution

Simpledono SQLAlchemy relationships ko do taraf se connect karte hain, farq sirf likhne ke style ka hai.
backref: relationship ek side pe likhte ho, doosri side SQLAlchemy khud bana deta hai. Short hai, lekin dono models dekh ke relationship clearly nahi dikhti.
back_populates: dono models pe relationship explicitly likhte ho. Code padhne wale ko turant samajh aa jaata hai ki User.posts aur Post.author linked hain.
Example
```
class User(db.Model):
    posts = db.relationship('Post', backref='author')
```
Yahan Post.author automatically mil jaata hai.
Explicit version:
```
class User(db.Model):
    posts = db.relationship('Post', back_populates='author')
class Post(db.Model):
    author = db.relationship('User', back_populates='posts')
```
Viva tipexaminer ko bolo — MAD1 project mein back_populates zyada clear hai, isliye preferred.
10

CSS priority (Inline, Internal, External).

Times asked 1

Official solution

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

What are database constraints?

Times asked 1

Official solution

SimpleConstraints rules hain jo galat data rok te hain. Referential integrity FK valid parent ko point kare.
PK, FK, UNIQUE, NOT NULL, CHECK (age >= 18). ORM Column flags yahi map karte hain.
SQL = language tables se baat. Database organized data store.
SQL View: saved query, table jaisi dikhti hai, data copy nahi.
Cluster: kai DB servers together (HA/scale) — MAD1 SQLite single file.
Entity mapping: class User → table user, attributes → columns.
12

Difference between structured and unstructured data.

Times asked 1

Official solution

SimpleJSON = JavaScript Object Notation — data exchange ka text format.
{"name": "Ram", "age": 20}
APIs, localStorage, Chart.js data. Python dict ↔ JSON.
Structured data: tables, fixed schema (SQL). Unstructured: images, logs, free text. JSON semi-structured.
SQL structured relational. Mongo unstructured/document.
13

Basic JavaScript concepts (even if not used in the project).

Times asked 1

Official solution

SimpleJavaScript browser pe chalta hai — click, validation, Chart.js, Bootstrap modal.
Frameworks: Vue, React, Angular. MAD1 mein vanilla JS / Bootstrap JS kaafi.
Modal: popup overlay. Bootstrap: data-bs-toggle='modal' data-bs-target='#id'.
Flash hide: setTimeout se alert remove. Form submit confirm: onsubmit='return confirm(...)'.
Agar project mein JS kam hai to sach bolo, theory example do.
14

Difference between horizontal and vertical scaling.

Times asked 1

Official solution

SimpleVertical = same machine ko powerful banao. Horizontal = aur machines add karo.
Vertical (scale up): RAM/CPU badhao. Simple, lekin ek limit hai, downtime ho sakta hai, single point of failure.
Horizontal (scale out): 5 servers + load balancer. Sasta long-term, fault tolerant, lekin session/DB sharing sochna padta hai.
Example10k users aaye to Flask app ke 4 copies chalao nginx peeche, DB alag machine pe.
Thousands of requests on one machine: caching (Redis), DB indexes, gunicorn workers, phir horizontal.
15
Difference between Primary Key and 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.
16
What is lazy loading?

Times asked 3
Official solution

Simplelazy loading related objects tab load karta hai jab attribute access karte ho, pehle nahi.
```
user = User.query.get(1)  # posts query nahi
```
user.posts # ab query
lazy=True / 'select' default. lazy='joined' eager join. lazy='dynamic' query object.
uselist=False One-to-One (single object, list nahi). Hataoge to list mil sakti hai.
Frontend lazy loading images alag cheez hai (viewport mein aaye tab load).
17

What are REST APIs?

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

What are HTTP methods?

Times asked 5

Official solution

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

What is SQL Injection? How can you prevent it?

Times asked 1

Official solution

SimpleSQL Injection user input ko SQL bana ke DB hack. ORM/parameterized queries se bachao.
Galat: f"SELECT * FROM user WHERE email='{email}'" # email = ' OR 1=1 --
Sahi: User.query.filter_by(email=email) # bound parameters
Raw: db.session.execute(text('SELECT * FROM user WHERE id=:id'), {'id': i})
Extra: least privilege DB user, input validate, error messages generic.
20
What is render_template()?

Times asked 3
Official solution

Simplerender_template HTML file ko Jinja se process karke browser ko bhejta hai. Backend data ko frontend se jodta hai.
```
return render_template('dashboard.html', user=user, treks=treks)
```
File templates/dashboard.html honi chahiye.
Keyword arguments template mein variables ban jaate hain: {{ user.name }}.
Route kuch return na kare to Flask error. Boolean return typical HTML view ke liye nahi — string/Response chahiye.
21
Add a new Delete Trek button on the Trekkers page that deletes the selected trek when clicked.

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_11 MAD1 Level 1

Aug 1, 2026

Download all Download all

Copy set link

1

Complete project demonstration (User, Staff, and Admin flows).

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.
2
Add a new trek.

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

Book a trek.

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.
4
Mark a trek as completed from the Staff dashboard.

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

Explain a route from your project in detail (its working and logic).

Times asked 1

Official solution

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

Times asked 49
Official solution

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

What are HTTP methods?

Times asked 5

Official solution

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

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.
9
Difference between Authentication and Authorization.

Times asked 20
Official solution

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

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

Difference between Inline, Internal, and External CSS.

Times asked 3

Official solution

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

Times asked 3
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.
12
Set a default value for the trek status field.

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'))
```
13
Change the login button color using CSS.

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.
14
Write a Jinja for loop to display trek location and name.

Times asked 1
Official solution

Simple Jinja loop + if — examiner notepad mein likhwaata hai:
```
{% for t in treks %}
  <p>{{ t.name }} — {{ t.location }}</p>
{% else %}
  <p>No treks</p>
{% endfor %}

{% if user.role == 'admin' %}
  <button>Delete</button>
{% endif %}
```
List filter: {% if x > 10 %}{{ x }}{% endif %}
Length: {{ items|length }} Upper: {{ name|upper }}
Table: loop ke andar <tr><td>
15

Write a Flask route to find blacklisted staff.

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.
16
Write a Jinja for loop (in Notepad/VS Code).

Times asked 1
Official solution

Simple Jinja loop + if — examiner notepad mein likhwaata hai:
```
{% for t in treks %}
  <p>{{ t.name }} — {{ t.location }}</p>
{% else %}
  <p>No treks</p>
{% endfor %}

{% if user.role == 'admin' %}
  <button>Delete</button>
{% endif %}
```
List filter: {% if x > 10 %}{{ x }}{% endif %}
Length: {{ items|length }} Upper: {{ name|upper }}
Table: loop ke andar <tr><td>

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