Viva prep · Real questions · Student experiences Enroll in Bootcamp

Proctor workspace

Proctor Level3_11

Share your experience Add your viva experience here
497 Questions
97 Sets
0 Topics
39 Reviews
Tips for this examiner: Prepare your theory well. The level2 is meant for how much you know the concepts.

Student reviews

Sheet response MAD1

The response document was highly helpful for this proctor. I suggest that, those who get this proctor, to just go through the things mentioned in the response document about him in the past. He repeats the viva process exactly the same as mentioned in it.

Questions remembered
  1. He is very patient, cool & friendly proctor.
  2. - he came 10 mins late
  3. - show id
  4. - download the file from portal
  5. - run the code and start the app
  6. - create user 1, create staff , try login for the staff and show the message of access pending, make admin to allow access to him , create a trek, assign the trek to staff, create user 2, book the trek with user 2, make the staff change the status of the trek to closed, now login with user1 and check whether the closed trek is showing or not. (While I was doing the task, I was also explaining the features available in each page of admin user & staff)
  7. - now in coding part he asked me to explain the database and the controllers
  8. - in theory part, he asked me about single page application, diff b/w put and patch, diff b/w authentication & authorisation
  9. - Not even single task was given to do code or change code.
  10. - finally he said assessment is over and asked whether I have any questions to him. I asked about the presentation of the project I did and the corrections to be made in my app. He said correction in the way I presented and features to be added in the app
  11. Duration was around 35 mins.
Writwik Das MAD1

This proctor doesn't focus much on the code writing or code change in viva, only theoritical questions.

Questions remembered
  1. Explain the overall project
  2. Create a new trek staff account and approve it as admin.
  3. Create a trekker account and login then book a trek.
  4. Then asked me to explain the search mechanism.
  5. what is lazy loading
  6. internal vs inline css
  7. left join
  8. ilike vs like
Sheet response MAD1

Meet ended about 30-35 minutes. Prepare simple theory question. Finally he asked that any questions for him. I asked for some suggestions. He gave me some. The proctor is very cool. Don't worry. Best wishes for your viva🤝

Questions remembered
  1. show id, download project, run application
  2. just started demo. Bt he asked to create staff, user, trek. Login as admin. Approve staff. Assign staff to newly created trek. Book trek. Change status of trek to closed from staff dashboard. Search trek from user dashboard.
  3. explain code responsible for search trek for admin. 4)What is SPA?
  4. Difference b/w cell spacing and padding
  5. Explain models.py
  6. Authorization and authentication * No coding questions
nandita MAD1

be well with your code and project workflow, he focuses a bit more on the UI of our application

Questions remembered
  1. • show id, download project and run
  2. • login as admin, create a trek
  3. • register and login as staff and update trek status
  4. • register as user and book a trek
  5. • asked basic ques related to functionalities of my app
  6. • explain your models.py
  7. • SPA
  8. • lazy loading
  9. • advantage of internal css over inline css
  10. • left join
  11. • difference between primary key and foreign key
  12. • authorization
  13. • no code changes
  14. • asked if i had any ques for him and i asked for improvement advice for my app and then he suggested improvements
  15. • viva done in like 30 mins
Abinaya MAD1

He's super chill. And he will repeat his questions if you didn't hear it properly. Focus on SPA. Just go through the questions he asked prev and there u go~

Questions remembered
  1. He came 5-7 mins late
  2. Asked for my id and demo
  3. He went off for 4 mins cuz he got a call ig
  4. Asked to explain the models, SPA, lazy loading, search functionality, js variable declaration.
  5. No coding tasks. Very chill. The viva was only 15 mins or less than that. Go through the ques he asked previously
Anshu MAD1

CHILL KARO

Questions remembered
  1. Honestly, this was probably the chillest guy you can ever get. Very calm, very predictable, and the whole vibe was super relaxed.
  2. As always… he came around 15 minutes late 😭
  3. He began with the project demo and asked for simple demonstration of the basic functionalities. Nothing tricky, just normal flow of the project and explanation.
  4. Questions asked:
  5. Explain your models
  6. Authentication vs Authorization
  7. What is ilike
  8. What is SPA (for some reason he really loves asking SPA in MAD 1)
  9. What is Standalone Component
  10. What is Lazy Loading
  11. What is Inline and Internal CSS
  12. Code changes?
  13. None.
  14. Literally no code changes, no “write this route,” no debugging, nothing.
  15. And the funny part is I was prepared like crazy. IT IS WHAT IT IS 🤷‍♂️
someone MAD1

he is a very chill proctor.....questions are mostly same as previous ones , you are lucky if you got this proctor

Questions remembered
  1. 1)iitm id card
  2. 2)run application
  3. 3)demo of the application
  4. 4)asked to shift my create_drive button to right side(in company dashboard)
  5. 5)told me what what things should i add in my application
  6. 6)asked my to explain app.py
  7. 7)told me to explain search functionality , how it works
  8. 8)theory questions
  9. -- what is spa
  10. -- standalone component
  11. -- lazy loading
  12. -- authentication
  13. At last, he said you are done with viva, if you have any doubts you can ask...so i asked what things should i add in my app to make it more impactful....he told me what to add....and then ended.
Steven MAD1

Be confident in your code and explain everything to the best you can. He will listen properly and understand your code. Chill proctor. Learn your theory well.

He also gives very nice tips and ways to better clean up your code and ways to implement more functionality. Listen to his tips coz they're very useful. Very nice proctor.

Questions remembered
  1. He came 20 mins late but the POD came and told to wait for him to come.
  2. Asked to demo the project fully and asked small small questions in between like asking functionality
  3. Asked to show database models and explain them
  4. Authentication vs authorization
  5. What is SPA
  6. What is a component
  7. Difference between ILIKE and LIKE
  8. Show the search operation for filtering and explain it
Ramyaprabha MAD1

Know your code well

Questions remembered
  1. MAD 2
  2. Project demo
  3. like
  4. Lazy
  5. Single page application
  6. Authentication
Sheet response MAD1

Shared viva questions from response sheet: show id; download from portal and start app; demostrated portal functionalities

Questions remembered
  1. show id
  2. download from portal and start app
  3. demostrated portal functionalities
  4. Explain model.py
  5. What is SPA
  6. What is Lazy loading
  7. What is Authentication
  8. What is ilike
  9. Suggested some improvements
Aryan Shukla MAD1

Shared viva questions from response sheet: Level 2 Viva; 1)Show ID; 2)Run the application

Questions remembered
  1. Level 2 Viva
  2. 1)Show ID
  3. 2)Run the application
  4. 3)Checks almost all functionalities
  5. 4) Suggests Changes that will make the application better
  6. 5)ilike operation
  7. 6)Lazy evaluation
  8. 7)Standalone component
  9. 8)Authentication and Authorisation
  10. 9)cell padding and cell spacing
  11. 10)SPA
  12. 11)inline styling
  13. 12)I forgot to add he first said to explain models and database
  14. 13)and few more basic question in total around 10-12 questions.
  15. 14) After viva asks if you have any questions for him.
Moomin Bin Nissar MAD1

Guy is very chill, will make you comfortable. Be confident and prepare these ones especially

Questions remembered
  1. • ID CARD
  2. • APP PRESENTATION SHORT(Suggested improvements)
  3. • Placement Drive Creation flow in the app
  4. • ilike in SQALCHEMY
  5. • Lazy Loading vs Eager Loading (eager loading real world usage)
  6. • Single page apps
anonymous MAD1

Cool guy, answer what you know, be confident, be clear with your code (what and where)

Questions remembered
  1. LEVEL II Viva:
  2. App Demo (in between questions on features of app)
  3. what is inline and internal CSS
  4. authentication vs authorization
  5. SPA
  6. lazy loading
  7. Explain your models and database
  8. How the search functionality is implemented
  9. Any questions from our side (no code changes asked)
Shhhh MAD1

Prep well according to what your proctor has asked in the past.

Questions remembered
  1. Asked for IIT-M ID
  2. Asked to download the submission from the portal.
  3. Asked me to run the project using the downloaded file. (Venv creation, requirements installation, everything one needs to do)
  4. Goes through the project step by step same as level 1.
  5. Gives suggestions for improvements in the project.
  6. Asked theoretical questions. 6.1 What is SPA. 6.2 What is inline styling. 6.3 What is cascading effect wrt databases. 6.4 What is the difference ilike function and like function (I used ilike for search functionality, but did not know the difference).
  7. Said he was done with the assessment and asked whether I have any questions or not. I asked how I did on the viva. He said I just need to implement the suggestions he gave to make this a full fledged working example.
  8. Did not ask to do any code changes.
Jeevan Prem MAD1

Chill, very easy, easier then level 1,no code changes

Questions remembered
  1. Viva lvl 2:
  2. -Showed id
  3. -showed app demonstration
  4. -explain models.py
  5. -explain doctor create route
  6. -SPA(Single page application)
  7. -Authentication vs authorization
  8. -post vs put
Hash Birla MAD1

Chill Proctor, Didn't ask for any code change. was giving me feedback in between the explaination like what more could i do to make it more user friendly.

Questions remembered
  1. Level 2.
  2. Asked to show the working of the webapp.
  3. Asked to create, update a doctor and set their availablity for the week.
  4. Asked to Book an appointment for the same doctor.
  5. Checked if we could book more than one appointment for a single day.
  6. Asked to Show and explain the models.
  7. Asked what is lazy loading.
  8. Asked the difference b/w inline and internal CSS.
  9. Asked to explain my update doctor route.
Name MAD1

Depends on the examiner and your confidence about your app. Theory questions come regardless of whether implemented in the app or not. Going through the viva FAQs in detail is enough for theory. Just chill!

Questions remembered
  1. • running of application + detailed explanation of models
  2. • what is SPA
  3. • difference between authentication vs authorization
  4. • what is lazy loading
  5. • what is RESTful
  6. • appointment workflow (availability -> booking -> completion/cancellation)
  7. • difference between PUT and POST
  8. • explanation of the app on the part they ask
  9. • difference between HTTP vs HTTPS
Vinay MAD1

Go through the available sheet. That's more than enough for the viva.

Questions remembered
  1. 1.Asked me to demo the app.
  2. My app allowed same vehicle number to be registered twice. Pointed out the flaw.
  3. Asked me to move the add parking lot button from bottom to top.
  4. Lazy Loading, db.Model, Authentication vs Authorization; ilike vs like
  5. Gave suggestions on new features that I can implement. Made comments on aesthetics and how to improve.
  6. Asked me to explain how cost is calculated. Informed that there should be a minimum parking lot charge if someone parks out vehicle before 1 hour.
  7. I asked for feedback and he informed that pagination can be implemented and scrolling can be avoided. Better design.
  8. Overall pretty chill guy.
sivani MAD1

Chill proctor very nice , will give you feedbacks to improve project in the end

Questions remembered
  1. 1)put vs post 2)spa 3)authentication vs authorization(also explain in code) 4)explain database part 5)inline,internal,external css 6)ilike operator is sql 7)search functionality explanation
Sheet response MAD1

Good chill Interview easily you can nail interview rember how u have implremented Search fn and database some basic concepts and params used in you code liken ilke lazy cascade_all backref if used

Questions remembered
  1. 1)Demo
  2. After Demo He wanted some changes like Add lot button was in end he wanted it to put it above all lots 3)In detail Disucsion about Database and Models created their relationship etc
  3. Explain Search Funcnality
  4. Diff btw PUT and POST
  5. SPA(Single Page Application) 7)Standalone Component 8)Component
  6. diff btw like and ilke Operator Then asked anything you would want to ask i asked about feedback and Improving Some funcnalites in my application
Sheet response MAD1

He is very calm and supportive, would give you suggestion at the end gave me to improve the ui of the application, Just know you code what and why you have done that .viva was completed in 25 mins

Questions remembered
  1. download submission
  2. app demo in between asked questions to shift the add lot button to the top , create lot , edit the maximum spots to 50 , from the user book a spot and release it
  3. asked to explain all the db models
  4. show the search function
  5. explain the search functionality
  6. what the post
  7. what are the http requests
  8. what is single page application
Sheet response MAD1

Shared viva questions from response sheet: App demo, explain cost,booking logic, explain models, explain search functionality, diff between put/patch, diff between ilike& like(i used in my app) single page application, standalone component,lazy loading

Questions remembered
  1. App demo, explain cost,booking logic, explain models, explain search functionality, diff between put/patch, diff between ilike& like(i used in my app) single page application, standalone component,lazy loading
RBK MAD1

Just go through the models and functions in routes, and for theory, refer to this docs.

Questions remembered
  1. Start with project presentation
  2. Asked to explain models (database) and routes functions)
  3. Authentication and authorization
  4. Lazy loading and eager loading (Examples of where we can use these)
  5. Single page application (SPA)
Chenchu Vinay Boga MAD1

* He is a chill guy, don't panic
* Just refer this doc and prepare the qns asked by him
* Mostly he will ask those qns only..
* Actually he joined 20min late in my case, that's the reason why he didn't ask for any code changes ig 😅

Questions remembered
  1. * He didn't ask for any code changes for me, but started the discussion with improvements u can do to u r application
  2. * He asked some doubts related to what customers, Professionals and Admin can do
  3. * He asked about the logic I used for calculating the rating of professionals and asked to do manual calculation on it like if customer 1 gives rating 4, customer 2 gives rating 5 then what is the overall rating...
  4. * At the end he asked qns about theory
  5. * Diff b/w authentication and authorisation
  6. * Diff b/w like and ilike ( I used them for search functionality )
  7. * Diff b/w PUT and POST
  8. * Types of CSS, which has highest priority
  9. * Explain u r database design
Sheet response MAD1

Cool proctor.
Just be clear with how you implemented the search functionality.

Questions remembered
  1. --> Asked introduction about project. --> Project demo. --> Asked how have you implemented search functionality. Theory Questions:
  2. What are Single Page Applications (SPAs)?
  3. Authentication vs Authorization.
  4. Inline CSS vs Internal CSS and which has higher precedence?
  5. PUT vs POST.
Sheet response MAD1

Chill Karo if u got this proctor...

Questions remembered
  1. Checksum
  2. Demo
  3. Explain Service and Service Professional from models.py
  4. What is the difference beween Inline CSS and Internal CSS
  5. What is the difference between Authentication and Authorisation?
  6. What is the difference between 'LIKE' and 'UNLIKE' operator with respect to Database?
  7. How did you implement search functionality in your project?
Mrunal Mahajan MAD1

Don't worry, he's very chill. He asked the same questions from the response sheet. If you don't know the answer to a question, just say so—he'll explain it himself.

Questions remembered
  1. Show the functionalites
  2. what is put post
  3. difference between Authorization and authentication
  4. Inline CSS and Internal CSS and what's the advantage of using internal css over inline?
  5. what is SPA ?
  6. what is lazy loading? Gave me suggestions for my code
Rittwik Bhowmick MAD1

Just read the above questions and know your code very well.. and try to explain your answer through your code.. like when he asked me about authentication and authorisation I just showed my code of auth required and admin required and explain that to him.he is a very good proctor he appreciated my project .. everything went good. All the best 👍

Questions remembered
  1. Create 2 new account one for sponsor and one for influencer.
  2. Create campaign and other things(like viva 1)
  3. Explain your database.
  4. Asked me to explain some code.
  5. What is SPA
  6. What is authentication and what is authorisation
  7. Explain Put post get
  8. Explain lazy loading ,uselist and backref .
  9. That's all..
Sheet response MAD1

Read the Google sheet questions well. Baki bhagwan bharose 🙂

Questions remembered
  1. show your project.
  2. sir gave some of his own opinions on my UX design but did not ask me to change anything in code ( kismat chahiye bhai kismat 🥳 )
  3. explained db models that I created.
  4. what is authentication and authorisation ?
  5. what is SPA ?
  6. what is lazy loading?
  7. what is inline and internal css and what's the advantage of using internal css ?
Sheet response MAD1

just know your code and it is fine learn the procotor specific theory

Questions remembered
  1. 1)show your project
  2. 2)what is put post
  3. 3)show edit functionality code what you have used there put or post
  4. 4)explain your models
  5. 5)primary key and foriegn key
  6. 6)Like AND unlike operator
  7. 7)diffrenece between Authorization and authentication
  8. 8)Inline CSS and Internal CSS
Siddhant MAD1

No need to get nervous with him, he’s pretty good.

Questions remembered
  1. Explain project
  2. Explain database schema
  3. What is lazy loading
  4. Difference between PATCH and PUT
  5. What is single page application
  6. Show function for a particular functionality (mine was rating of songs)
Aditya MAD1

If you have time perpair everthing that you have implimented. If you don't have time book you slot and see which viva person is assigned to you(eg: level_3_11) and refer to the prviour year question accrding to the proctor.....80% Q will be same.
Another advise impliment as many fetures as you can ....give the examinor no chance to pull out any mistakes.

Questions remembered
  1. 1)Explain you database
  2. 2)Name most used REST api method(PUT,POST,DELETE,GET) and explain them.
  3. 3)Difference between authentication and authorisation?
  4. 4)Cell spacing and cell padding.
  5. 5)Difference b/w PUT and POST
  6. 6)He did not made me code anthing(I feel special)
Deepa MAD1

Find all answers from previous year sheet and make your own version,most probably questions asked from them only

Questions remembered
  1. 1.Some code changes( mainly css change)
  2. 2.what is authentication?
  3. 3.What is authorization?
  4. 4.Cell padding, cell spacing.
  5. 5.Difference between put and post
  6. 6.Can we use put for creation ?
  7. 7.What has more preference inline cssand internal css?
  8. 8.Why incline has more preference?
Alexzendrene MAD1

Shared viva questions from response sheet: Proceed with I'd Then hash checksum check 1.Cell spacing and cell padding 2.Db models ( explain entities and referencing tables ) 3.Rest APIs 4.Types of rest APIs for http 5.Made some edits in project regarding display the quantity in inventory; Very detailed examination for project functions each and every (most of time) Delete Edit Add Checking the warning for cart If product is not in invent...

Questions remembered
  1. Proceed with I'd Then hash checksum check 1.Cell spacing and cell padding 2.Db models ( explain entities and referencing tables ) 3.Rest APIs 4.Types of rest APIs for http 5.Made some edits in project regarding display the quantity in inventory
  2. Very detailed examination for project functions each and every (most of time) Delete Edit Add Checking the warning for cart If product is not in inventory and we have added it.
  3. Checked schema
  4. Asked me regarding how you proceed with your models
  5. Cart db model.
  6. Billing summary which showed purchased products. Review :- nice and friendly proctor and finally told he has done his assessment and I have done great 😃
ShubhamG MAD1

Shared viva questions from response sheet: Asked to change some things in my code as per their preference...; Asked about GET and POST and what's the basic difference?; Why inline CSS has more weightage than external CSS during styling?

Questions remembered
  1. Asked to change some things in my code as per their preference...
  2. Asked about GET and POST and what's the basic difference?
  3. Why inline CSS has more weightage than external CSS during styling?
  4. Can you use a GET request to do the same work as a POST request?
  5. Why is POST more preferable for some things than GET?
Jeomon MAD1

Shared viva questions from response sheet: theroy; what is difference between authentication and authorization?; which all are http methods used in rest api?

Questions remembered
  1. theroy
  2. what is difference between authentication and authorization?
  3. which all are http methods used in rest api?
  4. what is difference between put and get request?
  5. what are different types of implementations of css and which has the highest priority?
  6. explain the DB schema.
  7. show all the features that you had.
  8. programming
  9. I have the expiry date property for product in the grocery store app he wants to add custom validation stating if expiry date older than today's date show error message.....proctor was nice person he allowed me to check the datetime documentation.
Anurag Kumar MAD1

Shared viva questions from response sheet: Project Functioning in Depth; 2)Restrict the booking to 10% of the total bookings or direct to another page with an error message; 3)Change in code so that not more than 8 characters length of the password can be used for a password under user registration; 4)Difference between arrays and lists; 5)lambda function; 6)What you used in the search option in the app(post or get); 7)define the post, ...

Questions remembered
  1. Project Functioning in Depth; 2)Restrict the booking to 10% of the total bookings or direct to another page with an error message; 3)Change in code so that not more than 8 characters length of the password can be used for a password under user registration; 4)Difference between arrays and lists; 5)lambda function; 6)What you used in the search option in the app(post or get); 7)define the post, put, and get methods ;
  2. Explain your database;
Sriya MAD1

Shared viva questions from response sheet: Incline css update form put get post delete max no of tickest=5

Questions remembered
  1. Incline css update form put get post delete max no of tickest=5
Jeevan Aji George MAD1

Shared viva questions from response sheet: Project details; Data structures from python - Arrays, Lists; HTTP methods- GET, PUT etc.

Questions remembered
  1. Project details
  2. Data structures from python - Arrays, Lists
  3. HTTP methods- GET, PUT etc.
  4. HTML - Styling

Approved viva sets

See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Demo of project and he will guide you on what to do
    Times asked 2
  2. 2
    Any questions i had for him No coding questions
    Times asked 1
Advice: extremely nice proctor, gave really good suggestions when asked how i can take this app to production level , the viva was quick less than viva 1
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Demo of specific functionalities
    Times asked 2
Advice: extremely nice proctor, gave really good suggestions when asked how can i improve
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    He was few minutes late, viva duration - 30 minutes
    Times asked 2
  2. 2
    Asked to download and run the app.
    Times asked 2
  3. 3
    Explain how search functionality is working.
    Times asked 2
  4. 4
    What is the difference between cell spacing and padding?
    Times asked 1
  5. 5
    What is SPA? No coding questions Said I did good and gave suggestions for improvement.
    Times asked 1
Advice: He is nice, usually asks same questions as previous ones.
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Viva 2 1.Asked to demo only few functionalities (login a s admin, add new trek staff, register new user, book a trek , login as trek staff, change the status of the trek)
    Times asked 1
  2. 2
    Explain db table structure
    Times asked 1
  3. 3
    Demo the export csv functionality
    Times asked 1
  4. 4
    Explain the code for search option
    Times asked 2
  5. 5
    What is ilike and wildcard %
    Times asked 2
  6. 6
    What is spa, authentication and authorisation, vue js
    Times asked 1
Advice: Very calm and supportive
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Viva 2 (10-11 PM) Level3_11
    Times asked 2
  2. 2
    -Joined 25 min late
    Times asked 2
  3. 3
    -Show me your ID
    Times asked 4
  4. 4
    -run the project
    Times asked 2
  5. 5
    -one by one checked functionality what he needed and mailhog also
    Times asked 4
  6. 6
    -And gives little bit suggestion to improve my proj...
    Times asked 2
  7. 7
    -And asked me to ask any questions if I want and done
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Id card 2.add doctor add department and patient
    Times asked 2
Advice: He is cool joined 5 mins early and just go through the sheet
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Show ID Card
    Times asked 7
  2. 2
    Download project from portal and run
    Times asked 2
  3. 3
    Asked for demo of specific things; not the whole application
    Times asked 1
  4. 4
    Show search functionality
    Times asked 2
  5. 5
    Explain all the db models
    Times asked 1
  6. 6
    What is ilike? How is it different from like?
    Times asked 2
  7. 7
    No coding questions asked
    Times asked 4
  8. 8
    Gave feedback for the application
    Times asked 2
Advice: Chill proctor; nothing much to worry about
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    NEED NOT BE IN ORDER (Based on Placement Portal App) Level 2:
    Times asked 2
  2. 2
    Create a new company and create a drive with it. Then make a new student and apply for that.
    Times asked 2
  3. 3
    Explain me your database file and structure.
    Times asked 2
  4. 4
    Show any update function. (I showed him what we can update the application deadline)
    Times asked 2
  5. 5
    What is authentication. Show me where you have used it.
    Times asked 2
  6. 6
    Show me search function. Asked me to explain what '%' does in search.
    Times asked 1
  7. 7
    Difference between like and ilike. He said viva is done so I though that he thinks I have not made backend jobs. So I told him that he didn't check that and then I showed him.
    Times asked 1
Advice: Really nice proctor. Finished my viva in 15 mins. Then I said about backend jobs which took extra 7, so total 22 mins, shorter than level 1. Also, for some reason the mail didn't go but I showed him the older ones. He just asked me to fix it. With him be confident. Go through the sheet. Some of his questions are repetative. One thing I have noticed is don't give straight one line answers. Explain your answers, if possible with your code. Like I showed him put and patch in my code, or opened the index.html when asked about SPA. I feel it build trust.
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Ask to change some button position using flex CSS property.
    Times asked 2
  2. 2
    Ask to explain search API.
    Times asked 2
  3. 3
    What is the difference between ilike and like?
    Times asked 2
  4. 4
    What is Authorization and Authentication?
    Times asked 1
  5. 5
    Advantage of JavaScript. Theory questions are same like previously asked. Gave some suggestion about project improvement.
    Times asked 2
Advice: Very good proctor. Need some understanding of basic code , he may ask to explain one of the API and theory questions mostly same as the previous.
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Asked me work on both admin and user side
    Times asked 2
  2. 2
    Asked me to explain my models
    Times asked 1
  3. 3
    Asked me to explain a route, how it is stored in db
    Times asked 2
  4. 4
    what are all the ways to declare a variable in JS
    Times asked 2
  5. 5
    He didn't ask me to code.
    Times asked 2
Advice: Chill proctor. you are safe
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Explain all modes and relationship
    Times asked 1
  2. 2
    In Vue components, asked the flow of computed properties
    Times asked 2
  3. 3
    In backed , he asked usage for trim, .tolowercase(), authentication. Celery
    Times asked 2
  4. 4
    Spa, how it affects performance. (Quoted my project as example) Webhooks.
    Times asked 1
  5. 5
    He shared improvement tips on the project.
    Times asked 2
  6. 6
    Code change very minor(just shift a button from bottom to top in Vue template while preserve its working. I did it by putting in a div tag inside form tags)
    Times asked 2
Advice: Overall nice proctor, positive thinking and motivate to answer by providing hints. Put more knowledge on theory rather than practice if you get this proctor.Good luck for my peers.
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    What is SMTP
    Times asked 1
  2. 2
    Explain webhooks
    Times asked 2
  3. 3
    Explain SPA
    Times asked 1
  4. 4
    Explain lazy loading No coding asked
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Show demo
    Times asked 11
  2. 2
    Show admin login
    Times asked 2
  3. 3
    tells you improvements that can be made
    Times asked 2
  4. 4
    show parking spots and user management
    Times asked 2
  5. 5
    show code for search funtionality
    Times asked 2
  6. 6
    run celery jobs
    Times asked 2
  7. 7
    what is celery
    Times asked 3
  8. 8
    what is internal css
    Times asked 2
  9. 9
    what is webhooks
    Times asked 2
  10. 10
    gives good suggestions to be implemented
    Times asked 2
Advice: may or may not ask changes or maybe even ask how to do it , you have to explain verbally how will you proceed.
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Checked whether the graph and scores are displaying correctly or not after taking the quiz
    Times asked 2
  2. 2
    Explain search functionality implemented
    Times asked 1
  3. 3
    Single function component
    Times asked 4
  4. 4
    Asked how would I implement if quiz has to be displayed only to users with particular qualification
    Times asked 2
  5. 5
    No code changes asked
    Times asked 2
  6. 6
    At the end he gave some more suggestions on what other features I can implement in my project
    Times asked 2
  7. 7
    Viva done in 30min
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Demonstration of the project (Just 2-3 functionalities. Then he moved to theory)
    Times asked 2
  2. 2
    What is SPAs
    Times asked 2
Advice: Prepare your theory well. The level2 is meant for how much you know the concepts.
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Household Services: He asked me to run my application, and he started giving feedback on how to improve each functionality that I showed. Then he asked me to explain my db tables and their structure. Then he asked me 3 questions:
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Checksum
    Times asked 5
  2. 2
    Start the App
    Times asked 2
  3. 3
    Demo of Librarian screen
    Times asked 2
  4. 4
    Demo of User screen
    Times asked 1
  5. 5
    How the Book and Sections models are implemented
    Times asked 2
  6. 6
    How rating is updated in the backend
    Times asked 2
  7. 7
    Gave Good inputs on how the UI can be made better and the general end user expectations from a UI
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Delete vs truncate.
    Times asked 2
  2. 2
    Child components.
    Times asked 2
  3. 3
    ( The proctor was very calm and helpful ,when I was stuck at a point , he suggested me how to do it.)
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    The viva was between easy to moderate.
    Times asked 2
  2. 2
    The proctor first asked to demonstrate the app, then asked some questions from app(mostly core functionalities, even sometimes deep functionalities)
    Times asked 2
  3. 3
    Most of the questions were repeated from before like:
    Times asked 2
  4. 4
    Why is POST idempotent?
    Times asked 2
  5. 5
    etc..
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Questions(I remember):
    Times asked 2
  2. 2
    Internal vs inline css
    Times asked 2
  3. 3
    Left join
    Times asked 2
  4. 4
    how you implemented search functionality
    Times asked 2
  5. 5
    Explain relationship between book and category tables
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    My Project: Music Streaming App
    Times asked 2
  2. 2
    Demonstration of the app (a very thorough demo, explaining every functionality)
    Times asked 2
  3. 3
    Explain the working of caching, search function and filters
    Times asked 2
  4. 4
    Explain the working of music player and streaming of audio
    Times asked 2
  5. 5
    Admin Page and it's functions
    Times asked 2
  6. 6
    What are the most commonly used HTTP verbs in a Restful Application
    Times asked 2
  7. 7
    Decorators
    Times asked 2
  8. 8
    Why did I choose music app instead of grocery store
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    what is SQL alchemy?
    Times asked 2
  2. 2
    Is the MS SQL server connectable with SQL Alchemy?
    Times asked 1
  3. 3
    How long did it take to create this app?
    Times asked 2
  4. 4
    He told me to limit the price of the products to prevent them from going beyond a certain range.
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    1.cell spacing and cell padding related to css
    Times asked 2
  2. 2
    Spa, pwa
    Times asked 1
  3. 3
    Checked if it shows houseful when the all tickets are booked both in backed And frontend.
    Times asked 2
  4. 4
    Http verbs and explain them
    Times asked 2
  5. 5
    How did you implement search for theaters and shows (backend)
    Times asked 2
  6. 6
    How to implement lazy loading in vue (asked syntax)
    Times asked 2
  7. 7
    Is your application spa or multi page.
    Times asked 1
  8. 8
    Difference between authentication and authorisation. And gave some feedback on the project.
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Demonstrate app, he found a Bug asked to fix it there,
    Times asked 2
  2. 2
    2.) Same questions as all level3_11 above
    Times asked 2
  3. 3
    SPA, lazy loading, multi-page application, post,put,patch and done.
    Times asked 1
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Do you know what SPA is?
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    Demo of your application
    Times asked 2
  2. 2
    Checked if the modification made to show details is reflected in the user page.
    Times asked 2
  3. 3
    POST and GET
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    (1) Asked to show working function of app
    Times asked 2
  2. 2
    (2) venue and show capacity constraint (Eg. 100 seats in venue then for show inside that venue we cant allot 120 seats)
    Times asked 2
  3. 3
    (4) SPA
    Times asked 2
  4. 4
    (5) single page and multipage difference
    Times asked 2
  5. 5
    (8) Implement constraint on password length (Frontend)
    Times asked 2
  6. 6
    (10) Can we use POST instead of PUT
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    wanted to know my thought process on how i would implement and what changes will i make if i had to create only one common table between user and admin
    Times asked 2
See reviews Level3_11 MAD2 Level 3
Copy set link
  1. 1
    while showing the admin side of the page asked me to add set an alert message when admin tries to allot more seats to a show in a venue than the allotted seats for that particular venue (even though backend was not letting the admin book more seats than possible)
    Times asked 2
  2. 2
    asked me to change the blue coloured button to green
    Times asked 2
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    He is very patient, cool & friendly proctor.
    Times asked 1
    Official solution

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

  2. 2
    - now in coding part he asked me to explain the database and the controllers
    Times asked 1
    Official solution

    SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.

  3. 3
    - Not even single task was given to do code or change code.
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  4. 4
    - finally he said assessment is over and asked whether I have any questions to him. I asked about the presentation of the project I did and the corrections to be made in my app. He said correction in the way I presented and features to be added in the app
    Times asked 1
    Official solution

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

  5. 5
    Duration was around 35 mins.
    Times asked 1
    Official solution

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

Advice: The response document was highly helpful for this proctor. I suggest that, those who get this proctor, to just go through the things mentioned in the response document about him in the past. He repeats the viva process exactly the same as mentioned in it.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Explain the overall project
    Times asked 1
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  2. 2
    Create a new trek staff account and approve it as admin.
    Times asked 1
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

  3. 3
    Create a trekker account and login then book a trek.
    Times asked 1
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

  4. 4
    Then asked me to explain the search mechanism.
    Times asked 1
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  5. 5
    ilike vs like
    Times asked 2
    Official solution

    SimpleLIKE case-sensitive Postgres. ILIKE insensitive. SQLite LIKE often insensitive.

    Search use ilike.

    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: Venue.name.ilike(f'%{q}%').

    Project example: Venue.name.ilike(f'%{q}%').

Advice: This proctor doesn't focus much on the code writing or code change in viva, only theoritical questions.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    • show id, download project and run
    Times asked 1
    Official solution

    SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

    Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

  2. 2
    • login as admin, create a trek
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    • register and login as staff and update trek status
    Times asked 1
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

  4. 4
    • register as user and book a trek
    Times asked 1
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

  5. 5
    • asked basic ques related to functionalities of my app
    Times asked 1
    Official solution

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

  6. 6
    • difference between primary key and foreign key
    Times asked 1
    Official solution

    SimplePrimary key row ka unique identity — usually id Integer autoincrement.

    Example

    id = db.Column(db.Integer, primary_key=True)
  7. 7
    • asked if i had any ques for him and i asked for improvement advice for my app and then he suggested improvements
    Times asked 1
    Official solution

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

  8. 8
    • viva done in like 30 mins
    Times asked 1
    Official solution

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

Advice: be well with your code and project workflow, he focuses a bit more on the UI of our application
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    He came 5-7 mins late
    Times asked 1
    Official solution

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

  2. 2
    Asked for my id and demo
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    He went off for 4 mins cuz he got a call ig
    Times asked 1
    Official solution

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

  4. 4
    No coding tasks. Very chill. The viva was only 15 mins or less than that. Go through the ques he asked previously
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

Advice: He's super chill. And he will repeat his questions if you didn't hear it properly. Focus on SPA. Just go through the questions he asked prev and there u go~
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Honestly, this was probably the chillest guy you can ever get. Very calm, very predictable, and the whole vibe was super relaxed.
    Times asked 1
    Official solution

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

  2. 2
    As always… he came around 15 minutes late 😭
    Times asked 1
    Official solution

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

  3. 3
    He began with the project demo and asked for simple demonstration of the basic functionalities. Nothing tricky, just normal flow of the project and explanation.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  4. 4
    None.
    Times asked 1
    Official solution

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

  5. 5
    Literally no code changes, no “write this route,” no debugging, nothing.
    Times asked 1
    Official solution

    SimpleLive Flask coding: chhota route likho, save, browser/curl se test. Syntax error terminal mein padho.

    Example

    @app.route('/ping')
def ping():
    return jsonify(ok=True)

@app.route('/even/<int:n>')
def even(n):
    return 'even' if n % 2 == 0 else 'odd'
  6. 6
    And the funny part is I was prepared like crazy. IT IS WHAT IT IS 🤷‍♂️
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: CHILL KARO
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    4)asked to shift my create_drive button to right side(in company dashboard)
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  2. 2
    5)told me what what things should i add in my application
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  3. 3
    6)asked my to explain app.py
    Times asked 1
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  4. 4
    At last, he said you are done with viva, if you have any doubts you can ask...so i asked what things should i add in my app to make it more impactful....he told me what to add....and then ended.
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

Advice: he is a very chill proctor.....questions are mostly same as previous ones , you are lucky if you got this proctor
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    He came 20 mins late but the POD came and told to wait for him to come.
    Times asked 1
    Official solution

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

  2. 2
    Asked to demo the project fully and asked small small questions in between like asking functionality
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    Show the search operation for filtering and explain it
    Times asked 1
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
Advice: Be confident in your code and explain everything to the best you can. He will listen properly and understand your code. Chill proctor. Learn your theory well. He also gives very nice tips and ways to better clean up your code and ways to implement more functionality. Listen to his tips coz they're very useful. Very nice proctor.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    MAD 2
    Times asked 1
    Official solution

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

Advice: Know your code well
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    download from portal and start app
    Times asked 1
    Official solution

    SimpleExaminer portal wala submitted ZIP chahta hai. Local extra changes mat dikhana.

    Suggested flow1) Portal ZIP download
    2) Extract
    3) venv + pip install -r requirements.txt
    4) flask run / python app.py

  2. 2
    demostrated portal functionalities
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    Explain model.py
    Times asked 1
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  4. 4
    Suggested some improvements
    Times asked 1
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    1)Show ID
    Times asked 1
    Official solution

    SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

    Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

  2. 2
    2)Run the application
    Times asked 1
    Official solution

    Simplevenv activate → dependencies → DB create/migrate → flask run. Browser pe localhost dikhao.

    Example

    python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
flask run
  3. 3
    3)Checks almost all functionalities
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  4. 4
    4) Suggests Changes that will make the application better
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  5. 5
    5)ilike operation
    Times asked 1
    Official solution

    SimpleLIKE case-sensitive Postgres. ILIKE insensitive. SQLite LIKE often insensitive.

    Search use ilike.

    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: Venue.name.ilike(f'%{q}%').

    Project example: Venue.name.ilike(f'%{q}%').

  6. 6
    6)Lazy evaluation
    Times asked 1
    Official solution

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

  7. 7
    13)and few more basic question in total around 10-12 questions.
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  8. 8
    14) After viva asks if you have any questions for him.
    Times asked 1
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    • APP PRESENTATION SHORT(Suggested improvements)
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  2. 2
    • Placement Drive Creation flow in the app
    Times asked 1
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

  3. 3
    • ilike in SQALCHEMY
    Times asked 1
    Official solution

    SimpleLIKE case-sensitive Postgres. ILIKE insensitive. SQLite LIKE often insensitive.

    Search use ilike.

    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: Venue.name.ilike(f'%{q}%').

    Project example: Venue.name.ilike(f'%{q}%').

  4. 4
    • Single page apps
    Times asked 1
    Official solution

    SimpleMAD1 typical: Browser → Flask routes → validate/auth → SQLAlchemy → SQLite → Jinja response.

    Suggested flowRequest → Route → Auth check → DB → render_template / redirect

Advice: Guy is very chill, will make you comfortable. Be confident and prepare these ones especially
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    LEVEL II Viva:
    Times asked 1
    Official solution

    SimpleLevel = viva difficulty band. Level 1 usually demo + basics; higher pe live coding + deeper theory.

    Viva tipJo level assign hai uske hisaab se demo + theory ready rakho.

  2. 2
    App Demo (in between questions on features of app)
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

Advice: Cool guy, answer what you know, be confident, be clear with your code (what and where)
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Asked for IIT-M ID
    Times asked 1
    Official solution

    SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

    Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

  2. 2
    Asked me to run the project using the downloaded file. (Venv creation, requirements installation, everything one needs to do)
    Times asked 1
    Official solution

    SimpleVirtualenv isolated Python env — project deps system Python ko nahi bigaadte.

    Example

    python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
  3. 3
    Goes through the project step by step same as level 1.
    Times asked 1
    Official solution

    SimpleLevel = viva difficulty band. Level 1 usually demo + basics; higher pe live coding + deeper theory.

    Viva tipJo level assign hai uske hisaab se demo + theory ready rakho.

  4. 4
    Gives suggestions for improvements in the project.
    Times asked 1
    Official solution

    SimpleImprove ideas: caching, better validation, tests, pagination, email reminders, accessibility, mobile UI, logging.

    Viva tip1-2 concrete features bolo jo time milne pe add karte — vague 'AI' mat.

  5. 5
    Said he was done with the assessment and asked whether I have any questions or not. I asked how I did on the viva. He said I just need to implement the suggestions he gave to make this a full fledged working example.
    Times asked 1
    Official solution

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

  6. 6
    Did not ask to do any code changes.
    Times asked 1
    Official solution

    SimpleLive Flask coding: chhota route likho, save, browser/curl se test. Syntax error terminal mein padho.

    Example

    @app.route('/ping')
def ping():
    return jsonify(ok=True)

@app.route('/even/<int:n>')
def even(n):
    return 'even' if n % 2 == 0 else 'odd'
Advice: Prep well according to what your proctor has asked in the past.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Viva lvl 2:
    Times asked 1
    Official solution

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

  2. 2
    -Showed id
    Times asked 1
    Official solution

    SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

    Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

  3. 3
    -showed app demonstration
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  4. 4
    -explain doctor create route
    Times asked 1
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

Advice: Chill, very easy, easier then level 1,no code changes
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Asked to show the working of the webapp.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    Asked to create, update a doctor and set their availablity for the week.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    Asked to Book an appointment for the same doctor.
    Times asked 1
    Official solution

    SimpleSame slot twice 400. Two users race. Approval workflow. Book appointment verify edges.

    Demo fail then success.

    Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).

    4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.

    Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.

    Project example: book route checks.

    Project example: book route checks.

  4. 4
    Checked if we could book more than one appointment for a single day.
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  5. 5
    Asked to explain my update doctor route.
    Times asked 1
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

Advice: Chill Proctor, Didn't ask for any code change. was giving me feedback in between the explaination like what more could i do to make it more user friendly.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    • running of application + detailed explanation of models
    Times asked 1
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  2. 2
    • what is RESTful
    Times asked 1
    Official solution

    SimpleREST: resources + HTTP verbs. GET read, POST create, PUT/PATCH update, DELETE remove. Stateless ideal.

  3. 3
    • appointment workflow (availability -> booking -> completion/cancellation)
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  4. 4
    • explanation of the app on the part they ask
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: Depends on the examiner and your confidence about your app. Theory questions come regardless of whether implemented in the app or not. Going through the viva FAQs in detail is enough for theory. Just chill!
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    My app allowed same vehicle number to be registered twice. Pointed out the flaw.
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  2. 2
    Asked me to move the add parking lot button from bottom to top.
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  3. 3
    Gave suggestions on new features that I can implement. Made comments on aesthetics and how to improve.
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  4. 4
    Asked me to explain how cost is calculated. Informed that there should be a minimum parking lot charge if someone parks out vehicle before 1 hour.
    Times asked 1
    Official solution

    SimpleORM = Object Relational Mapping. Tables → Python classes. Raw SQL kam likhte ho.

    Example

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

User.query.get(5)  # SELECT ... WHERE id=5
  5. 5
    I asked for feedback and he informed that pagination can be implemented and scrolling can be avoided. Better design.
    Times asked 1
    Official solution

    SimplePagination badi list ko pages mein todta hai — offset/limit ya Flask-SQLAlchemy paginate().

    Example

    page = request.args.get('page', 1, type=int)
pagination = Lot.query.paginate(page=page, per_page=10)
  6. 6
    Overall pretty chill guy.
    Times asked 1
    Official solution

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

Advice: Go through the available sheet. That's more than enough for the viva.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    1)Demo
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    Explain Search Funcnality
    Times asked 1
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  3. 3
    diff btw like and ilke Operator Then asked anything you would want to ask i asked about feedback and Improving Some funcnalites in my application
    Times asked 1
    Official solution

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

Advice: Good chill Interview easily you can nail interview rember how u have implremented Search fn and database some basic concepts and params used in you code liken ilke lazy cascade_all backref if used
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    download submission
    Times asked 1
    Official solution

    SimpleExaminer portal wala submitted ZIP chahta hai. Local extra changes mat dikhana.

    Suggested flow1) Portal ZIP download
    2) Extract
    3) venv + pip install -r requirements.txt
    4) flask run / python app.py

  2. 2
    app demo in between asked questions to shift the add lot button to the top , create lot , edit the maximum spots to 50 , from the user book a spot and release it
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    show the search function
    Times asked 1
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  4. 4
    what are the http requests
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: He is very calm and supportive, would give you suggestion at the end gave me to improve the ui of the application, Just know you code what and why you have done that .viva was completed in 25 mins
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Start with project presentation
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: Just go through the models and functions in routes, and for theory, refer to this docs.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    * He asked some doubts related to what customers, Professionals and Admin can do
    Times asked 1
    Official solution

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

  2. 2
    * He asked about the logic I used for calculating the rating of professionals and asked to do manual calculation on it like if customer 1 gives rating 4, customer 2 gives rating 5 then what is the overall rating...
    Times asked 1
    Official solution

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

  3. 3
    * At the end he asked qns about theory
    Times asked 1
    Official solution

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

  4. 4
    * Diff b/w authentication and authorisation
    Times asked 1
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
  5. 5
    * Diff b/w like and ilike ( I used them for search functionality )
    Times asked 1
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  6. 6
    * Diff b/w PUT and POST
    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.

Advice: * He is a chill guy, don't panic * Just refer this doc and prepare the qns asked by him * Mostly he will ask those qns only.. * Actually he joined 20min late in my case, that's the reason why he didn't ask for any code changes ig 😅
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    PUT vs POST.
    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.

Advice: Cool proctor. Just be clear with how you implemented the search functionality.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    How did you implement search functionality in your project?
    Times asked 1
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
Advice: Chill Karo if u got this proctor...
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Show the functionalites
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

Advice: Don't worry, he's very chill. He asked the same questions from the response sheet. If you don't know the answer to a question, just say so—he'll explain it himself.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Create 2 new account one for sponsor and one for influencer.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    Create campaign and other things(like viva 1)
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    Asked me to explain some code.
    Times asked 1
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  4. 4
    That's all..
    Times asked 1
    Official solution

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

Advice: Just read the above questions and know your code very well.. and try to explain your answer through your code.. like when he asked me about authentication and authorisation I just showed my code of auth required and admin required and explain that to him.he is a very good proctor he appreciated my project .. everything went good. All the best 👍
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    sir gave some of his own opinions on my UX design but did not ask me to change anything in code ( kismat chahiye bhai kismat 🥳 )
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  2. 2
    explained db models that I created.
    Times asked 1
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  3. 3
    what is authentication and authorisation ?
    Times asked 1
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
Advice: Read the Google sheet questions well. Baki bhagwan bharose 🙂
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    1)show your project
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    3)show edit functionality code what you have used there put or post
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    5)primary key and foriegn key
    Times asked 1
    Official solution

    SimplePrimary key row ka unique identity — usually id Integer autoincrement.

    Example

    id = db.Column(db.Integer, primary_key=True)
  4. 4
    6)Like AND unlike operator
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: just know your code and it is fine learn the procotor specific theory
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Show function for a particular functionality (mine was rating of songs)
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

Advice: No need to get nervous with him, he’s pretty good.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    1)Explain you database
    Times asked 1
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  2. 2
    5)Difference b/w PUT and POST
    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.

  3. 3
    6)He did not made me code anthing(I feel special)
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: If you have time perpair everthing that you have implimented. If you don't have time book you slot and see which viva person is assigned to you(eg: level_3_11) and refer to the prviour year question accrding to the proctor.....80% Q will be same. Another advise impliment as many fetures as you can ....give the examinor no chance to pull out any mistakes.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    1.Some code changes( mainly css change)
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  2. 2
    3.What is authorization?
    Times asked 1
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
  3. 3
    6.Can we use put for creation ?
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  4. 4
    8.Why incline has more preference?
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: Find all answers from previous year sheet and make your own version,most probably questions asked from them only
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Very detailed examination for project functions each and every (most of time) Delete Edit Add Checking the warning for cart If product is not in inventory and we have added it.
    Times asked 1
    Official solution

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

  2. 2
    Checked schema
    Times asked 1
    Official solution

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

  3. 3
    Asked me regarding how you proceed with your models
    Times asked 1
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  4. 4
    Cart db model.
    Times asked 1
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  5. 5
    Billing summary which showed purchased products. Review :- nice and friendly proctor and finally told he has done his assessment and I have done great 😃
    Times asked 1
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Asked to change some things in my code as per their preference...
    Times asked 1
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  2. 2
    Can you use a GET request to do the same work as a POST request?
    Times asked 1
    Official solution

    SimpleGET data read/show karta hai (idempotent). POST create/submit karta hai (form).

    Example

    @app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        # validate + session
        ...
    return render_template('login.html')
  3. 3
    Why is POST more preferable for some things than GET?
    Times asked 1
    Official solution

    SimpleGET data read/show karta hai (idempotent). POST create/submit karta hai (form).

    Example

    @app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        # validate + session
        ...
    return render_template('login.html')
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    theroy
    Times asked 1
    Official solution

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

  2. 2
    which all are http methods used in rest api?
    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.

  3. 3
    what are different types of implementations of css and which has the highest priority?
    Times asked 1
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  4. 4
    show all the features that you had.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  5. 5
    programming
    Times asked 1
    Official solution

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

  6. 6
    I have the expiry date property for product in the grocery store app he wants to add custom validation stating if expiry date older than today's date show error message.....proctor was nice person he allowed me to check the datetime documentation.
    Times asked 1
    Official solution

    SimpleValidation = input rules: required, email format, length, unique. Frontend UX, backend security — dono.

    Example

    if not email or '@' not in email:
    flash('Invalid email')
    return redirect(request.url)
if User.query.filter_by(email=email).first():
    flash('Email taken')
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Incline css update form put get post delete max no of tickest=5
    Times asked 1
    Official solution

    SimpleGET data read/show karta hai (idempotent). POST create/submit karta hai (form).

    Example

    @app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        # validate + session
        ...
    return render_template('login.html')
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Project details
    Times asked 1
    Official solution

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

  2. 2
    HTML - Styling
    Times asked 1
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Demo of project and he will guide you on what to do
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    What is SQL
    Times asked 1
    Official solution

    SimpleConstraints rules hain jo galat data rok te hain. Referential integrity FK valid parent ko point kare.

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

Advice: extremely nice proctor, gave really good suggestions when asked how i can take this app to production level , the viva was quick less than viva 1
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Demo of specific functionalities
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    What is vue js?
    Times asked 1
    Official solution

    SimpleVue.js frontend framework — reactive UI components. MAD2 mein common, MAD1 optional.

    Component: reusable UI (Navbar.vue) + data + template.
    Props: parent → child data. Child → parent: $emit('update', val).
    Slots: parent child ke andar extra HTML daal sakta hai.
    Lifecycle: created (data setup), mounted (DOM ready — API call), updated, unmounted.
    v-model two-way bind. Vue Router SPA routes (routes.js). Vuex/Pinia global state; mutations sync change, actions async.
    Standalone component: khud ke saath compile, parent register kam.

Advice: extremely nice proctor, gave really good suggestions when asked how can i improve
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    He was few minutes late, viva duration - 30 minutes
    Times asked 2
    Official solution

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

  2. 2
    Asked to download and run the app.
    Times asked 2
    Official solution

    Simplevenv activate → dependencies → DB create/migrate → flask run. Browser pe localhost dikhao.

    Example

    python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
flask run
  3. 3
    Explain how search functionality is working.
    Times asked 2
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
Advice: He is nice, usually asks same questions as previous ones.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Explain the code for search option
    Times asked 2
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  2. 2
    What is ilike and wildcard %
    Times asked 2
    Official solution

    SimpleLIKE case-sensitive Postgres. ILIKE insensitive. SQLite LIKE often insensitive.

    Search use ilike.

    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: Venue.name.ilike(f'%{q}%').

    Project example: Venue.name.ilike(f'%{q}%').

Advice: Very calm and supportive
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Viva 2 (10-11 PM) Level3_11
    Times asked 2
    Official solution

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

  2. 2
    -Joined 25 min late
    Times asked 2
    Official solution

    SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

    Example

    db.session.query(Booking, User).join(User).filter(User.id == uid).all()
  3. 3
    -Show me your ID
    Times asked 4
    Official solution

    SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

    Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

  4. 4
    -one by one checked functionality what he needed and mailhog also
    Times asked 4
    Official solution

    SimpleMailHog local fake post office — email internet pe nahi jaata, browser mein dikhta hai.

    SMTP 1025, Web UI 8025. Viva demo gold. Credentials nahi.

    Real Gmail SMTP student accounts pe block common — MailHog safer.

    Flask-Mail / SMTP se mail. Local MailHog fake server: SMTP 1025, UI 8025 — internet nahi, viva safe.

    Asli send Celery task mein, request thread mein nahi. Beat 6pm reminder, export ke baad CSV attach optional.

    MAIL_SERVER localhost demo. Gmail SMTP student account pe block common. Body mein user name personalization examiner dekhta hai.

    Example

    MAIL_SERVER=localhost
MAIL_PORT=1025
# http://localhost:8025

    Project example: Reminder task → MailHog list → HTML body user name ke saath.

  5. 5
    -And gives little bit suggestion to improve my proj...
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  6. 6
    -And asked me to ask any questions if I want and done
    Times asked 2
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Id card 2.add doctor add department and patient
    Times asked 2
    Official solution

    SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

    Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

Advice: He is cool joined 5 mins early and just go through the sheet
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Show ID Card
    Times asked 7
    Official solution

    SimpleCamera pe clearly IITM/college ID dikhao — naam photo match.

    Pehle se ID haath mein rakho. Glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.

  2. 2
    Download project from portal and run
    Times asked 2
    Official solution

    SimpleExaminer portal wala submitted ZIP chahta hai. Local extra changes mat dikhana.

    Suggested flow1) Portal ZIP download
    2) Extract
    3) venv + pip install -r requirements.txt
    4) flask run / python app.py

  3. 3
    What is ilike? How is it different from like?
    Times asked 2
    Official solution

    SimpleLIKE case-sensitive Postgres. ILIKE insensitive. SQLite LIKE often insensitive.

    Search use ilike.

    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: Venue.name.ilike(f'%{q}%').

    Project example: Venue.name.ilike(f'%{q}%').

  4. 4
    No coding questions asked
    Times asked 4
    Official solution

    SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.

  5. 5
    Gave feedback for the application
    Times asked 2
    Official solution

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

Advice: Chill proctor; nothing much to worry about
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    NEED NOT BE IN ORDER (Based on Placement Portal App) Level 2:
    Times asked 2
    Official solution

    SimpleLevel = viva difficulty band. Level 1 usually demo + basics; higher pe live coding + deeper theory.

    Viva tipJo level assign hai uske hisaab se demo + theory ready rakho.

  2. 2
    Create a new company and create a drive with it. Then make a new student and apply for that.
    Times asked 2
    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. 3
    Explain me your database file and structure.
    Times asked 2
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  4. 4
    Show any update function. (I showed him what we can update the application deadline)
    Times asked 2
    Official solution

    SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.

    Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.

    Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search + charts
    6) CSV export / email job
    7) Logout

    Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.

    Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.

  5. 5
    What is authentication. Show me where you have used it.
    Times asked 2
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
Advice: Really nice proctor. Finished my viva in 15 mins. Then I said about backend jobs which took extra 7, so total 22 mins, shorter than level 1. Also, for some reason the mail didn't go but I showed him the older ones. He just asked me to fix it. With him be confident. Go through the sheet. Some of his questions are repetative. One thing I have noticed is don't give straight one line answers. Explain your answers, if possible with your code. Like I showed him put and patch in my code, or opened the index.html when asked about SPA. I feel it build trust.
See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    Level 2 ...to change navbar and button position ,lazy loading ,cell spacing nd padding , Spa , explain models of ur db , explain a route and if u can improve it(just give ans without coding)
    Times asked 1
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
Advice: very good proctor , just follow the sheet and all set
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Ask to change some button position using flex CSS property.
    Times asked 2
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  2. 2
    Ask to explain search API.
    Times asked 2
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  3. 3
    What is the difference between ilike and like?
    Times asked 2
    Official solution

    SimpleLIKE case-sensitive Postgres. ILIKE insensitive. SQLite LIKE often insensitive.

    Search use ilike.

    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: Venue.name.ilike(f'%{q}%').

    Project example: Venue.name.ilike(f'%{q}%').

  4. 4
    Advantage of JavaScript. Theory questions are same like previously asked. Gave some suggestion about project improvement.
    Times asked 2
    Official solution

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

Advice: Very good proctor. Need some understanding of basic code , he may ask to explain one of the API and theory questions mostly same as the previous.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Asked me work on both admin and user side
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    Asked me to explain a route, how it is stored in db
    Times asked 2
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  3. 3
    what are all the ways to declare a variable in JS
    Times asked 2
    Official solution

    SimpleJS variables: var (function scope, old), let (block), const (block, reassign nahi).

    Example

    let count = 0;
const API = '/api';
  4. 4
    He didn't ask me to code.
    Times asked 2
    Official solution

    SimpleLive Flask coding: chhota route likho, save, browser/curl se test. Syntax error terminal mein padho.

    Example

    @app.route('/ping')
def ping():
    return jsonify(ok=True)

@app.route('/even/<int:n>')
def even(n):
    return 'even' if n % 2 == 0 else 'odd'
Advice: Chill proctor. you are safe
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    In Vue components, asked the flow of computed properties
    Times asked 2
    Official solution

    SimpleVue = UI ka smart assistant. Data badlo, screen khud update. MAD1 Jinja har click pe naya HTML.

    Progressive frontend framework. Components, reactivity, directives.

    MAD2 SPA: ek index.html, Vue Router pages, Flask sirf JSON.

    Fayde: easy, SFC, docs. Vs React: templates HTML-like, course sikhata hai. Vs plain JS: baar-baar DOM mat chhedo.

    Example

    <!-- HelloWorld.vue -->
<template>
  <h1>{{ msg }}</h1>
</template>
<script>
export default { data() { return { msg: 'Hello' } } }
</script>

    Project example: Navbar.vue + views (Login, Dashboard). data() / setup() reactive. fetch APIs.

    Viva tipFayde: easy, SFC, reactivity. Vs React: chhota learning curve. Vs plain JS: UI state auto-update.

  2. 2
    In backed , he asked usage for trim, .tolowercase(), authentication. Celery
    Times asked 2
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
  3. 3
    He shared improvement tips on the project.
    Times asked 2
    Official solution

    SimpleImprove ideas: caching, better validation, tests, pagination, email reminders, accessibility, mobile UI, logging.

    Viva tip1-2 concrete features bolo jo time milne pe add karte — vague 'AI' mat.

  4. 4
    Code change very minor(just shift a button from bottom to top in Vue template while preserve its working. I did it by putting in a div tag inside form tags)
    Times asked 2
    Official solution

    SimpleORM = Object Relational Mapping. Tables → Python classes. Raw SQL kam likhte ho.

    Example

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

User.query.get(5)  # SELECT ... WHERE id=5
Advice: Overall nice proctor, positive thinking and motivate to answer by providing hints. Put more knowledge on theory rather than practice if you get this proctor.Good luck for my peers.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Explain webhooks
    Times asked 2
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  2. 2
    Explain lazy loading No coding asked
    Times asked 2
    Official solution

    Simplelazy loading: related objects kab load hon. lazy=True default (access pe query). joined/eager pehle se join.

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Show demo
    Times asked 11
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    Show admin login
    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.

  3. 3
    tells you improvements that can be made
    Times asked 2
    Official solution

    Simple2-3 honest improvements + 1 security + 1 UX.

    Example

    password hashing/CSRF tighter, Redis cache, tests, pagination, email verify, rate limit login, better mobile CSS.

    Challenges: relationships/cascade, concurrent booking, Jinja inheritance.
    Rate: 7-8/10 with reason — 10/10 arrogant, 3/10 confidence khatam.
    Security extra: HTTPS, hashed passwords, CSRF, SQL injection (ORM), login attempts, file type check.

  4. 4
    show parking spots and user management
    Times asked 2
    Official solution

    SimpleDemo 5–7 min ki kahani: saari roles, koi milestone skip nahi, bolte-bolte dikhao.

    Examiner list tick karta hai. Crash ho to panic nahi — terminal error padho.

    Code tab kholna jab poochhein. Extra uncommitted features mat dikhana agar portal ZIP mein nahi.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search + charts
    6) CSV export / email job
    7) Logout

    Project example: Jo statement/parking/jobs/tickets hai uske user+admin journeys.

    Viva tipBol: 'Yahan overbooking rokta hoon'. Mandatory features pehle, polish baad.

  5. 5
    show code for search funtionality
    Times asked 2
    Official solution

    SimpleCode dikhao to pehle related file: models → route → template. Flow explain karte hue lines padho.

  6. 6
    run celery jobs
    Times asked 2
    Official solution

    Simplevenv activate → dependencies → DB create/migrate → flask run. Browser pe localhost dikhao.

    Example

    python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
flask run
  7. 7
    what is celery
    Times asked 3
    Official solution

    SimpleCelery background tasks (email, CSV, reports) async chalaata hai. Redis broker/queue + cache.

    User 'Export' click → Celery task queue → Redis message → worker CSV banaata hai → user baad mein download.
    Saath isliye: Celery ko broker chahiye, Redis tez in-memory. MAD2 topic zyada, MAD1 mein optional.
    Priority: task queues/routing. Caching: Redis mein key-value, DB hits kam.
    Pub/Sub: publisher channel pe message, subscribers sunte hain — Redis yeh bhi karta hai.

  8. 8
    what is internal css
    Times asked 2
    Official solution

    Simplestyle = CSS. Inline, <style>, Bootstrap classes, ya Vue scoped CSS.

  9. 9
    what is webhooks
    Times asked 2
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  10. 10
    gives good suggestions to be implemented
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

Advice: may or may not ask changes or maybe even ask how to do it , you have to explain verbally how will you proceed.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Checked whether the graph and scores are displaying correctly or not after taking the quiz
    Times asked 2
    Official solution

    SimpleGraph/chart section: Chart.js labels/datasets ya template loop. Color/data source file dikhao aur chhota change karke refresh.

  2. 2
    Explain models
    Times asked 3
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  3. 3
    Single function component
    Times asked 4
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  4. 4
    Asked how would I implement if quiz has to be displayed only to users with particular qualification
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  5. 5
    No code changes asked
    Times asked 2
    Official solution

    Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:

    Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.

    Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.

    Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
    Live change maange to: related model → route → template, phir browser refresh karke dikhao.

    Example (generic create):
    obj = Model(name=request.form.get('name'))

    db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
  6. 6
    At the end he gave some more suggestions on what other features I can implement in my project
    Times asked 2
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

  7. 7
    Viva done in 30min
    Times asked 2
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Demonstration of the project (Just 2-3 functionalities. Then he moved to theory)
    Times asked 2
    Official solution

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

  2. 2
    What is SPAs
    Times asked 2
    Official solution

    SimpleSPA ek ghar, rooms (routes) ke beech bina poora ghar todo. MPA har room naya ghar (MAD1 Jinja).

    Vue Router client navigation. Backend JSON. Back button, shareable URL.

    MPA: har click full reload. SPA: first load JS bundle, phir fast.

    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: /#/login vs /#/dashboard bina Flask template render.

    Viva tipVue Router client-side navigation. Backend sirf JSON APIs deta hai.

Advice: Prepare your theory well. The level2 is meant for how much you know the concepts.
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Household Services: He asked me to run my application, and he started giving feedback on how to improve each functionality that I showed. Then he asked me to explain my db tables and their structure. Then he asked me 3 questions:
    Times asked 2
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Checksum
    Times asked 5
    Official solution

    SimpleExaminer wohi ZIP chahta hai jo tumne submit kiya, local extra magic nahi.

    Portal download → extract → redis, venv, pip, npm, flask, worker, beat.

    Checksum maange to hash. Uncommitted files mat dikhana.

    Examiner 2 cheezein: simple desi line + tumhare project ki exact file.

    Pehle ID, GitHub, portal ZIP. Phir run: Redis + Flask + worker + beat + Vue. Feature demo: login, RBAC, cache hit/miss, Celery mail, search.

    Line pe ungli: input kahan, kaunsa check, query/cache/task, JSON/UI. Copilot band. Jo nahi kiya honestly bolo + kaise add karte.

    Suggested flow1) ZIP
    2) Extract
    3) Redis + venv + pip
    4) npm/vite
    5) flask + celery worker + beat

    Project example: Submitted zip run. README commands copy.

    Viva tipChecksum maange to hash match karke dikhao. Extra uncommitted files mat dikhana.

  2. 2
    Start the App
    Times asked 2
    Official solution

    Simplevenv activate → dependencies → DB create/migrate → flask run. Browser pe localhost dikhao.

    Example

    python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
flask run
  3. 3
    Demo of Librarian screen
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  4. 4
    How the Book and Sections models are implemented
    Times asked 2
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  5. 5
    How rating is updated in the backend
    Times asked 2
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  6. 6
    Authentication, Authorization
    Times asked 1
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
  7. 7
    Gave Good inputs on how the UI can be made better and the general end user expectations from a UI
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    Demo of the app.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    Lazy loading.
    Times asked 1
    Official solution

    Simplelazy loading: related objects kab load hon. lazy=True default (access pe query). joined/eager pehle se join.

  3. 3
    Left join(from dbms).
    Times asked 1
    Official solution

    SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

    Example

    db.session.query(Booking, User).join(User).filter(User.id == uid).all()
  4. 4
    Delete vs truncate.
    Times asked 2
    Official solution

    SimpleUngli rakhe to 4-line formula — panic ki jagah structure.

    1) File ka role: model / Flask route / Vue SFC / celery task / config
    2) Input kahan: JSON, params, token, props, $route
    3) Kya kaam: query, cache, validation, .delay()
    4) Output: jsonify, this.items, email, redirect

    Unknown keyword: import, decorator, if, commit — har ka reason. Bluff mat.

    Suggested flow1) Kaunsi layer?
    2) Input?
    3) DB/cache/task?
    4) Response/UI?

    Project example: Booking POST: jwt, seats check, commit, 201, Vue list push.

    Viva tipUnknown keyword: import, decorator, if, commit — har ka reason. Panic mat.

  5. 5
    Single page applications.
    Times asked 1
    Official solution

    SimpleMAD1 typical: Browser → Flask routes → validate/auth → SQLAlchemy → SQLite → Jinja response.

    Suggested flowRequest → Route → Auth check → DB → render_template / redirect

  6. 6
    Child components.
    Times asked 2
    Official solution

    SimpleParent-child: parent template mein child component. Props parent→child, emit child→parent.

  7. 7
    ( The proctor was very calm and helpful ,when I was stuck at a point , he suggested me how to do it.)
    Times asked 2
    Official solution

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

See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    The viva was between easy to moderate.
    Times asked 2
    Official solution

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

  2. 2
    The proctor first asked to demonstrate the app, then asked some questions from app(mostly core functionalities, even sometimes deep functionalities)
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    Most of the questions were repeated from before like:
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  4. 4
    What is Lazy loading?
    Times asked 1
    Official solution

    Simplelazy loading related objects tab load karta hai jab attribute access karte ho, pehle nahi.

    user = User.query.get(1)  # posts query nahi

    user.posts # ab query

    lazy=True / 'select' default. lazy='joined' eager join. lazy='dynamic' query object.
    uselist=False One-to-One (single object, list nahi). Hataoge to list mil sakti hai.
    Frontend lazy loading images alag cheez hai (viewport mein aaye tab load).

  5. 5
    What is the difference between PATCH, PUT and POST?
    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.

  6. 6
    Why is POST idempotent?
    Times asked 2
    Official solution

    SimpleIdempotent = same request N baar = same effect. GET/PUT/DELETE usually; POST create duplicate ho sakta hai.

  7. 7
    etc..
    Times asked 2
    Official solution

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

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Questions(I remember):
    Times asked 2
    Official solution

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

  2. 2
    Internal vs inline css
    Times asked 2
    Official solution

    SimpleUngli rakhe to 4-line formula — panic ki jagah structure.

    1) File ka role: model / Flask route / Vue SFC / celery task / config
    2) Input kahan: JSON, params, token, props, $route
    3) Kya kaam: query, cache, validation, .delay()
    4) Output: jsonify, this.items, email, redirect

    Unknown keyword: import, decorator, if, commit — har ka reason. Bluff mat.

    Suggested flow1) Kaunsi layer?
    2) Input?
    3) DB/cache/task?
    4) Response/UI?

    Project example: Booking POST: jwt, seats check, commit, 201, Vue list push.

    Viva tipUnknown keyword: import, decorator, if, commit — har ka reason. Panic mat.

  3. 3
    Left join
    Times asked 2
    Official solution

    SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

    Example

    db.session.query(Booking, User).join(User).filter(User.id == uid).all()
  4. 4
    how you implemented search functionality
    Times asked 2
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  5. 5
    Explain relationship between book and category tables
    Times asked 2
    Official solution

    Simpledb.relationship se object graph: lot.spots, booking.user. backref reverse side auto deta hai.

    Example

    spots = db.relationship('Spot', backref='lot', cascade='all, delete-orphan')
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    My Project: Music Streaming App
    Times asked 2
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

  2. 2
    Demonstration of the app (a very thorough demo, explaining every functionality)
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    Explain the working of caching, search function and filters
    Times asked 2
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  4. 4
    Explain the working of music player and streaming of audio
    Times asked 2
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  5. 5
    Admin Page and it's functions
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

  6. 6
    What are the most commonly used HTTP verbs in a Restful Application
    Times asked 2
    Official solution

    SimpleREST: resources + HTTP verbs. GET read, POST create, PUT/PATCH update, DELETE remove. Stateless ideal.

  7. 7
    Difference between POST, PUT, PATCH methods
    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.

  8. 8
    Decorators
    Times asked 2
    Official solution

    Simplelogin_required jaisa decorator protected routes pe: session nahi to login redirect.

    Example

    def login_required(fn):
    @wraps(fn)
    def wrapper(*a, **k):
        if 'user_id' not in session:
            return redirect(url_for('auth.login'))
        return fn(*a, **k)
    return wrapper
  9. 9
    Why did I choose music app instead of grocery store
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    What are Vue components and Vue directives?
    Times asked 1
    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.

  2. 2
    What is ORM?
    Times asked 49
    Official solution

    SimpleORM = Object Relational Mapping. Database tables ko Python classes/objects se map karta hai, raw SQL kam likhni padti hai.

    Bina ORM: cursor.execute('SELECT * FROM user WHERE id=?', [5])
    ORM se: User.query.get(5) ya db.session.get(User, 5)

    Example model

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

    FaydePython mein soch sakte ho, SQL injection se protection (parameterized), relationships easy, DB switch thoda aasan.

    Nuksaancomplex queries slow/abstract, seekhne ki layer extra, kabhi raw SQL phir bhi chahiye.

    MAD1: SQLAlchemy (Flask-SQLAlchemy). Tables db.create_all() ya migrations se banti hain.

  3. 3
    what is Webhook and API?
    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.

  4. 4
    what is SQL alchemy?
    Times asked 2
    Official solution

    SimpleSQLAlchemy MAD1 ka common ORM. Flask-SQLAlchemy wrapper se db.Model, db.session.

    Example

    user = User(email='a@b.com')
db.session.add(user)
db.session.commit()
users = User.query.filter_by(role='admin').all()
  5. 5
    How long did it take to create this app?
    Times asked 2
    Official solution

    SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

    Viva tipFunction signature + 3-4 important lines + edge case.

  6. 6
    He told me to limit the price of the products to prevent them from going beyond a certain range.
    Times asked 2
    Official solution

    SimplePehle 1-line definition, phir apne MAD1 project mein file dikhao, phir chhota example.

    Suggested flow1) Concept kya hai?
    2) Mere code mein kahan?
    3) Example / demo
    4) Edge case

    Example

    # related file: models.py / routes / template
# formula: request → check/auth → DB → render/redirect

    Viva tipExact line yaad nahi to honestly related part dikhao. Bluff mat karo.

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    1.cell spacing and cell padding related to css
    Times asked 2
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  2. 2
    Checked if it shows houseful when the all tickets are booked both in backed And frontend.
    Times asked 2
    Official solution

    SimpleMAD1 frontend usually Jinja templates + HTML/CSS/Bootstrap (+ thoda JS). MAD2 pe Vue ho to clearly bolo.

  3. 3
    Http verbs and explain them
    Times asked 2
    Official solution

    SimpleHTTP verbs REST ke tools. Methods HTTP ke hain, REST unhe convention se use karta hai.

    GET read cacheable. POST create payload. PUT replace. PATCH patch. DELETE remove.

    GET exists bina REST ke bhi — browser address bar.

    HTTP verbs + status REST ki zabaan. GET read, POST create, PUT replace, PATCH partial, DELETE remove. GET typically no body.

    Status: 200 OK, 201 created, 202 accepted (Celery task), 400 bad input, 401 no/bad token, 403 role nahi, 404 missing, 409 conflict (double book), 500 server.

    AJAX/fetch page reload nahi. SPA poori isi pe. Postman se bina Vue ke API prove karo — examiner pasand.

    Example

    GET /api/venues
POST /api/venues
PUT /api/venues/1
DELETE /api/venues/1

    Project example: resources.py methods list. Postman 4-5 calls.

    Viva tipGET typically no body (cacheable). POST/PUT/PATCH haan payload. PUT idempotent, POST nahi.

  4. 4
    How did you implement search for theaters and shows (backend)
    Times asked 2
    Official solution

    SimpleSearch: form/query param → ilike filter → results template.

    Example

    q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()
  5. 5
    How to implement lazy loading in vue (asked syntax)
    Times asked 2
    Official solution

    Simplelazy loading: related objects kab load hon. lazy=True default (access pe query). joined/eager pehle se join.

  6. 6
    Difference between authentication and authorisation. And gave some feedback on the project.
    Times asked 2
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Demonstrate app, he found a Bug asked to fix it there,
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    2.) Same questions as all level3_11 above
    Times asked 2
    Official solution

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

See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    Do you know what SPA is?
    Times asked 2
    Official solution

    SimpleMAD1 typical: Browser → Flask routes → validate/auth → SQLAlchemy → SQLite → Jinja response.

    Suggested flowRequest → Route → Auth check → DB → render_template / redirect

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    Demo of your application
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    Checked if the modification made to show details is reflected in the user page.
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  3. 3
    What is lazy loading?
    Times asked 3
    Official solution

    Simplelazy loading related objects tab load karta hai jab attribute access karte ho, pehle nahi.

    user = User.query.get(1)  # posts query nahi

    user.posts # ab query

    lazy=True / 'select' default. lazy='joined' eager join. lazy='dynamic' query object.
    uselist=False One-to-One (single object, list nahi). Hataoge to list mil sakti hai.
    Frontend lazy loading images alag cheez hai (viewport mein aaye tab load).

  4. 4
    SPA
    Times asked 1
    Official solution

    SimpleMAD1 typical: Browser → Flask routes → validate/auth → SQLAlchemy → SQLite → Jinja response.

    Suggested flowRequest → Route → Auth check → DB → render_template / redirect

  5. 5
    POST and GET
    Times asked 2
    Official solution

    SimpleGET data read/show karta hai (idempotent). POST create/submit karta hai (form).

    Example

    @app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        # validate + session
        ...
    return render_template('login.html')
See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    Difference between authentication and authorisation
    Times asked 4
    Official solution

    SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

    Example

    # auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)
  2. 2
    how have i implemented RBAC for admin
    Times asked 1
    Official solution

    SimpleRBAC = Role Based Access Control. Roles (admin/user) se permissions milti hain, har user pe alag list nahi.

    Example

    if current_user.role != 'admin':
    flash('Not allowed')
    return redirect(url_for('user.home'))
See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    (1) Asked to show working function of app
    Times asked 2
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    (2) venue and show capacity constraint (Eg. 100 seats in venue then for show inside that venue we cant allot 120 seats)
    Times asked 2
    Official solution

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

  3. 3
    (4) SPA
    Times asked 2
    Official solution

    SimpleMAD1 typical: Browser → Flask routes → validate/auth → SQLAlchemy → SQLite → Jinja response.

    Suggested flowRequest → Route → Auth check → DB → render_template / redirect

  4. 4
    (5) single page and multipage difference
    Times asked 2
    Official solution

    SimpleMAD1 typical: Browser → Flask routes → validate/auth → SQLAlchemy → SQLite → Jinja response.

    Suggested flowRequest → Route → Auth check → DB → render_template / redirect

  5. 5
    (6) Explain edit show code from from frontend to backend
    Times asked 1
    Official solution

    SimpleCode dikhao to pehle related file: models → route → template. Flow explain karte hue lines padho.

  6. 6
    (7) Explain models
    Times asked 1
    Official solution

    Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

    Suggested flow1) Classes list karo
    2) Har table ka kaam 1 line
    3) Relationships (1-M / M-M)
    4) Constraints (unique, nullable)

    Example

    class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)
  7. 7
    (8) Implement constraint on password length (Frontend)
    Times asked 2
    Official solution

    SimpleMAD1 frontend usually Jinja templates + HTML/CSS/Bootstrap (+ thoda JS). MAD2 pe Vue ho to clearly bolo.

  8. 8
    (10) Can we use POST instead of PUT
    Times asked 2
    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.

See reviews Level3_11 MAD1 Level 3
Copy set link
  1. 1
    wanted to know my thought process on how i would implement and what changes will i make if i had to create only one common table between user and admin
    Times asked 2
    Official solution

    SimpleProject overview: problem → roles → main entities → key flows (register, book, admin approve).

    Viva tip1 minute elevator pitch ready rakho, phir demo.

See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    Asked me to first demonstrate the application and then will take a look at my code
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

    Suggested flow1) Register/login user
    2) Admin login — CRUD
    3) Approval/blacklist
    4) Booking/apply + edge case
    5) Search
    6) Logout

    Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

  2. 2
    while showing the admin side of the page asked me to add set an alert message when admin tries to allot more seats to a show in a venue than the allotted seats for that particular venue (even though backend was not letting the admin book more seats than possible)
    Times asked 2
    Official solution

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

  3. 3
    asked me to change the blue coloured button to green
    Times asked 2
    Official solution

    SimpleLive UI change: relevant CSS/HTML template kholo — color, margin, flex, bootstrap class. Save + hard refresh.

    Example

    /* button red */
.btn-primary { background: red; }

/* center navbar item */
.navbar { justify-content: center; }

    Viva tipDevTools se pehle try, phir file mein permanent change.

  4. 4
    what is lazy loading
    Times asked 1
    Official solution

    Simplelazy loading related objects tab load karta hai jab attribute access karte ho, pehle nahi.

    user = User.query.get(1)  # posts query nahi

    user.posts # ab query

    lazy=True / 'select' default. lazy='joined' eager join. lazy='dynamic' query object.
    uselist=False One-to-One (single object, list nahi). Hataoge to list mil sakti hai.
    Frontend lazy loading images alag cheez hai (viewport mein aaye tab load).

  5. 5
    what is the difference between patch and put
    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.

See reviews Level3_11 MAD2 Level 1
Copy set link
  1. 1
    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.

  2. 2
    Explain the Edit Show flow from frontend to backend.
    Times asked 1
    Official solution

    SimpleGET id load form → PUT/PATCH → cache delete → redirect list.

    Edit show frontend to 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: Admin edit page.

    Project example: Admin edit page.

  3. 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. 4
    How long did it take you to build this application?
    Times asked 1
    Official solution

    SimpleHonest weeks. Process: models, API, Vue, jobs. No padding.

    Which parts yourself vs AI.

    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: Calendar vague OK, lie not.

    Project example: Calendar vague OK, lie not.

  5. 5
    Prevent assigning more seats to a show than the venue capacity (frontend validation).
    Times asked 1
    Official solution

    Simpleshow.seats <= venue.capacity create/update FE+BE. Prevent assigning more seats than venue.

    Frontend validation plus 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: create show form.

  6. 6
    Change the button color (e.g., blue to green).
    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.

  7. 7
    Implement password length validation on the frontend.
    Times asked 1
    Official solution

    SimpleRegex upper lower digit. Frontend + backend. Length hash column alag baat.

    Live task common.

    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

    re.search(r'[A-Z]', p) and re.search(r'[a-z]', p) and re.search(r'\d', p)

    Project example: register route + Login.vue.

  8. 8
    Limit the product price so it cannot exceed a specified range.
    Times asked 1
    Official solution

    Simpleif price < min or > max 400. Input :max. Limit product price range. Limit max slots/seats creating record.

    Both.

    Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).

    4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.

    Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.

    Project example: create form + route.

    Project example: create form + route.

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

  10. 10
    What is SPA (Single Page Application)?
    Times asked 2
    Official solution

    SimpleSPA ek ghar, rooms (routes) ke beech bina poora ghar todo. MPA har room naya ghar (MAD1 Jinja).

    Vue Router client navigation. Backend JSON. Back button, shareable URL.

    MPA: har click full reload. SPA: first load JS bundle, phir fast.

    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: /#/login vs /#/dashboard bina Flask template render.

    Viva tipVue Router client-side navigation. Backend sirf JSON APIs deta hai.

  11. 11
    Difference between Single Page Applications (SPA) and Multi-Page Applications (MPA).
    Times asked 1
    Official solution

    SimpleSPA ek ghar, rooms (routes) ke beech bina poora ghar todo. MPA har room naya ghar (MAD1 Jinja).

    Vue Router client navigation. Backend JSON. Back button, shareable URL.

    MPA: har click full reload. SPA: first load JS bundle, phir fast.

    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: /#/login vs /#/dashboard bina Flask template render.

    Viva tipVue Router client-side navigation. Backend sirf JSON APIs deta hai.

  12. 12
    What are Vue components?
    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.

  13. 13
    What are Vue directives?
    Times asked 6
    Official solution

    SimpleDirectives Vue ke special attributes — HTML ko superpower.

    v-if/else/show, v-for, v-bind (:), v-on (@), v-model, v-html (XSS), v-cloak, v-slot.

    :src = v-bind:src. @click = v-on:click.

    Custom directives bhi (v-focus) — course basics kaafi.

    Example

    <p v-if="ok">Yes</p>
<li v-for="u in users" :key="u.id">{{ u.name }}</li>
<input v-model="email">
<img :src="url">

    Project example: List v-for :key. Form v-model. Admin v-if. Image :src.

    Viva tip: src ke liye v-bind:src ka shorthand. @click = v-on:click.

  14. 14
    Difference between PUT and PATCH.
    Times asked 7
    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.

  15. 15
    Difference between POST and PUT.
    Times asked 4
    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.

  16. 16
    Can POST be used instead of PUT? Why or why not?
    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.

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

  18. 18
    What is the difference between a Webhook and an API?
    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.

  19. 19
    Difference between Authentication and Authorization.
    Times asked 20
    Official solution

    SimpleAuthentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"

    Authentication: login. Username + password check karke prove karte ho ki tum genuine user ho. Success pe session/token milta hai.
    Authorization: uske baad role check. Admin hi parking lot / venue / drive delete kar sakta hai, normal user nahi.

    MAD2 mein yeh alag layers hain: login API = authentication (JWT milta hai). @roles_required('admin') ya Vue v-if="isAdmin" = authorization.

    Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+). Authentication identity hai, authorization permission, validation input quality.

    Example

    # Authentication
if user and check_password_hash(user.password, form_password):
    token = create_access_token(identity=user.id)

# Authorization
if current_user.role != 'admin':
    abort(403)  # logged in ho, lekin allowed nahi

    Project example: Student login = authentication. Student admin dashboard nahi khol sakta = authorization. Frontend button hide sirf UX hai — asli check backend pe hona chahiye.

    Viva tip401 = not logged in / bad token. 403 = logged in, role galat. Examiner yeh difference bahut poochta hai.

  20. 20
    How have you implemented RBAC (Role-Based Access Control) for the Admin?
    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.

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

  22. 22
    What is SQLAlchemy?
    Times asked 8
    Official solution

    SimpleSQLAlchemy toolkit + ORM. Flask-SQLAlchemy wrapper db.

    URI sqlite:///app.db. Postgres postgresql://. Dialects MySQL MSSQL.

    Session add/commit/rollback. IntegrityError catch.

    ORM objects ko tables se map karta hai — raw SQL kam. SQLAlchemy MAD2 default.

    class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLite→Postgres, injection se safer. Nuksaan: N+1, complex SQL.

    SQLite file, zero server — course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.

    Bookings source of truth DB, Redis cache copy.

    Example

    app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db'
# migrate: URI postgres://user:pass@host/db  + psycopg2

    Project example: config SQLALCHEMY_DATABASE_URI. db.create_all() ya migrate.

  23. 23
    Can SQLAlchemy connect to Microsoft SQL Server?
    Times asked 1
    Official solution

    SimpleHaan SQLAlchemy + pyodbc mssql+ URI. Course SQLite. Extra driver.

    Can connect Microsoft SQL Server.

    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: Not used, supported theoretically.

    Project example: Not used, supported theoretically.

See reviews Level3_11 MAD1 Level 1
Copy set link
  1. 1
    Show your IITM ID card.
    Times asked 1
    Official solution

    SimpleCamera pe clearly IITM/college ID dikhao — naam photo match.

    Pehle se ID haath mein rakho. Glare mat aane do. Examiner screenshot/verify karta hai. Iske baad GitHub + project run.

  2. 2
    Download the submitted project from the portal and run it.
    Times asked 1
    Official solution

    SimpleExaminer submitted ZIP chahta hai, local extra changes nahi.

    Portal se ZIP download → extract → venv → pip install -r requirements.txt → flask run / python app.py.
    Checksum maange to hash match karke dikhao. Camera/OPPE setup unke instructions.
    Linux/Mac: paths, gunicorn; Windows paths alag ho to relative paths use karo.
    Do browsers: admin + user parallel demo impressive lagta hai.

  3. 3
    Give a complete demo of the application.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice karo, 5-7 minute, saari roles.

    Suggested flow

    1) Register/login user 2) Admin login — CRUD 3) Approval/blacklist 4) Booking/apply 5) Search 6) Validation edge (slots 0, duplicate) 7) Logout
    Bolte-bolte dikhao: 'Yahan overbooking rokta hoon'. Code tab kholna jab poochhein.
    Crash ho to debug calmly: terminal error, typo, DB path.
    Mandatory features skip mat karna — examiner list tick karta hai.

  4. 4
    Explain all major features of your application.
    Times asked 1
    Official solution

    SimpleDemo script pehle se practice karo, 5-7 minute, saari roles.

    Suggested flow

    1) Register/login user 2) Admin login — CRUD 3) Approval/blacklist 4) Booking/apply 5) Search 6) Validation edge (slots 0, duplicate) 7) Logout
    Bolte-bolte dikhao: 'Yahan overbooking rokta hoon'. Code tab kholna jab poochhein.
    Crash ho to debug calmly: terminal error, typo, DB path.
    Mandatory features skip mat karna — examiner list tick karta hai.

  5. 5
    Explain the update/edit functionality.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  6. 6
    Explain the created route you implemented.
    Times asked 1
    Official solution

    SimpleRoutes/controllers URLs handle karte hain. app.py app banata hai, models.py data, templates/ views, static/ CSS-JS.

    Typical structure:
    app.py / __init__.py → Flask app, db.init, register blueprints
    models.py → tables
    routes.py / views → @app.route functions
    templates/ → Jinja HTML
    static/ → css, images
    instance/*.db → SQLite

    Ek route explain karne ka template:
    1) URL + methods 2) Auth/role check 3) Form/query se data 4) Business rule (duplicate, slots) 5) db.session 6) render ya redirect

    Example GET+POST same route: GET form, POST save.
    Data HTML se: form name= → request.form. Data HTML ko: render_template(..., items=query).
    Nayi .py file: import karke use karo, warna Flask ko pata nahi. Folder rename: imports/paths/templates check.

  7. 7
    Explain your models (models.py).
    Times asked 1
    Official solution

    Simplemodels.py har table ki class hai — columns, PK/FK, relationships. Yeh Model layer hai.

    Viva mein file khol ke bolo:
    1) Kaunsi classes/tables hain (User, Role-specific, Booking...)
    2) Har table ka kaam 1 line
    3) Relationships: 1-1 / 1-M / M-M, backref, cascade, lazy
    4) Constraints: unique email, nullable, default status

    Example skeleton

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), default='user')
    bookings = db.relationship('Booking', backref='user', cascade='all, delete-orphan')

    ER diagram: rectangles entities, lines relationships, PK/FK mark. Schema = yahi structure.
    Tables create: db.create_all() ya migrations. SQLite file SQL viewer se dikha sakte ho.

  8. 8
    Explain the workflow of your application (booking, appointments, campaigns, placement drive, inventory, etc.).
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  9. 9
    Explain the search functionality.
    Times asked 2
    Official solution

    SimpleSearch box GET form, backend query filter, results template mein.

    q = request.args.get('q', '').strip()
results = Doctor.query.filter(Doctor.name.ilike(f'%{q}%')).all() if q else []
return render_template('search.html', results=results, q=q)

    Jinja: {{ results|length }} matches. Empty: 'No results'.
    JS-only filter: saara data pehle load, client filter — chhote lists. Bada data: server search.
    Search generally GET (shareable URL). Count: len(results) ya db.func.count.

  10. 10
    Explain your database schema and table relationships.
    Times asked 2
    Official solution

    Simplemodels.py har table ki class hai — columns, PK/FK, relationships. Yeh Model layer hai.

    Viva mein file khol ke bolo:
    1) Kaunsi classes/tables hain (User, Role-specific, Booking...)
    2) Har table ka kaam 1 line
    3) Relationships: 1-1 / 1-M / M-M, backref, cascade, lazy
    4) Constraints: unique email, nullable, default status

    Example skeleton

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), default='user')
    bookings = db.relationship('Booking', backref='user', cascade='all, delete-orphan')

    ER diagram: rectangles entities, lines relationships, PK/FK mark. Schema = yahi structure.
    Tables create: db.create_all() ya migrations. SQLite file SQL viewer se dikha sakte ho.

  11. 11
    Explain your routes (app.py / route functions).
    Times asked 1
    Official solution

    SimpleRoutes/controllers URLs handle karte hain. app.py app banata hai, models.py data, templates/ views, static/ CSS-JS.

    Typical structure:
    app.py / __init__.py → Flask app, db.init, register blueprints
    models.py → tables
    routes.py / views → @app.route functions
    templates/ → Jinja HTML
    static/ → css, images
    instance/*.db → SQLite

    Ek route explain karne ka template:
    1) URL + methods 2) Auth/role check 3) Form/query se data 4) Business rule (duplicate, slots) 5) db.session 6) render ya redirect

    Example GET+POST same route: GET form, POST save.
    Data HTML se: form name= → request.form. Data HTML ko: render_template(..., items=query).
    Nayi .py file: import karke use karo, warna Flask ko pata nahi. Folder rename: imports/paths/templates check.

  12. 12
    Explain specific database models (Cart, Service, Doctor, Campaign, etc.).
    Times asked 1
    Official solution

    Simplemodels.py har table ki class hai — columns, PK/FK, relationships. Yeh Model layer hai.

    Viva mein file khol ke bolo:
    1) Kaunsi classes/tables hain (User, Role-specific, Booking...)
    2) Har table ka kaam 1 line
    3) Relationships: 1-1 / 1-M / M-M, backref, cascade, lazy
    4) Constraints: unique email, nullable, default status

    Example skeleton

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), default='user')
    bookings = db.relationship('Booking', backref='user', cascade='all, delete-orphan')

    ER diagram: rectangles entities, lines relationships, PK/FK mark. Schema = yahi structure.
    Tables create: db.create_all() ya migrations. SQLite file SQL viewer se dikha sakte ho.

  13. 13
    Explain how ratings, billing, booking, or business logic works.
    Times asked 1
    Official solution

    SimpleCost generally rate × quantity/time, round up rules ke saath.

    hours = max(1, math.ceil(total_minutes / 60)) # 10 min bhi 1 hour
    cost = hours * lot.price_per_hour
    Logic route/model method mein rakho, template mein sirf {{ booking.cost }}.
    Viva: numbers ka example 90 min × ₹50 = ₹100 (ceil 2 hours) walkthrough karo.

  14. 14
    Explain authentication implementation in your project.
    Times asked 1
    Official solution

    SimpleLogin GET form dikhata hai, POST credentials check karke session set karta hai.

    @app.route('/login', methods=['GET','POST'])
def login():
    if request.method == 'POST':
        u = User.query.filter_by(email=request.form.get('email')).first()
        if u and check_password_hash(u.password, request.form.get('password')):
            if getattr(u, 'blacklisted', False):
                flash('Blocked'); return redirect(url_for('login'))
            session['user_id'] = u.id
            session['role'] = u.role
            return redirect(url_for('dashboard'))
        flash('Invalid')
    return render_template('login.html')

    Logout: session.clear(); redirect login. Incognito alag cookie jar — logged out dikhega.
    Single login page: role se redirect alag dashboards.

  15. 15
    Explain authorization implementation in your project.
    Times asked 1
    Official solution

    SimpleAuthentication session se, Authorization role/ownership check se.

    def admin_required(f):
    @wraps(f)
    def wrap(*a,**k):
        if session.get('role') != 'admin':
            abort(403)
        return f(*a,**k)
    return wrap

    Jinja: {% if session['role']=='admin' %}<a href='/admin'>Admin</a>{% endif %}
    Yeh hide hai, security nahi — route pe check zaroori. Admin authenticated bhi hai (logged in) aur authorized bhi (role).

  16. 16
    Explain the search query used (LIKE, ILIKE, etc.).
    Times asked 1
    Official solution

    SimpleLIKE case-sensitive ho sakta hai (DB pe depend), ILIKE case-insensitive (Postgres).

    User.query.filter(User.name.like('Ram%'))   # Ram, Raman
User.query.filter(User.name.ilike('%ram%')) # Ram, RAM, ram

    SQLite LIKE aksar case-insensitive hota hai ASCII pe. Search boxes mein ilike/%pattern% common hai.

  17. 17
    Explain how your application handles validations.
    Times asked 1
    Official solution

    SimpleValidation galat data rok ti hai — frontend turant, backend must.

    Frontend: required, min='18', maxlength='8', pattern='(?=.*[A-Z]).{8,}'
    Backend example:

    pwd = request.form.get('password','')
if len(pwd) < 8 or not re.search(r'[A-Z]', pwd) or not re.search(r'[0-9]', pwd):
    flash('Weak password')

    Haan, regex se password rules ho sakte hain.
    Age 18-99, date >= today, slots <= 30 and > 0, confirm password == password, email '@' .
    Duplicate username: User.query.filter_by(email=email).first() or unique=True catch IntegrityError.
    Past date: if date < date.today(): reject. Negative slots: if slots < 0: reject; book pe available > 0 check.

  18. 18
    Suggest improvements that can make your application better.
    Times asked 1
    Official solution

    Simple2-3 honest improvements + 1 security + 1 UX.

    Example

    password hashing/CSRF tighter, Redis cache, tests, pagination, email verify, rate limit login, better mobile CSS.

    Challenges: relationships/cascade, concurrent booking, Jinja inheritance.
    Rate: 7-8/10 with reason — 10/10 arrogant, 3/10 confidence khatam.
    Security extra: HTTPS, hashed passwords, CSRF, SQL injection (ORM), login attempts, file type check.

  19. 19
    Add custom validation (e.g., expiry date should not be older than today's date).
    Times asked 1
    Official solution

    SimpleValidation galat data rok ti hai — frontend turant, backend must.

    Frontend: required, min='18', maxlength='8', pattern='(?=.*[A-Z]).{8,}'
    Backend example:

    pwd = request.form.get('password','')
if len(pwd) < 8 or not re.search(r'[A-Z]', pwd) or not re.search(r'[0-9]', pwd):
    flash('Weak password')

    Haan, regex se password rules ho sakte hain.
    Age 18-99, date >= today, slots <= 30 and > 0, confirm password == password, email '@' .
    Duplicate username: User.query.filter_by(email=email).first() or unique=True catch IntegrityError.
    Past date: if date < date.today(): reject. Negative slots: if slots < 0: reject; book pe available > 0 check.

  20. 20
    Restrict booking limits (e.g., maximum bookings).
    Times asked 1
    Official solution

    Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:

    Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.

    Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.

    Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
    Live change maange to: related model → route → template, phir browser refresh karke dikhao.

    Example (generic create):
    obj = Model(name=request.form.get('name'))

    db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
  21. 21
    Restrict password length during registration.
    Times asked 1
    Official solution

    SimpleValidation galat data rok ti hai — frontend turant, backend must.

    Frontend: required, min='18', maxlength='8', pattern='(?=.*[A-Z]).{8,}'
    Backend example:

    pwd = request.form.get('password','')
if len(pwd) < 8 or not re.search(r'[A-Z]', pwd) or not re.search(r'[0-9]', pwd):
    flash('Weak password')

    Haan, regex se password rules ho sakte hain.
    Age 18-99, date >= today, slots <= 30 and > 0, confirm password == password, email '@' .
    Duplicate username: User.query.filter_by(email=email).first() or unique=True catch IntegrityError.
    Past date: if date < date.today(): reject. Negative slots: if slots < 0: reject; book pe available > 0 check.

  22. 22
    Modify inventory/cart display logic.
    Times asked 1
    Official solution

    Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:

    Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.

    Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.

    Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
    Live change maange to: related model → route → template, phir browser refresh karke dikhao.

    Example (generic create):
    obj = Model(name=request.form.get('name'))

    db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
  23. 23
    Make CSS/UI changes.
    Times asked 1
    Official solution

    Yeh live UI/CSS change hai. Examiner jo element bole uski CSS turant badlo.

    Bootstrap class badlo (btn-primary → btn-success, bg-dark → bg-warning) ya inline style='color:red; background:#eee'.
    Center: d-flex justify-content-center text-center. Navbar neeche: navbar fixed-bottom.

    Example

    <button class='btn btn-success' style='background:#16a34a'>Book</button>

    Pehle browser inspect karke class dhundo, phir template mein change karke refresh.

  24. 24
    Implement or modify warning/error messages.
    Times asked 1
    Official solution

    Yeh live coding / notepad task hai. Chhota, correct Flask snippet likho.

    from flask import Flask, render_template, request, redirect, url_for
@app.route('/do', methods=['GET','POST'])
def do():
    if request.method == 'POST':
        # request.form.get('field') ya request.args.get('q')
        # db.session.add(...); commit
        return redirect(url_for('dashboard'))
    items = Model.query.all()
    return render_template('page.html', items=items)

    Jinja: {% for x in items %}<li>{{ x.name }}</li>{% endfor %}
    ID URL: @app.route('/item/<int:id>')

  25. 25
    Change the placement/order of UI elements.
    Times asked 1
    Official solution

    Simpleexaminer UI tweak maangta hai — CSS class ya inline, instantly dikhao.

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

  26. 26
    Make changes in routes or backend logic as requested.
    Times asked 1
    Official solution

    Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:

    Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.

    Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.

    Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
    Live change maange to: related model → route → template, phir browser refresh karke dikhao.

    Example (generic create):
    obj = Model(name=request.form.get('name'))

    db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
  27. 27
    Explain the database schema.
    Times asked 2
    Official solution

    Simplemodels.py har table ki class hai — columns, PK/FK, relationships. Yeh Model layer hai.

    Viva mein file khol ke bolo:
    1) Kaunsi classes/tables hain (User, Role-specific, Booking...)
    2) Har table ka kaam 1 line
    3) Relationships: 1-1 / 1-M / M-M, backref, cascade, lazy
    4) Constraints: unique email, nullable, default status

    Example skeleton

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), default='user')
    bookings = db.relationship('Booking', backref='user', cascade='all, delete-orphan')

    ER diagram: rectangles entities, lines relationships, PK/FK mark. Schema = yahi structure.
    Tables create: db.create_all() ya migrations. SQLite file SQL viewer se dikha sakte ho.

  28. 28
    Explain entity relationships.
    Times asked 1
    Official solution

    SimpleRelationships tables ko jodti hain taaki related data object se mil jaaye.

    One-to-Many: User → kai Posts. posts = relationship('Post', backref='author'). FK post.user_id.
    One-to-One: User → Profile. uselist=False + unique FK. Profile.user_id unique.
    Many-to-Many: Student ↔ Drive. Junction/secondary table (student_id, drive_id).

    Example 1-1:

    class Profile(db.Model):
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), unique=True)
    user = db.relationship('User', back_populates='profile', uselist=False)

    1-M ko 1-1: child FK pe unique=True + uselist=False.
    Parent-child: parent PK, child FK. Junction table extra columns bhi rakh sakti hai (applied_on).

  29. 29
    Explain Primary Key.
    Times asked 1
    Official solution

    SimplePrimary Key har row ko uniquely identify karti hai. Unique Key bhi unique hoti hai lekin table ki main ID nahi.

    id = db.Column(db.Integer, primary_key=True)  # auto increment
email = db.Column(db.String(120), unique=True)

    PK: NOT NULL, ek (ya composite). Index automatically.
    Record fetch: User.query.get(id) PK se tez.
    FK hamesha unique nahi — Many side pe repeat hoti hai. Unique FK = One-to-One.

  30. 30
    Explain Foreign Key.
    Times asked 3
    Official solution

    SimpleForeign Key doosri table ki PK ko refer karti hai, relationship + referential integrity.

    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

    Invalid user_id insert nahi hoga. FK unique nahi hona zaroori — One-to-Many mein same user_id kai rows.
    FK + PK same column: 1-1 sharing, jaise AdminProfile.id = FK to user.id.
    Should FK always unique? Nahi. Tab One-to-One chahiye ho tab unique.

  31. 31
    Explain table referencing.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  32. 32
    Explain how models are connected.
    Times asked 1
    Official solution

    SimpleRelationships tables ko jodti hain taaki related data object se mil jaaye.

    One-to-Many: User → kai Posts. posts = relationship('Post', backref='author'). FK post.user_id.
    One-to-One: User → Profile. uselist=False + unique FK. Profile.user_id unique.
    Many-to-Many: Student ↔ Drive. Junction/secondary table (student_id, drive_id).

    Example 1-1:

    class Profile(db.Model):
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), unique=True)
    user = db.relationship('User', back_populates='profile', uselist=False)

    1-M ko 1-1: child FK pe unique=True + uselist=False.
    Parent-child: parent PK, child FK. Junction table extra columns bhi rakh sakti hai (applied_on).

  33. 33
    Explain database design decisions.
    Times asked 1
    Official solution

    Simplemodels.py har table ki class hai — columns, PK/FK, relationships. Yeh Model layer hai.

    Viva mein file khol ke bolo:
    1) Kaunsi classes/tables hain (User, Role-specific, Booking...)
    2) Har table ka kaam 1 line
    3) Relationships: 1-1 / 1-M / M-M, backref, cascade, lazy
    4) Constraints: unique email, nullable, default status

    Example skeleton

    class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), default='user')
    bookings = db.relationship('Booking', backref='user', cascade='all, delete-orphan')

    ER diagram: rectangles entities, lines relationships, PK/FK mark. Schema = yahi structure.
    Tables create: db.create_all() ya migrations. SQLite file SQL viewer se dikha sakte ho.

  34. 34
    Difference between LIKE and ILIKE.
    Times asked 2
    Official solution

    SimpleLIKE case-sensitive ho sakta hai (DB pe depend), ILIKE case-insensitive (Postgres).

    User.query.filter(User.name.like('Ram%'))   # Ram, Raman
User.query.filter(User.name.ilike('%ram%')) # Ram, RAM, ram

    SQLite LIKE aksar case-insensitive hota hai ASCII pe. Search boxes mein ilike/%pattern% common hai.

  35. 35
    What is backref?
    Times asked 12
    Official solution

    Simplebackref relationship ki reverse side automatically bana deta hai.

    class Post(db.Model):
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    user = db.relationship('User', backref='posts')

    Ab post.user milta hai, aur user.posts bhi — Post model pe sirf ek line.
    secondary Many-to-Many junction table ke liye: relationship(..., secondary=likes_table, backref='liked_by').
    Explicit chahiye to back_populates use karo.

  36. 36
    What is uselist?
    Times asked 2
    Official solution

    Definition style question: 1 line simple Hinglish + project example + mini code.

    Template'X ka kaam Y hai. Mere project mein Z jagah use hua.'

    Example'Session login state rakhta hai. session[user_id]=u.id login pe, logout pe session.clear().'

    Agar topic Vue/Celery/Redis ho aur project mein nahi hai to sach bolo, theory example do.

  37. 37
    Explain Lazy Loading.
    Times asked 1
    Official solution

    Simplelazy loading related objects tab load karta hai jab attribute access karte ho, pehle nahi.

    user = User.query.get(1)  # posts query nahi

    user.posts # ab query

    lazy=True / 'select' default. lazy='joined' eager join. lazy='dynamic' query object.
    uselist=False One-to-One (single object, list nahi). Hataoge to list mil sakti hai.
    Frontend lazy loading images alag cheez hai (viewport mein aaye tab load).

  38. 38
    Difference between Lazy Loading and Eager Loading.
    Times asked 1
    Official solution

    SimpleLazy related data tab laata hai jab maango, Eager pehle hi join karke laata hai.

    lazy='select' (default): user.posts access karte hi alag query. N+1 problem ho sakti hai.
    eager (joinedload/lazy='joined'): ek hi query mein user + posts.
    lazy='dynamic': query object return, aage filter laga sakte ho.

    Example

    users = User.query.all()          # 1 query
for u in users:
    print(u.posts)                # har user pe extra query = N+1

    FixUser.query.options(joinedload(User.posts)).all()

    Eager tab use karo jab related data definitely chahiye (dashboard with nested info).

  39. 39
    Real-world use cases of Eager Loading.
    Times asked 1
    Official solution

    Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:

    Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.

    Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.

    Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
    Live change maange to: related model → route → template, phir browser refresh karke dikhao.

    Example (generic create):
    obj = Model(name=request.form.get('name'))

    db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
  40. 40
    What is REST API?
    Times asked 1
    Official solution

    SimpleAPI = Application Programming Interface — do systems predefined rules se baat karti hain. REST API HTTP + JSON use karti hai.

    Controller/route HTML bhi return kar sakta hai. REST API generally JSON return karti hai, frontend alag ho (Vue/Postman).

    Example

    @app.route('/api/users/<int:id>')
def get_user(id):
    u = User.query.get_or_404(id)
    return jsonify(id=u.id, name=u.name)

    MAD1 HTML apps mein 'API' kabhi-kabhi routes ko hi keh dete hain. Agar Vue nahi to bolo: server-rendered Flask, JSON APIs optional.
    Boolean return: technically jsonify(True) ho sakta hai, lekin meaningful JSON object better. Flask view None return kare to error.
    Test: Postman se GET/POST.
    Parsing: request.get_json() body se, request.args query se.

  41. 41
    What are HTTP methods?
    Times asked 5
    Official solution

    SimpleHTTP methods batate hain request kya karna chahti hai. Common: GET POST PUT PATCH DELETE.

    GETread/fetch. Safe, URL se. Page kholna, search.

    POSTcreate/submit. Form, login.

    PUTpoora replace/update. Idempotent.

    PATCHpartial update.

    DELETEhataana.

    HEAD: sirf headers. OPTIONS: CORS preflight.

    Flask: @app.route('/x', methods=['GET','POST'])
    Agar methods na likho to default sirf GET.
    HTML form native sirf GET/POST. PUT/DELETE JS/fetch ya hidden _method se.
    GET se data fetch ho sakta hai, create nahi karna chahiye. POST se theoretically fetch ho sakta hai lekin cache/semantics galat.
    DELETE fetch ke liye nahi. GET POST ka kaam officially nahi karta — side effects GET pe mat rakho.

  42. 42
    Explain GET.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  43. 43
    Explain POST.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  44. 44
    Explain PUT.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  45. 45
    Explain PATCH.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  46. 46
    Difference between GET and POST.
    Times asked 7
    Official solution

    SimpleGET data mangta hai (read), POST data bhejta hai (create/submit).

    GETURL mein dikhta hai, bookmark ho sakta hai, browser back/refresh safe hai, data URL query mein jaata hai. Search, page open, login form dikhana.

    POSTbody mein data jaata hai, URL mein password nahi dikhta, refresh pe dubara submit ho sakta hai. Login, register, form save.

    Example

    # page dikhana

    @app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'GET':
        return render_template('login.html')
    # POST: form submit
    email = request.form.get('email')
    ...

    GET se theoretically data bhej sakte ho (?q=flask), lekin create/update ke liye nahi use karna — data log/history mein save ho jaata hai, length limit hoti hai.
    HTML form default GET hota hai; method='POST' likhna zaroori hai login/register pe.

  47. 47
    Difference between PUT and POST.
    Times asked 6
    Official solution

    SimplePOST nayi cheez create karta hai, PUT existing cheez ko replace/update karta hai.

    POST /books → naya book add. Har baar naya ID banega. Idempotent nahi — 2 baar POST = 2 records.
    PUT /books/5 → id=5 wale book ko poora update. Same PUT dubara bhejo to same result (idempotent).

    PUT se create bhi ho sakta hai (agar ID client decide kare), lekin REST convention: create = POST, replace = PUT, partial = PATCH.

    Example

    @app.route('/user', methods=['POST'])          # register naya user
@app.route('/user/<int:id>', methods=['PUT'])  # poora profile replace

    HTML <form> PUT nahi bhejta, isliye Flask apps mein edit pe bhi POST use hota hai. Examiner ko yeh reason clearly bolo.

  48. 48
    Difference between PUT and PATCH.
    Times asked 7
    Official solution

    SimplePUT poori resource replace karta hai, PATCH sirf kuch fields update karta hai.

    PUTfull update. Jo fields nahi bheji, woh empty/default ho sakti hain. Idempotent — same request 5 baar bhejo, result same.

    PATCHpartial update. Sirf name change karna hai to sirf name bhejo, baaki fields same rehti hain.

    ExampleUser {name: Ram, city: Delhi, age: 20}

    PUT /user/1 {name: Shyam} → city/age lose ho sakte hain agar poora object nahi bheja.
    PATCH /user/1 {name: Shyam} → sirf name Shyam, city Delhi, age 20 same.

    MAD1 Flask forms mein aksar POST se update karte hain kyunki HTML form PUT/PATCH native support nahi karta. Theory mein farq yeh hai.

  49. 49
    Can GET perform the work of POST?
    Times asked 1
    Official solution

    SimpleGET data mangta hai (read), POST data bhejta hai (create/submit).

    GETURL mein dikhta hai, bookmark ho sakta hai, browser back/refresh safe hai, data URL query mein jaata hai. Search, page open, login form dikhana.

    POSTbody mein data jaata hai, URL mein password nahi dikhta, refresh pe dubara submit ho sakta hai. Login, register, form save.

    Example

    # page dikhana

    @app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'GET':
        return render_template('login.html')
    # POST: form submit
    email = request.form.get('email')
    ...

    GET se theoretically data bhej sakte ho (?q=flask), lekin create/update ke liye nahi use karna — data log/history mein save ho jaata hai, length limit hoti hai.
    HTML form default GET hota hai; method='POST' likhna zaroori hai login/register pe.

  50. 50
    Can PUT be used for creating resources?
    Times asked 1
    Official solution

    SimplePOST nayi cheez create karta hai, PUT existing cheez ko replace/update karta hai.

    POST /books → naya book add. Har baar naya ID banega. Idempotent nahi — 2 baar POST = 2 records.
    PUT /books/5 → id=5 wale book ko poora update. Same PUT dubara bhejo to same result (idempotent).

    PUT se create bhi ho sakta hai (agar ID client decide kare), lekin REST convention: create = POST, replace = PUT, partial = PATCH.

    Example

    @app.route('/user', methods=['POST'])          # register naya user
@app.route('/user/<int:id>', methods=['PUT'])  # poora profile replace

    HTML <form> PUT nahi bhejta, isliye Flask apps mein edit pe bhi POST use hota hai. Examiner ko yeh reason clearly bolo.

  51. 51
    Which HTTP method did you use for search?
    Times asked 1
    Official solution

    Definition style question: 1 line simple Hinglish + project example + mini code.

    Template'X ka kaam Y hai. Mere project mein Z jagah use hua.'

    Example'Session login state rakhta hai. session[user_id]=u.id login pe, logout pe session.clear().'

    Agar topic Vue/Celery/Redis ho aur project mein nahi hai to sach bolo, theory example do.

  52. 52
    Which HTTP method did you use for update/edit?
    Times asked 1
    Official solution

    Definition style question: 1 line simple Hinglish + project example + mini code.

    Template'X ka kaam Y hai. Mere project mein Z jagah use hua.'

    Example'Session login state rakhta hai. session[user_id]=u.id login pe, logout pe session.clear().'

    Agar topic Vue/Celery/Redis ho aur project mein nahi hai to sach bolo, theory example do.

  53. 53
    Difference between HTTP and HTTPS.
    Times asked 6
    Official solution

    SimpleHTTP plain text bhejta hai, HTTPS encrypted bhejta hai.

    HTTP: data beech mein koi padh sakta hai (password, session). Port 80. Padlock nahi.
    HTTPS: SSL/TLS se encrypt. Port 443. Certificate verify hota hai. Man-in-the-middle mushkil.

    Examplecafe WiFi pe HTTP login karo to password sniff ho sakta hai. HTTPS pe attacker ko garbage dikhega.

    Viva: HTTPS = HTTP + encryption + identity (certificate). Production apps hamesha HTTPS.

  54. 54
    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 delete kar sakta hai, normal user nahi.

    Example (Flask):
    # Authentication

    if user and check_password_hash(user.password, form_password):
    session['user_id'] = user.id

# Authorization
if session.get('role') != 'admin':
    abort(403)  # logged in ho, lekin allowed nahi

    Project example: student login = authentication. Student admin dashboard nahi khol sakta = authorization.
    Validation alag cheez hai (form sahi bhara hai ya nahi, jaise age 18+).

  55. 55
    Explain authentication in your project.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  56. 56
    Explain authorization in your project.
    Times asked 1
    Official solution

    Examiner code pe ungli rakh ke poochta hai — panic mat karo, 4-line formula bolo.

    1) Yeh file/line kya role hai (model / route / template / config)?
    2) Input kahan se aata hai (form, URL <id>, session, JSON)?
    3) DB pe kya query/write?
    4) Output kya (render_template / redirect / jsonify)?

    Example

    @app.route('/book/<int:id>', methods=['POST']) — logged-in user session se, trek id URL se, Booking add, slots--, redirect history.

    Unknown line: imports (request, url_for, flash), decorators, if checks, commit — har keyword ka reason ready rakho.

  57. 57
    Checksum verification (hash checksum).
    Times asked 1
    Official solution

    SimpleChecksum file ka hash (jaise SHA256) — file change hui ya nahi verify.

    Portal pe submitted ZIP ka checksum diya hota hai. Local file ka hash nikaalo, match hona chahiye.
    Linux: sha256sum project.zip
    Mismatch = galat file / corrupt download. Examiner integrity check karta hai ki tumhari submitted copy hi run ho rahi hai.

  58. 58
    Types of CSS (Inline, Internal, External).
    Times asked 3
    Official solution

    SimpleCSS 3 tarikon se lagti hai, priority Inline > Internal > External (same specificity pe).

    Inline: style='color:red' element pe. Highest priority, lekin reuse nahi. Debugging mushkil.
    Internal: <style> tag HTML head mein. Us page tak limited.
    External: style.css file. Large project ke liye best — ek jagah change, saari pages update.

    Example same button pe teeno:
    /* external */ .btn { color: blue; }
    /* internal */ .btn { color: green; }
    <!-- inline --> <button class='btn' style='color:red'> → red jeetega

    ID (#box) class (.btn) se strong, class element (button) se strong.
    !important sabko override karta hai — avoid karo.
    Large project: external CSS preferred.

  59. 59
    CSS priority/order of precedence.
    Times asked 2
    Official solution

    SimpleCSS 3 tarikon se lagti hai, priority Inline > Internal > External (same specificity pe).

    Inline: style='color:red' element pe. Highest priority, lekin reuse nahi. Debugging mushkil.
    Internal: <style> tag HTML head mein. Us page tak limited.
    External: style.css file. Large project ke liye best — ek jagah change, saari pages update.

    Example same button pe teeno:
    /* external */ .btn { color: blue; }
    /* internal */ .btn { color: green; }
    <!-- inline --> <button class='btn' style='color:red'> → red jeetega

    ID (#box) class (.btn) se strong, class element (button) se strong.
    !important sabko override karta hai — avoid karo.
    Large project: external CSS preferred.

  60. 60
    Why does Inline CSS have the highest priority?
    Times asked 1
    Official solution

    SimpleCSS 3 tarikon se lagti hai, priority Inline > Internal > External (same specificity pe).

    Inline: style='color:red' element pe. Highest priority, lekin reuse nahi. Debugging mushkil.
    Internal: <style> tag HTML head mein. Us page tak limited.
    External: style.css file. Large project ke liye best — ek jagah change, saari pages update.

    Example same button pe teeno:
    /* external */ .btn { color: blue; }
    /* internal */ .btn { color: green; }
    <!-- inline --> <button class='btn' style='color:red'> → red jeetega

    ID (#box) class (.btn) se strong, class element (button) se strong.
    !important sabko override karta hai — avoid karo.
    Large project: external CSS preferred.

  61. 61
    Difference between Inline and Internal CSS.
    Times asked 1
    Official solution

    Yeh live UI/CSS change hai. Examiner jo element bole uski CSS turant badlo.

    Bootstrap class badlo (btn-primary → btn-success, bg-dark → bg-warning) ya inline style='color:red; background:#eee'.
    Center: d-flex justify-content-center text-center. Navbar neeche: navbar fixed-bottom.

    Example

    <button class='btn btn-success' style='background:#16a34a'>Book</button>

    Pehle browser inspect karke class dhundo, phir template mein change karke refresh.

  62. 62
    Difference between Internal and External CSS.
    Times asked 1
    Official solution

    Yeh live UI/CSS change hai. Examiner jo element bole uski CSS turant badlo.

    Bootstrap class badlo (btn-primary → btn-success, bg-dark → bg-warning) ya inline style='color:red; background:#eee'.
    Center: d-flex justify-content-center text-center. Navbar neeche: navbar fixed-bottom.

    Example

    <button class='btn btn-success' style='background:#16a34a'>Book</button>

    Pehle browser inspect karke class dhundo, phir template mein change karke refresh.

  63. 63
    Cell Padding.
    Times asked 1
    Official solution

    Simplecellpadding cell ke andar gap, cellspacing cells ke beech gap.

    cellpadding: text aur cell border ke beech khali jagah (andar).
    cellspacing: do cells ke beech khali jagah (bahar).

    Old HTML: <table cellpadding='10' cellspacing='5'>
    Modern CSS:
    td { padding: 10px; } /* padding */
    table { border-spacing: 5px; } /* spacing */

    border-collapse: collapse spacing hata deta hai, borders mil jaate hain.

  64. 64
    Cell Spacing.
    Times asked 1
    Official solution

    Simplecellpadding cell ke andar gap, cellspacing cells ke beech gap.

    cellpadding: text aur cell border ke beech khali jagah (andar).
    cellspacing: do cells ke beech khali jagah (bahar).

    Old HTML: <table cellpadding='10' cellspacing='5'>
    Modern CSS:
    td { padding: 10px; } /* padding */
    table { border-spacing: 5px; } /* spacing */

    border-collapse: collapse spacing hata deta hai, borders mil jaate hain.

  65. 65
    Inline Styling.
    Times asked 1
    Official solution

    SimpleCSS page ko style karti hai — color, layout, font. HTML structure, CSS look.

    h1 { color: navy; } .card { padding: 16px; } #logo { width: 80px; }
    Selectors: element (h3), class (.btn), id (#nav), pseudo (:hover).
    display:flex — ek line/row mein items, justify-content/align-items se center.
    Multiple classes: saari apply, conflict pe specificity/order.
    Responsive: media queries / Bootstrap grid. Bina CSS limited (old tables) — practically CSS chahiye.

  66. 66
    What is SPA (Single Page Application)?
    Times asked 2
    Official solution

    SimpleAJAX page reload ke bina server se data laata hai. Aaj kal fetch() + Promises.

    fetch('/api/users').then(r => r.json()).then(data => { ... })
    Promise: future value (pending/fulfilled/rejected). fetch Promise return karta hai.
    SPA (Vue): ek HTML, baaki routes JS se, partial update. MAD1 generally full page render (Jinja) — submit pe poora refresh.
    async/await Promise ka clean syntax.

  67. 67
    What is a Component?
    Times asked 2
    Official solution

    Definition style question: 1 line simple Hinglish + project example + mini code.

    Template'X ka kaam Y hai. Mere project mein Z jagah use hua.'

    Example'Session login state rakhta hai. session[user_id]=u.id login pe, logout pe session.clear().'

    Agar topic Vue/Celery/Redis ho aur project mein nahi hai to sach bolo, theory example do.

  68. 68
    What is a Standalone Component?
    Times asked 1
    Official solution

    SimpleVue.js frontend framework — reactive UI components. MAD2 mein common, MAD1 optional.

    Component: reusable UI (Navbar.vue) + data + template.
    Props: parent → child data. Child → parent: $emit('update', val).
    Slots: parent child ke andar extra HTML daal sakta hai.
    Lifecycle: created (data setup), mounted (DOM ready — API call), updated, unmounted.
    v-model two-way bind. Vue Router SPA routes (routes.js). Vuex/Pinia global state; mutations sync change, actions async.
    Standalone component: khud ke saath compile, parent register kam.

  69. 69
    Lazy Loading in frontend.
    Times asked 1
    Official solution

    Simplelazy loading related objects tab load karta hai jab attribute access karte ho, pehle nahi.

    user = User.query.get(1)  # posts query nahi

    user.posts # ab query

    lazy=True / 'select' default. lazy='joined' eager join. lazy='dynamic' query object.
    uselist=False One-to-One (single object, list nahi). Hataoge to list mil sakti hai.
    Frontend lazy loading images alag cheez hai (viewport mein aaye tab load).

  70. 70
    Difference between Arrays and Lists.
    Times asked 1
    Official solution

    SimpleList changeable ordered, Tuple fixed ordered, Dict key-value.

    list: [1,2,3] — append, mutable, duplicate ok. Arrays jaisa lekin mixed types.
    tuple: (1,2) — immutable, dict key ban sakta hai.
    dict: {'name':'Ram'} — fast lookup by key. JSON objects dict ban jaate hain.
    set: unique items.
    Array (JS) ≈ Python list. JS object ≈ Python dict.
    Mutable: list, dict. Immutable: tuple, str, int.

  71. 71
    Lambda Function.
    Times asked 1
    Official solution

    Simple mix of small concepts examiners poochte hain:

    Enum: fixed choices (status = pending/approved). Python Enum ya DB Enum column.
    Lambda: one-line anonymous function. key=lambda x: x.name sort ke liye.
    datetime: dates/times. timedelta(days=1) yesterday. default=datetime.utcnow.
    os.getenv('SECRET_KEY') environment se config, hardcode nahi. .env alternative: actual OS env, config.py, vault.
    HTML metadata: <meta charset>, <meta name='viewport'> — page ke baare mein, body content nahi.
    HTTP metadata: headers (Content-Type, Set-Cookie).
    Request payload: body data (JSON/form).
    Namespace: naam collide na hon (Blueprint name, Python packages).
    Plugins: extra packages (Flask-Login). Package vs module: package folder with __init__, module ek .py file.

  72. 72
    Data structures in Python.
    Times asked 1
    Official solution

    SimpleList changeable ordered, Tuple fixed ordered, Dict key-value.

    list: [1,2,3] — append, mutable, duplicate ok. Arrays jaisa lekin mixed types.
    tuple: (1,2) — immutable, dict key ban sakta hai.
    dict: {'name':'Ram'} — fast lookup by key. JSON objects dict ban jaate hain.
    set: unique items.
    Array (JS) ≈ Python list. JS object ≈ Python dict.
    Mutable: list, dict. Immutable: tuple, str, int.

  73. 73
    Variable declarations (var, let, const).
    Times asked 1
    Official solution

    Simplevar old function-scope, let block-scope changeable, const block-scope reassign nahi.

    var x = 1; // hoisted, function scoped — avoid
    let count = 0; count = 1; // theek
    const PI = 3.14; // reassign error, object ke andar field change ho sakti hai
    Modern JS: let/const use karo, var mat karo.

  74. 74
    What is Cascading Effect (CSS)?
    Times asked 1
    Official solution

    Yeh live UI/CSS change hai. Examiner jo element bole uski CSS turant badlo.

    Bootstrap class badlo (btn-primary → btn-success, bg-dark → bg-warning) ya inline style='color:red; background:#eee'.
    Center: d-flex justify-content-center text-center. Navbar neeche: navbar fixed-bottom.

    Example

    <button class='btn btn-success' style='background:#16a34a'>Book</button>

    Pehle browser inspect karke class dhundo, phir template mein change karke refresh.

  75. 75
    Explain your project architecture.
    Times asked 2
    Official solution

    SimpleRoutes/controllers URLs handle karte hain. app.py app banata hai, models.py data, templates/ views, static/ CSS-JS.

    Typical structure:
    app.py / __init__.py → Flask app, db.init, register blueprints
    models.py → tables
    routes.py / views → @app.route functions
    templates/ → Jinja HTML
    static/ → css, images
    instance/*.db → SQLite

    Ek route explain karne ka template:
    1) URL + methods 2) Auth/role check 3) Form/query se data 4) Business rule (duplicate, slots) 5) db.session 6) render ya redirect

    Example GET+POST same route: GET form, POST save.
    Data HTML se: form name= → request.form. Data HTML ko: render_template(..., items=query).
    Nayi .py file: import karke use karo, warna Flask ko pata nahi. Folder rename: imports/paths/templates check.

  76. 76
    Explain project improvements you would like to make.
    Times asked 1
    Official solution

    Simple2-3 honest improvements + 1 security + 1 UX.

    Example

    password hashing/CSRF tighter, Redis cache, tests, pagination, email verify, rate limit login, better mobile CSS.

    Challenges: relationships/cascade, concurrent booking, Jinja inheritance.
    Rate: 7-8/10 with reason — 10/10 arrogant, 3/10 confidence khatam.
    Security extra: HTTPS, hashed passwords, CSRF, SQL injection (ORM), login attempts, file type check.

  77. 77
    Do you have any questions for the proctor?
    Times asked 1
    Official solution

    Yeh MAD-1 viva question tumhare project ke context se linked hai. Short answer is structure se do:

    Pehle 1 line definition/purpose, phir tumhare project ka example, phir chhota code/flow.

    Typical Flask flowBrowser request → @app.route controller → SQLAlchemy model/DB → Jinja template response.

    Auth: session['user_id'] + role check. CRUD: add/commit, query.all, field update, delete.
    Live change maange to: related model → route → template, phir browser refresh karke dikhao.

    Example (generic create):
    obj = Model(name=request.form.get('name'))

    db.session.add(obj); db.session.commit()
return redirect(url_for('list_view'))
Tag summary

No tags.

Created for educational purposes only. Questions are based on students' personal experiences and may not reflect actual exam content.