Search – Lazy IITians Viva Prep

See reviews Level1_130 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Show your Student ID.

Times asked 2

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub repository and collaborator.

Times asked 16
Official solution

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

Share the report/documentation link.

Times asked 1

Official solution

SimpleOpen docs, AI % same, features map demo.
Share report link.
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: Google doc headings.
Project example: Google doc headings.
4

Explain your entire codebase (frontend and backend).

Times asked 1

Official solution

SimpleTree + 6 file roles. Not every line.
Same walk_code. Stay structured.
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: Start models end Vue.
Project example: Start models end Vue.
5

Explain your configuration files.

Times asked 1

Official solution

Simpleconfig.py / .env SECRET URI Redis MAIL CACHE celery. No secrets git. Explain configuration files.
create_app load.
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: .env.example.
Project example: .env.example.
6
Explain the Login API.

Times asked 1
Official solution

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

# baad ki APIs
# Authorization: Bearer <token>
if current_user.role != 'admin':
    abort(403)
```
Project example: Login.vue POST /api/login → token LS → interceptor. Student token se admin route = 403. Empty form = validation, galat password = 401.
Viva tipNetwork tab mein password body dikhega localhost pe — prod HTTPS. Response mein hash/password echo mat karo.
7
Explain how data is stored in your application.

Times asked 1
Official solution

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

Explain the Admin creation code.

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

Show where the API is called and how data is rendered on the frontend.

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

Explain how the Admin Dashboard receives and displays data.

Times asked 1

Official solution

SimpleAdmin Vue → GET /api/admin/summary roles_required → counts + chart. How dashboard receives data.
Cached maybe.
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: AdminHome.vue mounted.
Project example: AdminHome.vue mounted.
11

Explain the Celery files.

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

What are asynchronous (background) jobs?

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

Where have you implemented JWT in the frontend?

Times asked 1

Official solution

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

What is the purpose of the JWT Secret Key?

Times asked 1

Official solution

SimpleHMAC key. Private. Purpose: signature, not encrypt payload.
algo none attack libraries reject.
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_SECRET_KEY config.
15

Difference between JWT Secret Key and Flask Secret Key.

Times asked 1

Official solution

SimpleJWT_SECRET sign/verify. Flask SECRET_KEY sessions/CSRF. Alag rakhna better.
Leak = forge tokens. env var. Rotate.
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: .env not git. config.py os.environ.
16
Authentication vs Authorization.

Times asked 10
Official solution

SimpleAuthentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password check karke prove karte ho ki tum genuine user ho. Success pe session/token milta hai.
Authorization: uske baad role check. Admin hi parking lot / venue / drive delete kar sakta hai, normal user nahi.
MAD2 mein yeh alag layers hain: login API = authentication (JWT milta hai). @roles_required('admin') ya Vue v-if="isAdmin" = authorization.
Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+). Authentication identity hai, authorization permission, validation input quality.
Example
```
# Authentication
if user and check_password_hash(user.password, form_password):
    token = create_access_token(identity=user.id)

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

Times asked 1
Official solution

Simplesetup() Composition entry — props, context, return state.
script setup syntactic sugar.
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
```
export default {
  setup() {
    const n = ref(0)
    return { n }
  }
}
```
Project example: setup() { const n = ref(0); return { n } }
18

What is index.js?

Times asked 1

Official solution

Simpleindex.js/main.js frontend entry createApp router store mount.
package.json not entry of runtime, this is.
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: src/main.js.
Project example: src/main.js.
19

What is router.js?

Times asked 1

Official solution

Simpleroutes + createRouter history guards. Open explain 2 routes.
What is router.js / routes.js.
SPA = ek HTML, Vue Router se views, full reload nahi. MPA = MAD1 Jinja har URL naya HTML.
Vue Router: routes array, router-view, router-link, meta.auth + beforeEach guard. Dynamic /venues/:id → $route.params.id.
Vite/CLI SFC + npm build dist/. CDN script tag, no SFC. Jo tumne use kiya wahi justify. Flask send_from_directory('dist') production pattern.
Project example: meta.auth on dashboard.
Project example: meta.auth on dashboard.
20

Create a router object and write routing code.

Times asked 1

Official solution

SimplecreateRouter({ history, routes }). app.use(router).
Create router object write routing code.
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: main.js use(router).
Project example: main.js use(router).
21

Why did you use createWebHistory()?

Times asked 1

Official solution

SimplePretty URLs. Server fallback needed. Hash if static constraints.
Why createWebHistory.
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 hash, why hash: no Flask rewrite.
Project example: If hash, why hash: no Flask rewrite.
22

Why are arrow functions used in route components?

Times asked 1

Official solution

SimpleShort + this parent. Route lazy import.
Not mandatory everywhere.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Project example: routes.js () => import('./Foo.vue')
Project example: routes.js () => import('./Foo.vue')
23
Difference between router-view and router-link.

Times asked 1
Official solution

Simplerouter-view current page ka hole. router-link SPA <a> bina reload.
App.vue Navbar + router-view = 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.
Example
```
<router-link to="/login">Login</router-link>
<router-view></router-view>
```
Project example: App.vue structure.
24
Difference between $route and $router.

Times asked 1
Official solution

Simple$route current (path params query). $router methods push go replace.
Login redirect this.$router.push. Read id this.$route.params.id.
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.
Example
```
this.$router.push('/dashboard')
this.$route.params.id
```
Project example: login success push dashboard. Detail page params.
25

What is State Management?

Times asked 2

Official solution

SimpleShared state across components — Vuex/Pinia. Props hell avoid.
How share globally.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: token user cart.
Project example: token user cart.
26

Difference between Mutation and Action.

Times asked 1

Official solution

SimpleMutations sync diary entry. Actions async kaam phir diary.
Direct state mutate action se Vuex 4 discouraged. Devtools time-travel mutations.
Purpose of Actions: API, phir commit. Purpose of Mutations: state change one place.
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: action fetchVenues → commit setVenues. Mutation sirf array replace.
27
Difference between Computed Properties and Watchers.

Times asked 2
Official solution

SimpleComputed naya value return. Watcher side effect (API, log) jab value change.
Search debounce, route param change → watch. Display filter → computed.
Confusion examiner favourite.
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: {
  query(newQ) { this.fetchSearch(newQ) }
}
```
Project example: q watch → fetchSearch. remainingSeats computed from capacity-booked.
28

Difference between Methods and Computed.

Times asked 1

Official solution

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

Times asked 1
Official solution

Simple:class object/array/string dynamic CSS.
Purpose dynamic class. Error red.
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
```
<div :class="{ 'text-danger': error, 'fw-bold': important }">Msg</div>
```
Project example: :class="{ 'text-danger': error }"
31
What is async / await?

Times asked 2
Official solution

Simpleasync/await Promise ko seedha-seedha padhne jaisa banata hai, magic nahi.
await sirf async ke andar. try/catch reject. Parallel: Promise.all.
Celery se confuse mat hona — yeh JS event loop, woh Python worker.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Example
```
async function load() {
  const r = await fetch('/api/venues')
  return r.json()
}
```
Project example: async mounted() { this.rows = await api() }
32

Why did you use Axios?

Times asked 1

Official solution

SimpleDX interceptors token, errors. Optional.
Consistency ek client.
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: axios instance baseURL.
Project example: axios instance baseURL.
33

What is uselist?

Times asked 2

Official solution

SimpleFalse → scalar 1-1. True default list 1-M.
What is uselist. Any 1-1 in models? Honest.
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: Profile 1-1 or none.
34
Difference between backref and back_populates.

Times asked 10
Official solution

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

Write a query to: Fetch all treks belonging to a manager. Fetch all jobs created by a company (e.g., Google). Fetch all approved drives/jobs.

Times asked 1

Official solution

Simplefilter manager_id / company name / approved. Same Query API. Write query fetch treks/jobs/drives.
Examiner project-specific names — same pattern.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Drive.query.filter_by(approved=True)
36

What is SSE (Server-Sent Events)?

Times asked 1

Official solution

SimpleSSE ek tarah ka radio: server bolta rehta, client sunta. Client us pipe pe command nahi bhejta.
text/event-stream. EventSource browser. Notifications ke liye WebSocket se simple.
MAD2 optional. Celery complete hone pe poll bhi kaafi.
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: Export status poll GET task_id. SSE nahi kiya to bolo alternative.
37

Write template and route code to select a course.

Times asked 1

Official solution

Simpleselect v-model course POST. Jinja: select name=course. MAD2 Vue. Write template and route select a course.
Notepad maybe Jinja still.
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: Vue select or Jinja if asked MAD1 leftover.
38

Add an Age dropdown (>30 / <30) to a form.

Times asked 1

Official solution

Simpleselect >30 <30 v-model filter. Add Age dropdown form.
Filter list computed or 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: form + filter.
Project example: form + filter.
39
Read and print a JSON object (e.g., {"app": ">30"}) in the backend.

Times asked 1
Official solution

Simple
```
data=request.get_json(); print(data); return jsonify(data). Read print JSON object backend.
```
{"app": ">30"}.
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: POST Postman.
Project example: POST Postman.
40

Create two input fields (firstname, lastname) and concatenate them on button click.

Times asked 1

Official solution

Simpledata first last full. method concat this.full=first+' '+last. Two inputs concatenate click.
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: tiny form.
Project example: tiny form.
41

Create a router and connect a new page/component.

Times asked 1

Official solution

SimplecreateRouter({ history, routes }). app.use(router).
Create router object write routing code.
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: main.js use(router).
Project example: main.js use(router).
42

How much AI did you use?

Times asked 1

Official solution

SimpleSach % + kahan + kaise verify + kya seekha. Report se contradict mat.
Boilerplate vs business logic. Examiner process poochta. 'Sab ChatGPT' red flag.
Verify: docs, run, edge case. Seekha: CORS, JWT exp, beat vs worker.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Jo number form/PDF mein hai wahi. Example file jo AI se start kiya, khud debug kiya.
Viva tipExaminer 'kya seekha / kaise check kiya' pe marks. 'Sab ChatGPT' red flag. Jo khud debug kiya woh story ready rakho.
43

Which parts of the project did you implement yourself?

Times asked 1

Official solution

SimpleModels + booking logic khud. Boilerplate AI. Specific files.
Parts you implemented yourself.
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 2 files pride.
Project example: Name 2 files pride.

See reviews Level1_95 MAD2 Level 1

Aug 3, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub repository and collaborator.

Times asked 16
Official solution

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

Download the project from the portal and run it.

Times asked 6

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
4

Demonstrate the application.

Times asked 4

Official solution

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

Times asked 3
Official solution

SimpleCRUD 4 operations live: add list edit delete, list refresh.
REST mapping. Related bookings after delete ready answer.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
POST /api/venues → add
GET /api/venues → list
PUT /api/venues/3 → edit
DELETE /api/venues/3
```
Project example: Admin venues. Postman + UI dono.
Viva tipUpdate ke baad list refresh hoke naya data dikhe. Delete ke baad related bookings kya hoti hain, ready raho.
6
Demonstrate the search functionality.

Times asked 4
Official solution

SimpleSearch demo cases.
See earlier essay.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
q = request.args.get('q', '').strip()
items = Venue.query.filter(Venue.name.ilike(f'%{q}%')).all()
return jsonify([v.serialize() for v in items])
```
Project example: UI + API.
Viva tipEmpty search, no-match, case-insensitive (ilike) teen cases dikhao.
7

Explain the company registration logic.

Times asked 1

Official solution

SimplePOST /api/company unique name pending admin approve. Explain company registration. Prevent based on backend condition.
Domain whitelist example.
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: status pending.
8
Show where you prevented duplicate bookings/applications.

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.
9
Show the backend job implementation (CSV export, reminders, reports, etc.).

Times asked 1
Official solution

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

Times asked 2
Official solution

SimpleSMTP + template + Celery. MailHog inbox dikhao, Gmail nahi chahiye.
Dynamic HTML user name. Live: schedule now.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
msg = Message(subject='Daily reminder', recipients=[user.email])
msg.html = render_template('reminder.html', user=user)
mail.send(msg)
```
Project example: reminder.html Jinja. tasks send_mail.
Viva tipLive demo ke liye Celery beat crontab current time pe set karo, worker + beat dono chalu rakho.
11
Explain Role-Based Access Control (RBAC).

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

Explain Token-Based Authentication.

Times asked 1

Official solution

SimpleHar request pe token dikhao. Server session yaad nahi rakhta (mostly).
Login issue, store, send, verify, exp. Logout = client delete (+ server blacklist optional).
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: Bearer header. 401 pe redirect login.
13

Which library did you use for token-based authentication?

Times asked 1

Official solution

SimpleNamed from requirements. import line dikhao.
Which framework/library token.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: Don't say both if one.
14
Vue CLI vs Vue CDN. Which one did you use and why?

Times asked 3
Official solution

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

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

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

Times asked 5
Official solution

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

Which lifecycle hooks have you used?

Times asked 1

Official solution

Simplemounted/onMounted data load. beforeUnmount cleanup. created if used. List 2 + why.
Which lifecycle hooks did you use.
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: Open files grep mounted.
17
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.
18

Where have you used Redis?

Times asked 2

Official solution

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

Is caching implemented?

Times asked 2

Official solution

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

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.
21
What is Cascading (ON DELETE CASCADE)?

Times asked 1
Official solution

SimpleCASCADE = parent gaya to bacche bhi. Restrict = pehle bacche sambhalo.
ON DELETE CASCADE SQL. SQLAlchemy cascade='all, delete-orphan' collection se orphans.
Opposite auto nahi — child delete se parent nahi marata.
Venue delete: bookings restrict (safer viva) ya cascade+cancel policy. Examiner design poochta hai.
ON UPDATE CASCADE PK change — rare. SET NULL, RESTRICT bhi options.
Example
```
shows = db.relationship('Show', cascade='all, delete-orphan', back_populates='venue')
```
Project example: Show belongs Venue delete-orphan. Booking venue pe restrict — 'reassign first'.
Viva tipVenue delete pe bookings: restrict (mat delete) ya cascade+refund policy. Examiner design poochta hai. Cascade UPDATE bhi hota hai (PK change) — rare.
22
List and explain HTTP methods (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.
23
Write a Hello World API.

Times asked 1
Official solution

Simplejsonify(message='Hello World'). Create API Hello World. Write Hello World API.
Simple.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
@app.route('/api/hello')
def hello():
    return jsonify(message='Hello World')
```
Project example: GET /api/hello.
24
Write an API that accepts two numbers and returns: Their sum A JSON response

Times asked 1
Official solution

SimplePOST JSON a,b return {sum: a+b}. Write API two numbers sum JSON. Create API sum two numbers.
Validate ints.
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
```
d = request.get_json()
return jsonify(result=d['a'] + d['b'])
```
Project example: Postman.
25

Write an API that returns the sum of two numbers received from the frontend.

Times asked 1

Official solution

SimpleSame API. Vue two inputs call API or local add. Write API sum from frontend.
Either OK confirm.
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: Add.vue v-model.number.
Project example: Add.vue v-model.number.
26
Change the Celery schedule (date/time) for email reports.

Times asked 1
Official solution

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

Show the code that prevents duplicate bookings or duplicate drive applications.

Times asked 1

Official solution

Simplequery.exists / unique. Demo second click. Show code prevents duplicate bookings/applications.
Where prevented.
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: book route + constraint.

See reviews Level1_106 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub repository.

Times asked 9
Official solution

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

Demonstrate your application.

Times asked 8

Official solution

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

Where have you implemented APIs?

Times asked 1

Official solution

Simpleresources.py / @app.route. Postman or comments list.
Where implemented APIs.
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: url_prefix /api.
5

Where is Vue implemented in your project?

Times asked 1

Official solution

Simplefrontend/src or templates/index.html CDN + app.js. Entry main.js #app.
Where Vue implemented.
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 folder.
Project example: Open folder.
6

What are the major frameworks/libraries used in your project?

Times asked 1

Official solution

SimpleHar lib ek line why — list 40 mat.
Flask, SQLAlchemy, JWT/Security, CORS, Caching+Redis, Celery, Vue+Router, Vuex/Pinia, Axios/fetch, Chart.js, Bootstrap.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: requirements.txt + package.json top 6 open karke bolo.
Viva tipHar lib ek line why: CORS alag origin, Redis tez, Celery async, Chart.js dashboard.
7

Which database are you using?

Times asked 3

Official solution

SimpleSQLite file, zero setup, relational tables/FK. Redis NoSQL cache not primary.
NoSQL examples Mongo, Redis-as-DB. MAD2 models relational.
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: sqlite:///app.db. Redis 6379 alag.
8
Which ORM are you using?

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

Where is JWT authentication implemented?

Times asked 1

Official solution

SimpleLogin token create. Decorators protected APIs. JWT/Security init factory.
Where JWT authentication implemented backend. Show auth code.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX — asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: auth.py + decorators.
10
Where is Role-Based Access Control (RBAC) implemented?

Times asked 2
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).
11
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.
12

Where have you implemented caching?

Times asked 7

Official solution

SimpleGET lists/stats @cache.cached. Mutations pe delete. CACHE_TYPE Redis.
Why each route: public repeated reads. User-private careful.
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: File+line decorator. redis-cli get key optional.
13
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.
14

What have you used for the frontend?

Times asked 1

Official solution

SimpleVue SPA, Bootstrap/CSS, Chart.js, fetch/Axios, Vue Router, maybe Vuex.
What used for frontend. Which framework.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Don't forget router.
Project example: Don't forget router.
15

Change the Navbar order so that Profile appears before Dashboard.

Times asked 1

Official solution

Simplerouter-link order swap Profile before Dashboard.
That's it. Don't rebuild router.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Navbar.vue template order.
Project example: Navbar.vue template order.
16

Write a REST API to fetch all company details.

Times asked 1

Official solution

SimpleGET all companies serialize. REST API fetch all company details. Notepad or VS Code.
Admin maybe.
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: Company.query.all()
Project example: Company.query.all()

See reviews appdev_level1_viva30 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub repository, collaborators, and commit history.

Times asked 2
Official solution

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

Download the project from the portal and set it up.

Times asked 1

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
4

Demonstrate the complete application.

Times asked 33

Official solution

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

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
6
Show manual CSV export and email functionality.

Times asked 1
Official solution

SimpleSMTP + template + Celery. MailHog inbox dikhao, Gmail nahi chahiye.
Dynamic HTML user name. Live: schedule now.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
msg = Message(subject='Daily reminder', recipients=[user.email])
msg.html = render_template('reminder.html', user=user)
mail.send(msg)
```
Project example: reminder.html Jinja. tasks send_mail.
Viva tipLive demo ke liye Celery beat crontab current time pe set karo, worker + beat dono chalu rakho.
7
Explain the login route.

Times asked 2
Official solution

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

# baad ki APIs
# Authorization: Bearer <token>
if current_user.role != 'admin':
    abort(403)
```
Project example: Login.vue POST /api/login → token LS → interceptor. Student token se admin route = 403. Empty form = validation, galat password = 401.
Viva tipNetwork tab mein password body dikhega localhost pe — prod HTTPS. Response mein hash/password echo mat karo.
8

Explain the complete database schema.

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

Explain selected API routes.

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

Explain how data reaches the frontend.

Times asked 1

Official solution

Simplemounted fetch JSON v-for. Token header. Error banner. No Jinja loops except email.
Admin dashboard same + 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: Network GET 200 JSON preview.
11
Have you implemented session-based or token-based authentication?

Times asked 3
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.
12
Where is the authentication token stored?

Times asked 1
Official solution

SimpleLS / SS / memory / httpOnly cookie. Har request Authorization header.
Logout clear. XSS LS risk. Memory refresh lose.
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.
Example
```
localStorage.setItem('token', data.token)
localStorage.removeItem('token')
```
Project example: login.vue setItem. interceptor getItem. logout removeItem.
Viva tipSession Storage tab band pe saaf. Cookies expiry + httpOnly. Vuex memory refresh pe gayab — persist alag.
13

Why is token-based authentication used?

Times asked 1

Official solution

SimpleSPA + mobile + multiple APIs, server session memory nahi, scale.
Alag ports cookies pain CORS.
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: Vue 8080 Flask 5000 Bearer.
14

Show where authentication is implemented.

Times asked 2

Official solution

Simplelogin.vue + backend login + decorator + LS. Show login/authentication code.
Show where authentication backend.
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: 4 files.
15

Explain RBAC and where it is implemented.

Times asked 1

Official solution

SimpleRoles table, assignment, decorator, UI meta. Example admin vs user endpoint.
Admin authenticated AND authorized. User authenticated not authorized admin.
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: roles_required admin stats. User 403 Postman.
16
Show where the admin user is created.

Times asked 1
Official solution

SimpleSeed create_app user_datastore admin. Hash password. Role attach. Static env vs DB.
How admin created. Show code.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
if not User.query.filter_by(email='admin@x.com').first():
    user_datastore.create_user(email='admin@x.com', password=hash_password('Admin@123'))
```
Project example: if not User.query.filter admin: create.
17
What is ORM?

Times asked 49
Official solution

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

Why do we use SQLAlchemy?

Times asked 2

Official solution

SimpleModels relationships portable injection-safer than string SQL.
Why not directly sqlite3.
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: User.query vs cursor.execute f-string.
19
What is a Foreign Key?

Times asked 3
Official solution

SimpleForeign Key dusri table ki PK ki ungli pakadna. Relationship ka backbone.
user_id → user.id. Referential integrity. Unique extra ho sakta 1-1 ke liye.
Sirf UNIQUE se relationship nahi banti.
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
```
user_id = db.Column(db.Integer, db.ForeignKey('user.id', ondelete='CASCADE'))
```
Project example: booking.user_id, show.venue_id. models.py dikhao.
20
Where have you used Foreign Keys?

Times asked 1
Official solution

SimpleForeign Key dusri table ki PK ki ungli pakadna. Relationship ka backbone.
user_id → user.id. Referential integrity. Unique extra ho sakta 1-1 ke liye.
Sirf UNIQUE se relationship nahi banti.
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
```
user_id = db.Column(db.Integer, db.ForeignKey('user.id', ondelete='CASCADE'))
```
Project example: booking.user_id, show.venue_id. models.py dikhao.
21

What is Referential Integrity?

Times asked 1

Official solution

SimpleFK hamesha valid parent. Constraint last line of defense.
Bina cascade parent delete IntegrityError. App 400 'reassign first'.
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.user_id must exist. Demo delete user with bookings.
22

How do you maintain Referential Integrity?

Times asked 1

Official solution

SimpleFK hamesha valid parent. Constraint last line of defense.
Bina cascade parent delete IntegrityError. App 400 'reassign first'.
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.user_id must exist. Demo delete user with bookings.
23
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.
24

What happens if the parent row is deleted?

Times asked 1

Official solution

SimpleDepends ondelete: CASCADE children jaate, RESTRICT fail, SET NULL.
Bookings/venue: business. Soft-delete safer. Doctor deleted similarly.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Explain YOUR models ondelete. Don't guess opposite cascade.
25

What happens if ON DELETE CASCADE is not used?

Times asked 1

Official solution

SimpleParent delete IntegrityError if children. Handle 400 reassign first.
If ON DELETE CASCADE not used.
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: Demo fail delete venue with shows.
Project example: Demo fail delete venue with shows.
26

What relationships have you used in your models?

Times asked 1

Official solution

Simple1-M User-Booking, M-M User-Role. Count honestly. What relationships used in models.
Is 1-1? Honest.
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: Draw.
Project example: Draw.
27

Have you implemented caching?

Times asked 2

Official solution

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

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

Show where caching is implemented.

Times asked 6

Official solution

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

Times asked 1
Official solution

SimpleMiss print/DB, hit silent, timeout expiry, write delete.
Best viva demo Redis.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
@cache.cached(timeout=30, key_prefix='venues')
def get_venues():
    print('DB queried')
    return jsonify(...)
```
Project example: GET twice + POST + GET.
Viva tipprint() ya SQL echo se miss/hit dikhao. Timeout 10–30s karke expiry bhi demo kar sakte ho.
32
What is a cache hit?

Times asked 1
Official solution

SimpleHit = Redis ke paas jawab already hai. Miss = pehle DB se lana padega.
Hit pe database queried nahi hota — yahi examiner prove karwana chahta hai.
Typical flow:
1) cache.get(key)
2) mila to return (hit)
3) nahi mila to query + cache.set + return (miss)
Timeout ke baad key expire = next request phir miss. cache.clear() sab hataata hai, cache.delete(key) sirf ek route.
Example
```
data = cache.get('venues')
if data:
    return data          # hit
data = Venue.query.all() # miss
cache.set('venues', data, timeout=30)
return data
```
Project example: Pehli GET /api/venues — terminal mein SQL/print. Doosri GET turant — koi DB log nahi.
Viva tipHit pe database queried nahi hota. print() after set sirf miss pe chalega.
33

Which routes are cached?

Times asked 1

Official solution

SimpleList GET endpoints @cache. Not POST. Which routes are cached. Show cached API explain invalidation.
Why each.
Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.
Project example: Open decorators.
34
What tool have you used for caching?

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.
35
Where does Redis store cached data?

Times asked 1
Official solution

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

Why is Redis faster than a normal database?

Times asked 1

Official solution

SimpleFast kyunki RAM + simple commands, joins nahi.
Disk seek milliseconds, RAM microseconds. Redis single-threaded lekin har op chhoti.
Compare: SQLite file lock writes pe. Redis in-memory SET. Persistence RDB/AOF extra, default viva mein RAM.
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: Same JSON cache vs query.join — Network timing dikhao.
37

What are asynchronous jobs?

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

Why do we use Celery?

Times asked 2

Official solution

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

What is the advantage of Vue?

Times asked 1

Official solution

SimpleGentle curve, SFC, docs, reactivity, chhota vs Angular. Over React: HTML templates, course.
Over plain JS: components router ecosystem.
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: Justify Vue not React: taught + time.
40
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.
41
What is a Vue component?

Times asked 2
Official solution

SimpleComponent Lego block: UI + data. Pages routes, components unke andar.
Bahut files = maintainable Navbar/Footer. Not a bug.
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
```
app.component('Hello', { template: '<p>Hi {{ name }}</p>', props: ['name'] })
```
Project example: src/components vs views. router uses views.
Viva tipBahut Vue files isliye: har page/feature alag — maintainable. Navbar layout har route pe.
42

Why do we need components?

Times asked 1

Official solution

SimpleReuse Navbar split test. Why need components.
Many files OK.
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: Navbar Footer Card.
43
What are Props?

Times asked 4
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).
44
What is Computed?

Times asked 1
Official solution

SimpleComputed = lazy derived value. Ingredients na badlein to kitchen dobara nahi chalti.
Methods har render pe. Computed cache + dependency.
fullName, filteredList, isAdmin from role. Template {{ fullName }}.
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
```
computed: {
  fullName() { return this.first + ' ' + this.last }
}
```
Project example: filteredVenues computed from query string. Watcher nahi chahiye tha.
45

What is two-way binding?

Times asked 2

Official solution

SimpleTwo-way = UI aur data sync. Vue mein v-model. One-way mustache/v-bind.
Parent→child props one-way. Child change emit se. v-model on component = prop + emit update.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Booking qty input v-model. Seats left sirf {{ available }}.
46
What is onMounted()?

Times asked 1
Official solution

SimpleonMounted = Composition API ka mounted. setup() ke andar call.
Options API: mounted() method. Mix mat. Vue 3 dono chalte.
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.
Example
```
import { onMounted, ref } from 'vue'
const items = ref([])
onMounted(async () => {
  items.value = await (await fetch('/api/items')).json()
})
```
Project example: script setup: onMounted(loadStats).
47
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.
48

Write the syntax for v-for.

Times asked 1

Official solution

Simplev-for="(item,i) in items" :key="item.id". Write syntax for v-for.
Don't forget key.
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: Notepad.
49
What is the frontend entry point?

Times asked 1
Official solution

Simpleindex.html + main.js/index.js createApp use router store mount #app.
CDN: scripts in index. CLI: bundler inject.
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
```
createApp(App).use(router).use(store).mount('#app')
```
Project example: main.js 10 lines.
50
How is Vue connected with index.html?

Times asked 1
Official solution

SimpleEntry mount #app. How Vue connected index.html.
CDN vue global + app.js. CLI only div#app.
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.
Example
```
createApp(App).use(router).use(store).mount('#app')
```
Project example: index.html.
51
Explain route protection in Vue Router.

Times asked 2
Official solution

SimpleGuard darwaza: token nahi to login. Role nahi to 403 page.
beforeEach. Frontend UX. Backend @jwt_required bina guard hack possible — dono 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.
Example
```
router.beforeEach((to) => {
  if (to.meta.auth && !localStorage.getItem('token')) return '/login'
})
```
Project example: router.beforeEach token localStorage. Admin routes meta.role.
52
What is the Anchor (<a>) tag?

Times asked 1
Official solution

Simple
```
<a href> links. Vue router-link better SPA. External target=_blank. Anchor tag.
```
What is the Anchor tag.
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 <a href=/dashboard> full reload if SPA.
53
Create a Button tag.

Times asked 1
Official solution

Simple
```
<button type=button> vs submit form. Vue @click. Create a Button tag.
```
type important.
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: <button class=btn @click=save>
Project example: <button class=btn @click=save>
54

Have you created backend APIs?

Times asked 3

Official solution

SimpleYes REST. List 5. Postman. Local APIs vs REST: MAD2 REST JSON.
Did you create backend APIs? Yes examples.
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: resources.py.
Project example: resources.py.
55
Write a simple "Hello World" Flask route.

Times asked 1
Official solution

Simple/ hello world string or json. Write simple Hello World Flask route.
@app.route.
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.route('/hello')
def hello():
    return jsonify(message='Hello World')
```
Project example: Notepad or app.py.
56
Write a route to return: All users All students All doctors Doctors from the Cardiology department Users filtered by role

Times asked 1
Official solution

SimpleNaya Flask route: URL, method, auth if needed, query, jsonify. Postman pehle.
Examiner number/filter change easy rakhna. CORS. Frontend tabhi jab bole.
Status codes sahi. Password JSON mein nahi.
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
```
@app.route('/api/sum', methods=['POST'])
def sum_num():
    d = request.get_json()
    return jsonify(result=d['a'] + d['b'])
```
Project example: resources.py new Resource. Test Thunder. Optional Vue fetch.
57

Explain how frontend fetches data from the backend.

Times asked 1

Official solution

Simplemounted fetch JSON v-for. Token header. Error banner. No Jinja loops except email.
Admin dashboard same + 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: Network GET 200 JSON preview.
58

Create a new Vue page/component and connect it to the router.

Times asked 1

Official solution

Simpleviews/Foo.vue + routes.js + link. Fetch mounted.
Connect new page.
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: Live.
Project example: Live.
59

Fetch "Hello World" from the backend and display it.

Times asked 1

Official solution

SimpleGET /api/hello {message} Vue mounted {{ message }}. Fetch Hello World backend display.
Display backend message Hello.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Simplest full stack proof.
60

Write a JavaScript function to combine first name and last name.

Times asked 1

Official solution

Simplefunction full(a,b){return a+' '+b}. Write JS firstname lastname combined. Combine first last.
Template string OK.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Project example: console.log(full('A','B')).
Project example: console.log(full('A','B')).
61
Write Vue code to add two numbers and display the result.

Times asked 1
Official solution

Simplev-model.number a b {{a+b}}. Write Vue code add two numbers display.
Don't string concat — .number.
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.
Example
```
<input v-model.number="a"><input v-model.number="b">
<p>{{ a + b }}</p>
```
Project example: tiny component.
62
Write a SQLAlchemy query to: Fetch all doctors in a department. Fetch all easy-level treks.

Times asked 1
Official solution

Simpleget id, filter blacklisted, unapproved, easy flag. Same Query API. Write SQLAlchemy query retrieve user by id blacklisted unapproved easy treks.
db.session.get(User,id) SQLA2.
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
```
User.query.get(id)
User.query.filter_by(blacklisted=True)
Drive.query.filter_by(approved=False)
```
Project example: flask shell.
63

How much AI (%) did you use in your project/report?

Times asked 1

Official solution

SimpleSach % + kahan + kaise verify + kya seekha. Report se contradict mat.
Boilerplate vs business logic. Examiner process poochta. 'Sab ChatGPT' red flag.
Verify: docs, run, edge case. Seekha: CORS, JWT exp, beat vs worker.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Jo number form/PDF mein hai wahi. Example file jo AI se start kiya, khud debug kiya.
Viva tipExaminer 'kya seekha / kaise check kiya' pe marks. 'Sab ChatGPT' red flag. Jo khud debug kiya woh story ready rakho.
64
How have you implemented timestamps?

Times asked 1
Official solution

Simplecreated_at updated_at DateTime utcnow. Dashboard format. How implemented timestamps.
Add timestamp column 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
```
created_at = db.Column(db.DateTime, default=datetime.utcnow)
```
Project example: Booking.created_at.
65

What is Payload?

Times asked 1

Official solution

SimplePayload = dabba ke andar samaan (body). JWT payload beech wala claims (encrypted nahi).
POST haan JSON. GET query string. JWT payload vs HTTP payload alag context.
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: request.get_json() create venue. Token payload user id jwt.io.
66

Does a GET request have a payload?

Times asked 1

Official solution

SimpleAvoid GET body. Query string filters. Some clients strip GET body.
Does GET have payload? Shouldn't.
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: Search ?q=.
67

Does a POST request have a payload?

Times asked 1

Official solution

SimpleYes typically JSON/form. request.get_json().
Does POST have payload? Yes.
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 body email password.
Project example: login body email password.

See reviews Level1_133 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2

Download the project from the portal.

Times asked 4

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
3

Set up the project.

Times asked 1

Official solution

SimpleREADME Python Node Redis .env. Set up the project. Setup scripts line-by-line.
local_setup.sh venv pip npm redis flask db.
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: Open sh explain.
4

Explain your setup scripts (Shell scripts) and how they work.

Times asked 1

Official solution

Simplelocal_setup.sh venv pip npm. local_run.sh processes. Explain setup scripts how they work.
Fail points python version redis missing.
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: Open file.
5
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.
6

Which tasks are handled by Celery?

Times asked 1

Official solution

SimpleReminder emails, monthly report, CSV export — jo code mein hai.
User vs scheduled label.
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 function names.
7
Show where and how you have implemented Celery.

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

Show the backend endpoints that trigger Celery tasks.

Times asked 1

Official solution

SimpleButton POST .delay() 202. Poll status. Beat nahi, worker haan.
Export vs daily reminder difference.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Export CSV button. Network 202.
Project example: Export CSV button. Network 202.
9

Demonstrate the asynchronous tasks from the frontend.

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.
10
How is the email content generated dynamically for backend jobs?

Times asked 1
Official solution

Simple
```
render_template('report.html', user=u, stats=stats) har user alag.
```
Loop users in task. Don't send same body.
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: monthly report HTML table their bookings.
11

Demonstrate your application.

Times asked 8

Official solution

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

What happens if the user refreshes the page in the middle of a quiz?

Times asked 1

Official solution

SimpleSPA refresh JS state gayab. Persist LS/session or backend save. Warn beforeunload. Refresh middle of quiz.
What happens.
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 quiz in project. Else theory + how would save progress.
13
What is Vuex Store?

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

Where have you declared all the frontend routes?

Times asked 1

Official solution

SimpleVue router.js. Flask @app.route / resources.py.
Both if asked frontend vs backend.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Don't mix.
Project example: Don't mix.
15

How does Vue know which component to render for each route?

Times asked 1

Official solution

Simplepath-to-regexp match array. meta extra. Guard before render.
Unknown path catch-all NotFound.
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: routes.js last path: '/:pathMatch(.*)*'.
16
What is the entry point of your frontend application?

Times asked 1
Official solution

Simpleindex.html + main.js/index.js createApp use router store mount #app.
CDN: scripts in index. CLI: bundler inject.
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
```
createApp(App).use(router).use(store).mount('#app')
```
Project example: main.js 10 lines.
17

What authentication mechanism have you used?

Times asked 1

Official solution

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

Times asked 1
Official solution

SimpleLogin ke baad header. Axios interceptor ya fetch wrapper. Backend verify.
Har protected API. Public login/register nahi.
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.
Example
```
headers: { 'Authorization': 'Bearer ' + localStorage.getItem('token') }
```
Project example: Network list request Headers Bearer.
19

What is Session Storage?

Times asked 2

Official solution

SimplesessionStorage tab close clear. Same API as LS.
What is Session Storage.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: If unused, theory vs LS.
Project example: If unused, theory vs LS.
20
Add a "Deleted" checkbox to the admin search: If checked, display only deleted records. Otherwise, display only non-deleted records.

Times asked 1
Official solution

SimpleAdmin search extra query is_deleted if checkbox. Soft-delete flag. Add Deleted checkbox admin search.
Default active only.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Example
```
q = Venue.query
if request.args.get('deleted') == '1':
    q = q.filter_by(is_deleted=True)
else:
    q = q.filter_by(is_deleted=False)
```
Project example: query param deleted=1.

See reviews Level1_91 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub repository and collaborator.

Times asked 16
Official solution

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

Download the project from the portal and run it.

Times asked 6

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
4

Demonstrate the complete application (the proctor may guide the flow, e.g., Admin → Company/Staff → User/Student).

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

Show all core functionalities.

Times asked 5

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

Show and explain the code for a specific feature when asked.

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.
7
Explain where overbooking prevention is implemented.

Times asked 1
Official solution

SimpleSeats_left check + transaction. Race SELECT FOR UPDATE / unique seat.
qty > available 400. Frontend :max still 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.
Example
```
if show.available < qty:
    abort(400)
show.available -= qty
db.session.commit()
```
Project example: available=1, two qty=1 — ek fail.
8
Explain duplicate booking/application prevention.

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.
9
Explain the search functionality.

Times asked 2
Official solution

SimpleSearch demo cases.
See earlier essay.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
q = request.args.get('q', '').strip()
items = Venue.query.filter(Venue.name.ilike(f'%{q}%')).all()
return jsonify([v.serialize() for v in items])
```
Project example: UI + API.
Viva tipEmpty search, no-match, case-insensitive (ilike) teen cases dikhao.
10
Demonstrate CSV export and open the generated file.

Times asked 1
Official solution

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

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
12

Explain where the email sending logic is implemented.

Times asked 1

Official solution

SimpleFlask-Mail SMTP Celery. Templates HTML. Verify MailHog/logs.
Dynamic render_template user=stats.
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: tasks send + reminder.html.
Project example: tasks send + reminder.html.
13
Show how Celery workers/schedulers are configured.

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.
14
Show where backend jobs are implemented.

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
15

Show where caching is implemented.

Times asked 6

Official solution

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

Show where JWT/Flask-Security authentication is implemented.

Times asked 1

Official solution

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

Times asked 1
Official solution

Simpleget id, filter blacklisted, unapproved, easy flag. Same Query API. Write SQLAlchemy query retrieve user by id blacklisted unapproved easy treks.
db.session.get(User,id) SQLA2.
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
```
User.query.get(id)
User.query.filter_by(blacklisted=True)
Drive.query.filter_by(approved=False)
```
Project example: flask shell.
18
Write a new API route (e.g., display unapproved drives).

Times asked 1
Official solution

SimpleNaya Flask route: URL, method, auth if needed, query, jsonify. Postman pehle.
Examiner number/filter change easy rakhna. CORS. Frontend tabhi jab bole.
Status codes sahi. Password JSON mein nahi.
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
```
@app.route('/api/sum', methods=['POST'])
def sum_num():
    d = request.get_json()
    return jsonify(result=d['a'] + d['b'])
```
Project example: resources.py new Resource. Test Thunder. Optional Vue fetch.
19

Modify the Celery scheduler.

Times asked 1

Official solution

SimpleEdit beat dict, restart beat, log Sending due task.
Same as live_celery.
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: config.py.
20

Change the application's default landing page (e.g., Register instead of Login).

Times asked 1

Official solution

Simplerouter default Register instead of Login. Flask / send_file index. Change default landing page.
path: '/' component Register.
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: routes.js.
Project example: routes.js.
21
Change the color of: Navbar Sidebar Buttons Export CSV button

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.
22
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.
23
Explain the lifecycle hooks you used.

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

Difference between created and mounted.

Times asked 1

Official solution

Simplecreated soch, mounted dikhai de. API/chart ke liye mounted.
created: reactive data setup. mounted: DOM insert. beforeUnmount cleanup.
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: created mein token read localStorage. mounted mein fetch with that token.
25

What is two-way binding?

Times asked 2

Official solution

SimpleTwo-way = UI aur data sync. Vue mein v-model. One-way mustache/v-bind.
Parent→child props one-way. Child change emit se. v-model on component = prop + emit update.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Booking qty input v-model. Seats left sirf {{ available }}.
26
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.
27
Difference between Vue CLI and Vue CDN.

Times asked 5
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.
28
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.
29
Difference between Authentication and Authorization.

Times asked 20
Official solution

SimpleAuthentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password check karke prove karte ho ki tum genuine user ho. Success pe session/token milta hai.
Authorization: uske baad role check. Admin hi parking lot / venue / drive delete kar sakta hai, normal user nahi.
MAD2 mein yeh alag layers hain: login API = authentication (JWT milta hai). @roles_required('admin') ya Vue v-if="isAdmin" = authorization.
Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+). Authentication identity hai, authorization permission, validation input quality.
Example
```
# Authentication
if user and check_password_hash(user.password, form_password):
    token = create_access_token(identity=user.id)

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

How does JWT work?

Times asked 1

Official solution

SimpleIssue, store, send, verify signature+exp, identity=sub.
Invalid 401. Role claim extra. Refresh optional — most student apps nahi.
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: Walk one request Network.
31

Are JWT tokens encoded or encrypted?

Times asked 1

Official solution

SimpleJWT encoded+signed, typically not encrypted. Payload readable.
JWE encrypted alag. Don't put secrets in payload.
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: jwt.io decode without secret shows claims.
32

What is the purpose of JWT?

Times asked 1

Official solution

SimpleStateless auth APIs. Identity+claims bina server session store.
SPA/mobile. Revoke harder than session.
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: Why token not session: ports CORS scale.
33
What is Flask-Security?

Times asked 1
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).
34
How do Redis and Celery work together?

Times asked 1
Official solution

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

Times asked 49
Official solution

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

Why do we use SQLAlchemy?

Times asked 2

Official solution

SimpleModels relationships portable injection-safer than string SQL.
Why not directly sqlite3.
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: User.query vs cursor.execute f-string.
37

Explain SQLAlchemy queries (.all(), .filter(), .join(), .one()).

Times asked 1

Official solution

Simple.all list .first one .get(id) .filter .join .one exactly one else error .paginate.
Explain SQLAlchemy queries.
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: Open a query line.
38

What is SQLAlchemy Injection?

Times asked 1

Official solution

SimpleORM not magic if raw SQL. Use bound params.
What is SQLAlchemy injection.
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: Grep text( in code should be none.
Project example: Grep text( in code should be none.
39
What is cascade?

Times asked 1
Official solution

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

How are tables related?

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

Explain lazy loading.

Times asked 3

Official solution

SimpleLazy = zarurat pe load. Relationship default extra query. Vue route import() code-split.
lazy='dynamic' query object. noload mat laao. Fast first paint.
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: user.bookings access pe query. Dashboard joinedload instead.
42
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.
43

Why is caching used?

Times asked 2

Official solution

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

Where have you implemented caching?

Times asked 7

Official solution

SimpleGET lists/stats @cache.cached. Mutations pe delete. CACHE_TYPE Redis.
Why each route: public repeated reads. User-private careful.
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: File+line decorator. redis-cli get key optional.
45
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.
46

Why do we use Redis?

Times asked 2

Official solution

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

Times asked 1
Official solution

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

Explain the flow of an API request.

Times asked 1

Official solution

SimpleWSGI → URL map → decorators auth/cache → view → response. Cache hit view skip.
Arrival to response favourite.
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: Trace one GET venues.
50

Explain the search API.

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.
51
Explain HTTP methods (CRUD).

Times asked 1
Official solution

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

Explain HTTP vs HTTPS.

Times asked 1

Official solution

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

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

Difference between Session Storage and Local Storage.

Times asked 1

Official solution

SimpleSame API getItem/setItem. SS tab close pe saaf. LS survive. Shared computer pe SS thoda safer.
Token LS common. Session storage quiz in-progress bhi.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: token localStorage. Don't mix randomly.
55

Have you used AI in your project? If yes, where and how?

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

What percentage of the project was AI-generated?

Times asked 1

Official solution

SimpleSach % + kahan + kaise verify + kya seekha. Report se contradict mat.
Boilerplate vs business logic. Examiner process poochta. 'Sab ChatGPT' red flag.
Verify: docs, run, edge case. Seekha: CORS, JWT exp, beat vs worker.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Jo number form/PDF mein hai wahi. Example file jo AI se start kiya, khud debug kiya.
Viva tipExaminer 'kya seekha / kaise check kiya' pe marks. 'Sab ChatGPT' red flag. Jo khud debug kiya woh story ready rakho.
57
What is MVC?

Times asked 9
Official solution

SimpleModel-View-Controller separation of concerns.
Map folders. Vue is V. Flask routes C. models M.
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'.
Example
```
Vue Booking.vue → POST /api/book → Booking model → jsonify → this.bookings.push
```
Project example: See architecture essay.
58
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.

See reviews Level1_145 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1
Change the color of a button.

Times asked 5
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.
2
Create an API route as instructed by the proctor (e.g., return all records with a rating greater than 3).

Times asked 1
Official solution

SimpleNaya Flask route: URL, method, auth if needed, query, jsonify. Postman pehle.
Examiner number/filter change easy rakhna. CORS. Frontend tabhi jab bole.
Status codes sahi. Password JSON mein nahi.
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
```
@app.route('/api/sum', methods=['POST'])
def sum_num():
    d = request.get_json()
    return jsonify(result=d['a'] + d['b'])
```
Project example: resources.py new Resource. Test Thunder. Optional Vue fetch.
3

Change the application's port from 5000 to 8000.

Times asked 1

Official solution

Simpleflask run --port 8000. Update axios baseURL CORS.
Change from 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: Demo both.
Project example: Demo both.
4

Does crontab support seconds? If yes, schedule a task to run every 10 seconds.

Times asked 1

Official solution

SimpleClassic cron seconds nahi samajhta. Celery schedule=10.0 se seconds.
Examiner trap. Har 10s: schedule=10.0 ya timedelta(seconds=10).
Crontab fields mein seconds nahi.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Agar demo chahiye jaldi, har minute crontab better than 10s spam.
5
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.
6
What is a Crontab?

Times asked 1
Official solution

SimpleCrontab 5 boxes: minute hour day-of-month month day-of-week.
crontab(hour=18, minute=0) roz 6pm. day_of_month=1 monthly. minute='*/1' har minute test.
Standard cron seconds support nahi. Examiner 'every 10 seconds' bole to schedule=10.0.
Beat process isi dict ko padhti hai. Edit ke baad beat restart.
Example
```
from celery.schedules import crontab
crontab(hour=18, minute=0)
crontab(minute='*/1')
crontab(day_of_month=1, hour=9, minute=0)
```
Project example: daily 18:00, monthly 1st 09:00. Viva mein dono 17:20 karke live dikhaya.
Viva tipStandard cron seconds support nahi karta. Har 10 sec ke liye Celery schedule=10.0 use karo.
7

What have you used as the message broker?

Times asked 1

Official solution

SimpleRedis. Alternative RabbitMQ. Course Redis because cache bhi.
Between Flask client and Celery worker.
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: broker_url redis://localhost:6379/0
8
What is a JWT token? Explain its three parts.

Times asked 1
Official solution

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

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

What is a Candidate Key?

Times asked 1

Official solution

SimpleCandidate key koi bhi unique ID (email, id). PK unme se election jeetne wala.
Email candidate. Hum id PK rakhte hain kyunki email change ho sakta.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: User: id PK, email unique candidate.
11

How is a Candidate Key different from a Primary Key?

Times asked 1

Official solution

SimpleCandidate key koi bhi unique ID (email, id). PK unme se election jeetne wala.
Email candidate. Hum id PK rakhte hain kyunki email change ho sakta.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: User: id PK, email unique candidate.
12

What is inheritance? Show where you have used it in your project.

Times asked 1

Official solution

SimpleOOP child parent methods. db.Model inherit. Vue mixins/composables. Jinja extends MAD1 → Vue layout slots/router-view.
Show where used. Template inheritance Vue analogue Navbar+router-view.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: class User(db.Model). App.vue layout.
13

Why is if __name__ == "__main__" used in Python? What happens if you remove it?

Times asked 1

Official solution

Simple== value. is identity same object. Speed micro. None: is None.
Difference is and ==. Performance negligible vs correctness.
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 user is None. Don't is for strings.
14
What are the different Vue directives?

Times asked 1
Official solution

SimpleDirectives Vue ke special attributes — HTML ko superpower.
v-if/else/show, v-for, v-bind (:), v-on (@), v-model, v-html (XSS), v-cloak, v-slot.
:src = v-bind:src. @click = v-on:click.
Custom directives bhi (v-focus) — course basics kaafi.
Example
```
<p v-if="ok">Yes</p>
<li v-for="u in users" :key="u.id">{{ u.name }}</li>
<input v-model="email">
<img :src="url">
```
Project example: List v-for :key. Form v-model. Admin v-if. Image :src.
Viva tip: src ke liye v-bind:src ka shorthand. @click = v-on:click.
15
What is the difference between v-if and v-show?

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

Why are @token_required and @role_required decorators used?

Times asked 1

Official solution

SimpleEvery protected route guaranteed. Readable. Forget if manual if.
Why token_required and role_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: Can't skip check.

See reviews Level3_19 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1

Demonstrate your project using the Level 1 viva checklist.

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
Show and explain your Celery implementation.

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.
3
Show and explain your Redis implementation.

Times asked 1
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.
4
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.
5
Explain how RBAC (Role-Based Access Control) is implemented in your application.

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

See reviews Level2_139 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1

Show your ID card.

Times asked 23

Official solution

SimpleCamera pe college ID — naam photo match. Identity viva ki pehli gate.
Pehle se haath mein, glare nahi. Examiner screenshot. Phir GitHub + portal ZIP run.
Name GitHub/portal se mismatch red flag.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Project example: ID dikhao, bolo roll/name, phir screen share repo.
Viva tipPehle se ID haath mein rakho, glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.
2
Show your GitHub collaborator.

Times asked 3
Official solution

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

Download the project from the portal and run it.

Times asked 6

Official solution

SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.
Portal download → extract → redis, venv, pip, npm, flask, worker, beat.
Checksum maange to hash. Uncommitted files mat dikhana.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) ZIP
2) Extract
3) Redis + venv + pip
4) npm/vite
5) flask + celery worker + beat
Project example: Submitted zip run. README commands copy.
Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.
4

Demonstrate the core functionalities (Admin/User or Admin/Doctor/Patient dashboards).

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

Show where caching is implemented in your code.

Times asked 1

Official solution

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

Times asked 2
Official solution

SimpleSMTP + template + Celery. MailHog inbox dikhao, Gmail nahi chahiye.
Dynamic HTML user name. Live: schedule now.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Example
```
msg = Message(subject='Daily reminder', recipients=[user.email])
msg.html = render_template('reminder.html', user=user)
mail.send(msg)
```
Project example: reminder.html Jinja. tasks send_mail.
Viva tipLive demo ke liye Celery beat crontab current time pe set karo, worker + beat dono chalu rakho.
7
Demonstrate the monthly and daily reminder jobs.

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
8
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 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.
10

What are the advantages of Local Storage?

Times asked 1

Official solution

SimplePersist refresh, simple API, 5MB. Nuksaan XSS, no expiry, strings only.
Advantages of Local Storage.
Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.
Project example: Token survives refresh.
Project example: Token survives refresh.
11

Add a button below the Login button that hides the Login button when clicked.

Times asked 1

Official solution

Simpledata hide=false. Extra button @click hide=true. Login v-if=!hide. Add button below Login hides Login.
v-if.
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: Login.vue.
12

Write/implement an API that fetches all users and returns the data in JSON format.

Times asked 1

Official solution

SimpleUser.query serialize list jsonify strip password. API fetches all users JSON.
Admin maybe.
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/users.
Project example: GET /api/users.
13

Display or trigger the Login button 10 times (project-specific UI change).

Times asked 1

Official solution

Simplev-for n in 10 button or @click counter. Display trigger Login 10 times. Confirm which button.
Project-specific UI.
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: Ask which login.

See reviews Level1_103 MAD2 Level 1

Aug 2, 2026

Download all Download all

Copy set link

1

Give a quick demonstration/presentation of your application.

Times asked 1

Official solution

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

Times asked 1
Official solution

SimpleLive jobs: Redis, worker, beat, crontab abhi, logs + email/CSV.
Scheduled vs user-triggered dono dikhao. Missing feature honestly.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.
Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.
Suggested flow1) redis
2) worker
3) beat
4) crontab now
5) logs + MailHog
Example
```
CELERY_BEAT_SCHEDULE = {
  'daily-reminder': {
    'task': 'jobs.daily_reminder',
    'schedule': crontab(hour=18, minute=0),
  },
}
```
Project example: Change schedule current time. MailHog. Export button 202.
3

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

What is a Primary Key?

Times asked 5

Official solution

SimplePrimary Key unique not null identity. Usually integer autoincrement.
Candidate keys mein se chosen. Composite PK possible, course simple id.
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: Har model id = db.Integer primary_key=True.
5
What is a Foreign Key?

Times asked 3
Official solution

SimpleForeign Key dusri table ki PK ki ungli pakadna. Relationship ka backbone.
user_id → user.id. Referential integrity. Unique extra ho sakta 1-1 ke liye.
Sirf UNIQUE se relationship nahi banti.
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
```
user_id = db.Column(db.Integer, db.ForeignKey('user.id', ondelete='CASCADE'))
```
Project example: booking.user_id, show.venue_id. models.py dikhao.
6
What is async / await?

Times asked 2
Official solution

Simpleasync/await Promise ko seedha-seedha padhne jaisa banata hai, magic nahi.
await sirf async ke andar. try/catch reject. Parallel: Promise.all.
Celery se confuse mat hona — yeh JS event loop, woh Python worker.
JS browser ki language. const rebind nahi, let block. Arrow () => this lexical.
Promise: pending/fulfill/reject. async/await usko seedha padhne jaisa. try/catch await pe. Yeh Celery nahi — Celery Python worker.
fetch native AJAX. array.filter/map computed lists. Vue data reactive; plain JS DOM querySelector se manual.
Example
```
async function load() {
  const r = await fetch('/api/venues')
  return r.json()
}
```
Project example: async mounted() { this.rows = await api() }
7
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).
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 / venue / drive delete kar sakta hai, normal user nahi.
MAD2 mein yeh alag layers hain: login API = authentication (JWT milta hai). @roles_required('admin') ya Vue v-if="isAdmin" = authorization.
Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+). Authentication identity hai, authorization permission, validation input quality.
Example
```
# Authentication
if user and check_password_hash(user.password, form_password):
    token = create_access_token(identity=user.id)

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

Why did you use Vue CDN?

Times asked 2

Official solution

SimpleCDN isliye simple deploy, kabhi Node nahi chahiye viva machine pe.
Show <script src=vue> index.html. Tradeoff: SFC nahi, ek bada JS file.
Agar CLI use kiya to yeh answer ulta: SFC + build isliye CLI.
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: index.html bottom script tags Vue + vue-router + app.js.

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