Tips for this examiner: do all the questions in the sheet for th same proctor and have thorough knowledge of your code.
Student reviews
Tushar BhartiMAD1
Shared viva questions from response sheet: Basis overview is like he will ask questions related to vue and backend , though questions are same as he asked above but still I am writing.; What is Props , Slot, How to pass data from child to parent; What is Vue Cli and vue cdn and what you have used.
Questions remembered
Basis overview is like he will ask questions related to vue and backend , though questions are same as he asked above but still I am writing.
What is Props , Slot, How to pass data from child to parent
What is Vue Cli and vue cdn and what you have used.
What is Webhooks??
What is Sqlalchemy??
What is Difference between v-model and v-bind?
What is V-if and V-show?
What is lifecycle in vue js and explain them??
What have you used for security purpose?? Flask Security or JWT??
He will ask for showing celery work.
He will ask a change in code type of questions and that he will ask randomly so you can't predict that (I was not able to do so I told sorry sir , I am not able to figure it out), So you can do the same if needed π. Basically prepare all the questions from his side in this sheet you are good to go as he focuses majorly on vue js and backend. Overall Chill Proctor ππ I will update my grade after I will get the results as how he penalize me for not solving code change question
BharatMAD1
Shared viva questions from response sheet: What is Vue?; Are you using CLI or CDN?; What are webhooks?
Questions remembered
What is Vue?
Are you using CLI or CDN?
What are webhooks?
What is ORM and are you using it?
What is ORM's advantage?
What are Vue lifecycle hooks?
What is difference between v-if and v-show?
Changed the code - Add table to one page instead of Card view. Debugged the model.
Coding Question: Implement the restriction so that a student who is already placed cannot apply to any other placement drive. He wanted to see the change working.
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
(I think he asked one more question, but cant remember it, but it wasn't out of the sheet)
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
The proctor was very calm and patient throughout the interview, he was silent throughout the demo. He did not ask anything outside the commonly shared question sheet. The coding question was also the same placement restriction that many previous students had reported.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Prepare the theory questions from the response sheet thoroughlyβthey are more than enough. Know your project flow and be able to explain your code confidently. The proctor is friendly and does not try to confuse students.
Show demo [ dwnlded from the portal. Setup the celery timing to next 5mins and ranthe app] He was really silent, I calmly created a venv installed the requiremnts and changed the celery time, then ran. He didn't ask anything, I kept explaining my app [ gone through each feature ] - didn't even know if he was listening, after showing wevrythins I aksed "that si sir any feature to be shoen next?" no reply "Hello sir?" and then he replied "yeah okay"
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
"show me the generated reports in mail". Only admin was generated,(since the suer boooking was done after the set 5 mins the mail was not received] I explained that and showed the previsously geenrated report. He said that's okay good.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Go to admin dashboard
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
[ asked the same code from the sheet] trekking app - Whenever the user books it should be in "pending" and admin should approve the booking , then only it should show booked.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
Implemeted it and showed him, said "good"
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
Theory questions followed next
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
7
Authentication vs Authorization?
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
8
Compositiona dn potions API
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: He's silent, doesn't try to ask any cross questions, just the one from the sheet. A good one
The interviewer had his camera on throughout the meeting.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
He looked Tamil Black Guy.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
He was kind and mostly quiet during the session.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
For the first 10 minutes, I gave a demo of the project. At one point, I asked, "Hello? Hello?" to make sure he was still there, and he replied, "Yeah, okay, good." After the demo, he asked me to make a code change.
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
Task 1
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
7
He asked me to implement the following rule:
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
8
Β«Once a student is placed, the student should not be able to apply to any other placement drive.Β»
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
9
I completed this change in about 5 minutes. It only required a couple of lines of code.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
10
Task 2
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
11
He then gave me another requirement:
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
12
Β«A student can apply to a maximum of 2 drives and can receive placements from a maximum of 2 companies, but no more than that.Β»
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
13
I implemented the logic, but after making the changes, the API started throwing an error. The interviewer smiled and said:
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
14
Β«"You did the last change in 2 minutes, and now you can't do this simple extra change?"Β»
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
15
I tried to explain my approach and the logic I had implemented, but the API issue remained unresolved during the interview.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
16
Technical Questions
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
17
After the coding tasks, he asked me a few conceptual questions:
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Most of the call was silent,
He also came late.
And the theory qns are always always repeated
The same 4-5 qns everytime
Code qns just ask the previous person who have viva on the same day.
Mostly same code qn
And take time to code
Or else he will give another code qn
I prepared only for 1 hr
And project was made by claude.
Best of luck
download the repo and start demo- i 1st showed the app and went to vs code and kept showing all code-showed him all functionality- all the restrictions as required by rubrics 3)coding question - asked me to disable a student applying for another job if he is already placed-got stuck patiently waited for me to complete -he will also want ot see it working- so ensure the code works
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
what securities have you used -what's the difference between session cookies and jwt
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
show me the reports generated from the app- i had the monthly report and reminder for interview and offer letter
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
different status of vue- before mounted ,mounted etc..
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: he has the above fixed question paper as i have seen in the past as well. Ensure you don't have the feature enable so that you can prepare this question and enable it in front of him. very cool. All the best!!
Exactly same theory questions which have been mentioned in the sheet. Same HMS project coding questions -> how a patient can book appointments with different doctors on same date and slot. I had practiced that question before viva so i easily implemented.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Practice all theory questions which have been mentioned in the sheet bz they will ask you a lot theory question and for coding you will be luck if someone has given viva with that proctor before you on some project statement , just see what he has been asking coding question for your project and try to implement in you project before viva start. All the best, don't warry proctor is very chill guy.
Why are you using JWT and not SessionStorage ( Flask )
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
How is data sent from parents to child and vice versa in Vue ( Props , Emits , Slots )
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
Can an accepted student apply in another company ? if yes make it so that he can't ( I made it so the student can't see any drives after being accepted)
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
Make the accepted student be able to see the drives but not apply . ( Stopped me midway after I explained the solution did not need to code the answer )
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Every single question he asks is in the sheet.
-coding qn: currently if a student got placed that student can still apply for other drives, sir asked me to change the code such that a student who got placed cannot apply for other drives.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
-cdn cs cli
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
-how is communication happening btw vue components
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
and two more i don't remember. But don't worry very nice proctor, he will guide you through everything and is very calm.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: You are in safe hands if you got him (be prepared tho). First of all he enabled his video which did put my mind at ease for some reason since I could see him as well. When the viva started I was very tensed but as it proceeded I found myself to be very calm because of him. Best examiner I got so far tbh
implement the functionality such that patient cannot book two or more appointments at same time
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Prepare the theoretical question as they are same and coding question depends on any missing functionality implementation or anything he find is not valid so could ask to change
He interrupted the demo and asked to create appointment by same patient for two different doctor on same day and same slot. He wants to see if it was allowed or not. I said that it's allowed . So he asked me to apply the restrictions so a patient can't do it.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
Asked me to show all jobs. But completed viva after seeing just one job.
add new functionality in dashboard if student can accept or reject offers(agr multiple offers milgye to)
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
authentication used
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
celery, redis,caching
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
then asked me about my degree and how this degree aids me in that , celery partially work krra tha to uspe kuch sawal,phir pucha jo chize shi se nhi kri hai vo kyu nhi kri time nhi tha ya bhulgye ya miss hogyaa
- show me the complete demo ( register a company, approve by admin, create a student, cretae a drive, make student apply, make him selected show everything)
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
- adviced that it would be more efficient if a student selected in any drive won't be able to apply in any other drive ( my app was not having this feature)
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
- asked me to implement this advice
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
- version of vue, vuex, pinia what they are why am i using what i am using
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: be relaxed he won't eat you, pretty chill proctor, will even advice you and might even end the level2 viva in 30 mins and still pass you
- how is JWT different from session based management, which is better
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
- Which state management have you used (pinia)
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
7
- Which is the older version of the state management, in which version is pinia being used
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
8
- asked for demo of the project, all the celery jobs
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
9
- there was an issue with drive creation where company could create drive for past dates. so that became my coding question - implement the current or future date drive creation
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: very easy going proctor, he is more frontend focused, also theory focused so be prepared for it. He will give honest suggestions and constructive feedback, so make sure to ask your performance in the end
Implement functionality such that the user can't book same parking lot if he has an already active booking
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
What r the patches from vue 2 to 3
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Vue memo
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
Tree smth idr
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
That's all I remember ig 1 2 more he had asked
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: He's pretty chill ig he was in call in bw but I didn't expect these questions coz it wasn't there in the sheets looks like he got a new set of questions be confident and stay truthful about ur implementation but not too honest atb
- Make the parking lot name case sensitive so it given an error (Like python treats uppercase and lowercase different like IITM and iitm is different but the name is same, so I implemented that.)
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Chill proctor, theory should be good, go through your code thoroughly.
- Verify Student id - Show the demo - Show backend Jobs - Qustions
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
Show models I was already having unique constraint in my Student model so he asked me if uniques means case sensitivity or not then if user enter for eg Mad 1 and then mad 1, it should raise the error .
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: One thing i understood about this proctor that, he is straight forward and he almost has a fix set of questions to ask as mentioned under his response sheet. No follow up questions asked and if one questions gets over he'll have another question ready in almost same order as mentioned by other the students.
so i was not able to change the code, i tried some logic here and there, almost got the output correct but it was not correct.
So he just asked me to leave it and dont take stress.
then he was telling his was of evaluation. so basically he wants to check if the student has completed or knows overall thing of an application, and not just completing the requirements. many students just complete the requirements, but the aim of these projects are to make us industry ready.
(but tbh since i am doing dual degree, i wont invest much of my time creating basic crud app, because my logic is already good, anyways hope this review is helpful for other students)
after complete demonstration, he asked me about Vue.js
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Props, slot and emits and the other questions that are mentioned there this sheet.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
asked me to change in the code so that a sponsor can't create another campaign with the same name. He helped me in doing this when I was facing problems.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Very good proctor that everyone would like him. Very polite and supportive as well as professional. Just prepare from this sheet and you will be all set to go. A perfect experience at the end of Web development project π
Vuex - I somewhat struggled in this part, but he was chill about.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Webhooks - this also I struggle to exact my explanation - he was chill.
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: He is chill, nothing to worry about.
Other students who had the same proctor also said the same.
Just study about everything about your project, and the questions I and other students mentioned in this sheet, then viola, you aced.
Coding Question - How the customer is able to book a service on the same date, so he asked to implement this. The customer should not be able to book a service on the same date as the date of request, and for the same service as well.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: All questions were from the sheet only. Study all the questions asked by the proctor.
Told me to show add one more same service category which I added in the past. But my system added the same service so he told me that same service category should not be duplicated.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: He is very chill but he can ask you more questions
Lifecycle hooks The proctor was friendly and gave me guidance for improving the project. He also asked me to implement review disable feature in first 5 mins, which i partially implemented and proctor was satisfied with that. At the end, he asked if you have anything more to show.
Times asked1
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: do all the questions in the sheet for th same proctor and have thorough knowledge of your code.
Basis overview is like he will ask questions related to vue and backend , though questions are same as he asked above but still I am writing.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
What is Props , Slot, How to pass data from child to parent
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
What is V-if and V-show?
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
He will ask for showing celery work.
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
He will ask a change in code type of questions and that he will ask randomly so you can't predict that (I was not able to do so I told sorry sir , I am not able to figure it out), So you can do the same if needed π. Basically prepare all the questions from his side in this sheet you are good to go as he focuses majorly on vue js and backend. Overall Chill Proctor ππ I will update my grade after I will get the results as how he penalize me for not solving code change question
Asked to add a category with one of the existing name of category in the database. He told me this'll create a copy of category, this should not happen. While adding it should show a warning. ( Same for product also)
Times asked2
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Asked to set manufacture date to today's date and expiry date to yesterday's. This also should not work, it should give warning while adding or updating the product. 13.Asked about memcached and rediscached
He will ask a change in code type of questions and that he will ask randomly so you can't predict that (I was not able to do so I told sorry sir , I am not able to figure it out), So you can do the same if needed π. Basically prepare all the questions from his side in this sheet you are good to go as he focuses majorly on vue js and backend. Overall Chill Proctor ππ I will update my grade after I will get the results as how he penalize me for not solving code change question
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
(I think he asked one more question, but cant remember it, but it wasn't out of the sheet)
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
The proctor was very calm and patient throughout the interview, he was silent throughout the demo. He did not ask anything outside the commonly shared question sheet. The coding question was also the same placement restriction that many previous students had reported.
Times asked2
Official solution
SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Prepare the theory questions from the response sheet thoroughlyβthey are more than enough. Know your project flow and be able to explain your code confidently. The proctor is friendly and does not try to confuse students.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
* What is the difference between Optional Chaining and the Nullish Coalescing Operator?
Times asked2
Official solution
SimpleType coercion = auto type convert (JS '5'+1 β '51'). Strict === prefer karo. TypeScript types coercion kam karta hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
7
* What is SQLAlchemy?
Times asked1
Official solution
SimpleSQLAlchemy Python ka sabse popular ORM hai. MAD1 mein Flask-SQLAlchemy wrapper use hota hai.
db = SQLAlchemy(app)
class Book(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(80), nullable=False)
Operations: db.session.add(obj), .commit(), .delete(obj), Model.query.all(), .filter_by(), .get_or_404(id).
db.Model ek class hai (function nahi). db object engine + session + metadata hold karta hai.
SQLALCHEMY_TRACK_MODIFICATIONS=False extra signals band karta hai, performance warning hatati hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
8
* Coding Question: Write the code to ensure that a student can apply to a maximum of two drives.
Times asked2
Official solution
SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
9
* Coding Question: Write the code to prevent a new student from applying to a new drive under the given condition.
Times asked2
Official solution
SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
10
* Explain all the background tasks implemented in your project, including the reminder email task and the monthly report task.
Show demo [ dwnlded from the portal. Setup the celery timing to next 5mins and ranthe app] He was really silent, I calmly created a venv installed the requiremnts and changed the celery time, then ran. He didn't ask anything, I kept explaining my app [ gone through each feature ] - didn't even know if he was listening, after showing wevrythins I aksed "that si sir any feature to be shoen next?" no reply "Hello sir?" and then he replied "yeah okay"
Times asked2
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
"show me the generated reports in mail". Only admin was generated,(since the suer boooking was done after the set 5 mins the mail was not received] I explained that and showed the previsously geenrated report. He said that's okay good.
Times asked2
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.
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
[ asked the same code from the sheet] trekking app - Whenever the user books it should be in "pending" and admin should approve the booking , then only it should show booked.
Times asked2
Official solution
SimpleProject overview: problem β roles β main entities β key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
10
Β«A student can apply to a maximum of 2 drives and can receive placements from a maximum of 2 companies, but no more than that.Β»
Times asked2
Official solution
SimpleProject overview: problem β roles β main entities β key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
11
I implemented the logic, but after making the changes, the API started throwing an error. The interviewer smiled and said:
Times asked2
Official solution
SimpleInt column mein string daalne pe SQLAlchemy/DB type error ya Integrity/StatementError. Empty table pe bhi same validation fail β row count matter nahi.
Example
# SQLite may coerce sometimes; Postgres: invalid input syntax for integer
Spot(status='free', lot_id='abc') # lot_id int β error
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
12
Β«"You did the last change in 2 minutes, and now you can't do this simple extra change?"Β»
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
13
I tried to explain my approach and the logic I had implemented, but the API issue remained unresolved during the interview.
Viva tipFunction signature + 3-4 important lines + edge case.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
14
Technical Questions
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
15
After the coding tasks, he asked me a few conceptual questions:
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Most of the call was silent,
He also came late.
And the theory qns are always always repeated
The same 4-5 qns everytime
Code qns just ask the previous person who have viva on the same day.
Mostly same code qn
And take time to code
Or else he will give another code qn
I prepared only for 1 hr
And project was made by claude.
Best of luck
download the repo and start demo- i 1st showed the app and went to vs code and kept showing all code-showed him all functionality- all the restrictions as required by rubrics 3)coding question - asked me to disable a student applying for another job if he is already placed-got stuck patiently waited for me to complete -he will also want ot see it working- so ensure the code works
Times asked2
Official solution
SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
show me the reports generated from the app- i had the monthly report and reminder for interview and offer letter
Lifecycle = component ki zindagi: created (instance, DOM nahi) β mounted/onMounted (DOM ready β fetch, Chart.js yahi) β updated β unmounted (clearInterval).
Dashboard API created mein isliye nahi ki $el/canvas missing ho sakta. Composition API: onMounted(() => {}) setup ke andar. Options: mounted() method. Mix mat.
Examiner 'konsa hook use kiya' β related .vue kholo, line padh ke bolo.
Advice: he has the above fixed question paper as i have seen in the past as well. Ensure you don't have the feature enable so that you can prepare this question and enable it in front of him. very cool. All the best!!
Exactly same theory questions which have been mentioned in the sheet. Same HMS project coding questions -> how a patient can book appointments with different doctors on same date and slot. I had practiced that question before viva so i easily implemented.
Times asked2
Official solution
SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Practice all theory questions which have been mentioned in the sheet bz they will ask you a lot theory question and for coding you will be luck if someone has given viva with that proctor before you on some project statement , just see what he has been asking coding question for your project and try to implement in you project before viva start. All the best, don't warry proctor is very chill guy.
SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho β mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya β fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
Viva tipcreated: data setup, DOM nahi. mounted/onMounted: $el mil gaya β fetch yahi. Dashboards isliye onMounted use karti hain.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
Why are you using JWT and not SessionStorage ( Flask )
Times asked2
Official solution
SimpleMAD1 mein usually session-based auth: login pe session['user_id'], har request pe verify.
Example
session['user_id'] = user.id
uid = session.get('user_id')
user = User.query.get(uid)
Viva tipSECRET_KEY set karo warna session insecure. logout pe session.clear().
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Can an accepted student apply in another company ? if yes make it so that he can't ( I made it so the student can't see any drives after being accepted)
Times asked2
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
Make the accepted student be able to see the drives but not apply . ( Stopped me midway after I explained the solution did not need to code the answer )
-coding qn: currently if a student got placed that student can still apply for other drives, sir asked me to change the code such that a student who got placed cannot apply for other drives.
Times asked2
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
-how is communication happening btw vue components
Times asked2
Official solution
SimpleVue = UI ka smart assistant. Data badlo, screen khud update. MAD1 Jinja har click pe naya HTML.
Viva tipFayde: easy, SFC, reactivity. Vs React: chhota learning curve. Vs plain JS: UI state auto-update.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
and two more i don't remember. But don't worry very nice proctor, he will guide you through everything and is very calm.
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: You are in safe hands if you got him (be prepared tho). First of all he enabled his video which did put my mind at ease for some reason since I could see him as well. When the viva started I was very tensed but as it proceeded I found myself to be very calm because of him. Best examiner I got so far tbh
Project example: resources.py new Resource. Test Thunder. Optional Vue fetch.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Prepare the theoretical question as they are same and coding question depends on any missing functionality implementation or anything he find is not valid so could ask to change
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
He interrupted the demo and asked to create appointment by same patient for two different doctor on same day and same slot. He wants to see if it was allowed or not. I said that it's allowed . So he asked me to apply the restrictions so a patient can't do it.
Times asked2
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
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Admin applications table.
Project example: Admin applications table.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
modify to remove department matching criteria from code
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')
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
use of sqlalchemy
Times asked1
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()
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
rbac
Times asked1
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'))
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
authentication used
Times asked2
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)
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
7
then asked me about my degree and how this degree aids me in that , celery partially work krra tha to uspe kuch sawal,phir pucha jo chize shi se nhi kri hai vo kyu nhi kri time nhi tha ya bhulgye ya miss hogyaa
Times asked2
Official solution
SimpleCelery = background naukri. HTTP request ko 10 second email bhejne ke liye mat rokna.
Distributed task queue: aap function ko abhi nahi, worker process mein later/retry/schedule pe chalaate ho.
- show me the complete demo ( register a company, approve by admin, create a student, cretae a drive, make student apply, make him selected show everything)
Times asked2
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
- adviced that it would be more efficient if a student selected in any drive won't be able to apply in any other drive ( my app was not having this feature)
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
- option api vs composition api
Times asked1
Official solution
SimpleOptions: data methods computed alag. Composition: setup() logic group, reuse.
computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.
SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.
Project example: script setup vs export default options β open file.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
- redis
Times asked1
Official solution
SimpleRedis fridge pe sticky note hai β poori kitchen (database) kholne ki zarurat nahi.
Redis in-memory key-value store hai. Data RAM mein rehta hai, isliye disk wale SQLite/Postgres se kai guna tez.
MAD2 mein Redis do kaam karta hai:
1) Cache β same venue/show/dashboard JSON baar-baar DB se mat nikaalo.
2) Celery message broker β Flask task queue mein daalta hai, worker uthata hai.
Source of truth database hi hai. Redis band ho to cache miss ho jaata hai aur Celery queue ruk sakti hai. Crash pe cache gayab ho sakta hai β isliye important data sirf Redis mein mat rakho.
Project example: GET /api/venues pehle Redis dekho. Miss pe SQLAlchemy query, phir SET with timeout. Celery worker Redis list se daily reminder uthata hai.
Viva tipCache ke liye db=1, broker ke liye db=0 rakhna smart hai taaki keys mix na hon. Viva mein redis-cli ping β PONG dikhana strong hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: be relaxed he won't eat you, pretty chill proctor, will even advice you and might even end the level2 viva in 30 mins and still pass you
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai β jo use kiya wahi justify karo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
- which security was used
Times asked2
Official solution
SimplePassword DB mein plain text mat rakho β hash store karo jo reverse nahi hota.
from werkzeug.security import generate_password_hash, check_password_hash
user.password = generate_password_hash(request.form['password'])
check_password_hash(user.password, form_password)
Hashing β encryption. Leak pe bhi original password nahi milta (easy passwords rainbow table se β isliye salt + strong hash).
Column String(200) kyunki hash lamba hota hai. unique=True password pe mat lagao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
- how is JWT different from session based management, which is better
Times asked2
Official solution
SimpleMAD1 mein usually session-based auth: login pe session['user_id'], har request pe verify.
Example
session['user_id'] = user.id
uid = session.get('user_id')
user = User.query.get(uid)
Viva tipSECRET_KEY set karo warna session insecure. logout pe session.clear().
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
- Which is the older version of the state management, in which version is pinia being used
- there was an issue with drive creation where company could create drive for past dates. so that became my coding question - implement the current or future date drive creation
Times asked2
Official solution
SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: very easy going proctor, he is more frontend focused, also theory focused so be prepared for it. He will give honest suggestions and constructive feedback, so make sure to ask your performance in the end
Viva tipFayde: easy, SFC, reactivity. Vs React: chhota learning curve. Vs plain JS: UI state auto-update.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Tree smth idr
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
That's all I remember ig 1 2 more he had asked
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: He's pretty chill ig he was in call in bw but I didn't expect these questions coz it wasn't there in the sheets looks like he got a new set of questions be confident and stay truthful about ur implementation but not too honest atb
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'))
- Make the parking lot name case sensitive so it given an error (Like python treats uppercase and lowercase different like IITM and iitm is different but the name is same, so I implemented that.)
Times asked2
Official solution
SimpleProject overview: problem β roles β main entities β key flows (register, book, admin approve).
Viva tip1 minute elevator pitch ready rakho, phir demo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Chill proctor, theory should be good, go through your code thoroughly.
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.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai β jo use kiya wahi justify karo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Show models I was already having unique constraint in my Student model so he asked me if uniques means case sensitivity or not then if user enter for eg Mad 1 and then mad 1, it should raise the error .
Times asked2
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)
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: One thing i understood about this proctor that, he is straight forward and he almost has a fix set of questions to ask as mentioned under his response sheet. No follow up questions asked and if one questions gets over he'll have another question ready in almost same order as mentioned by other the students.
so i was not able to change the code, i tried some logic here and there, almost got the output correct but it was not correct.
So he just asked me to leave it and dont take stress.
then he was telling his was of evaluation. so basically he wants to check if the student has completed or knows overall thing of an application, and not just completing the requirements. many students just complete the requirements, but the aim of these projects are to make us industry ready.
(but tbh since i am doing dual degree, i wont invest much of my time creating basic crud app, because my logic is already good, anyways hope this review is helpful for other students)
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai β jo use kiya wahi justify karo.
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Example
db.session.query(func.count(Booking.id)).scalar()
Project example: func.count(Booking.id).
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
8
difference in 1-way and 2-way binding
Times asked2
Official solution
SimpleUngli rakhe to 4-line formula β panic ki jagah structure.
Viva tipFunction signature + 3-4 important lines + edge case.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
10
lifecycle of vue js
Times asked2
Official solution
SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho β mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya β fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.
SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.
Project example: Card props venue emit select.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
asked me to change in the code so that a sponsor can't create another campaign with the same name. He helped me in doing this when I was facing problems.
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: Very good proctor that everyone would like him. Very polite and supportive as well as professional. Just prepare from this sheet and you will be all set to go. A perfect experience at the end of Web development project π
Viva tipFayde: easy, SFC, reactivity. Vs React: chhota learning curve. Vs plain JS: UI state auto-update.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: He is chill, nothing to worry about.
Other students who had the same proctor also said the same.
Just study about everything about your project, and the questions I and other students mentioned in this sheet, then viola, you aced.
Viva tipFunction signature + 3-4 important lines + edge case.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Coding Question - How the customer is able to book a service on the same date, so he asked to implement this. The customer should not be able to book a service on the same date as the date of request, and for the same service as well.
Times asked2
Official solution
SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: All questions were from the sheet only. Study all the questions asked by the proctor.
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
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
Vue Lifecycle hooks
Times asked1
Official solution
SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho β mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya β fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai β jo use kiya wahi justify karo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
Coding Challenge: for any given sponsor "campaign name" shouldnt be same.
Told me to show add one more same service category which I added in the past. But my system added the same service so he told me that same service category should not be duplicated.
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: He is very chill but he can ask you more questions
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.
SimplePassword DB mein plain text mat rakho β hash store karo jo reverse nahi hota.
from werkzeug.security import generate_password_hash, check_password_hash
user.password = generate_password_hash(request.form['password'])
check_password_hash(user.password, form_password)
Hashing β encryption. Leak pe bhi original password nahi milta (easy passwords rainbow table se β isliye salt + strong hash).
Column String(200) kyunki hash lamba hota hai. unique=True password pe mat lagao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
Advice: do all the questions in the sheet for th same proctor and have thorough knowledge of your code.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai β jo use kiya wahi justify karo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
2
What is ORM and are you using it?
Times asked2
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
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
What is ORM's advantage?
Times asked2
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
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
Changed the code - Add table to one page instead of Card view. Debugged the model.
Times asked2
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)
Viva tipFunction signature + 3-4 important lines + edge case.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Data binding. V- model and v- bind.
Times asked2
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)
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
Template inheritance.
Times asked2
Official solution
Simpleextends poora layout inherit karta hai, include chhota piece insert karta hai.
extends: child page base.html ka structure use karti hai, blocks override karti hai. Ek hi parent.
include: navbar.html / footer.html jahan chaho insert. Kai baar use ho sakta hai.
base.html:
{% block content %}{% endblock %}
home.html:
{% extends 'base.html' %}
{% block content %}<h1>Home</h1>{% endblock %}
{% include 'navbar.html' %} β navbar har page pe
Fayda: header/footer ek jagah, change once β saari pages update. MAD1 mein almost har project use karta hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
Local storage vs session storage.
Times asked1
Official solution
SimpleMAD1 mein usually session-based auth: login pe session['user_id'], har request pe verify.
Example
session['user_id'] = user.id
uid = session.get('user_id')
user = User.query.get(uid)
Viva tipSECRET_KEY set karo warna session insecure. logout pe session.clear().
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
Overall good proctor. At last he gave some feedback.
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
7
Most of the questions he asked were in this sheet.
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Viva tipFunction signature + 3-4 important lines + edge case.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
8
7)What are Lifecycle hooks?
Times asked1
Official solution
SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho β mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya β fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
13
12)How many celery tasks have you implement?
Times asked2
Official solution
SimpleGino jo implement: generally reminder, monthly, export. Beat schedule dikhao.
Don't claim 5 if 2.
Celery Python ka distributed task queue β HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() β Redis broker β Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process β mix mat karo.
Demo: tin terminals β redis-server, celery worker, celery beat β plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: Open beat dict count keys + extra delay() tasks.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Asked to add a category with one of the existing name of category in the database. He told me this'll create a copy of category, this should not happen. While adding it should show a warning. ( Same for product also)
Times asked2
Official solution
SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
Asked to set manufacture date to today's date and expiry date to yesterday's. This also should not work, it should give warning while adding or updating the product. 13.Asked about memcached and rediscached
Memcached: simple key-value, yahi. Redis: data structures + expire + optional disk dump.
MAD2 Redis choose β cache aur broker ek hi process. Memcached Celery nahi chalaata.
Redis in-memory key-value store hai β fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache β same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker β Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) β hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Viva tipWorker + Redis bina Beat ke user-triggered chalega. Scheduled jobs ke liye Beat bhi chahiye.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
show me the data models you have used. The proctor was friendly enough. He will even give his suggestions at the end :)
Times asked2
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)
Viva tipFayde: easy, SFC, reactivity. Vs React: chhota learning curve. Vs plain JS: UI state auto-update.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
what is SQLAlchemy
Times asked3
Official solution
SimpleSQLAlchemy Python ka sabse popular ORM hai. MAD1 mein Flask-SQLAlchemy wrapper use hota hai.
db = SQLAlchemy(app)
class Book(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(80), nullable=False)
Operations: db.session.add(obj), .commit(), .delete(obj), Model.query.all(), .filter_by(), .get_or_404(id).
db.Model ek class hai (function nahi). db object engine + session + metadata hold karta hai.
SQLALCHEMY_TRACK_MODIFICATIONS=False extra signals band karta hai, performance warning hatati hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
4
which all databases supported in SQLAlchemy
Times asked1
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()
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.
Viva tipFunction signature + 3-4 important lines + edge case.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
7
what is v-model
Times asked1
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)
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
8
what is v-bind
Times asked1
Official solution
Simplev-bind one-way: JS β HTML attribute. UI se data automatic nahi aata.
Images src, disabled, class object, href. Colon shorthand.
Dynamic class :class="{ active: isOn }".
Directives Vue ke special attributes hain β HTML ko superpower: v-if/v-show, v-for, v-bind (:), v-on (@), v-model.
v-if DOM se hataata/jodta. v-show sirf CSS display. Rare/permission: v-if. Bar-bar toggle: v-show. v-model two-way form. v-bind one-way JSβattribute.
:key v-for pe zaroori warna Vue galat reuse. v-html XSS. Secret UI ke liye sirf v-if kaafi nahi β API 403 bhi.
MAD1 Jinja server HTML. MAD2 yeh directives browser mein reactive.
Example
<img :src="posterUrl" :alt="title">
<button :disabled="loading">Save</button>
<div :class="{ active: isOn }">
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai β jo use kiya wahi justify karo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Asked me to display the total no of tickets left for the show in the booking screen
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Bridge to MAD2 skills.
Project example: Bridge to MAD2 skills.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
3
Demonstrate your complete project.
Times asked2
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: requirements.txt + package.json top 6 open karke bolo.
Viva tipHar lib ek line why: CORS alag origin, Redis tez, Celery async, Chart.js dashboard.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
6
What's the backbone/architecture of your application?
App context DB. Args serializable. How many jobs: reminder, monthly, export β gino honestly.
Celery Python ka distributed task queue β HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() β Redis broker β Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process β mix mat karo.
Demo: tin terminals β redis-server, celery worker, celery beat β plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: tasks.py + config schedule + POST export.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
9
Show how emails are being sent from your application.
Times asked1
Official solution
SimpleMAIL config Message MailHog. Show how emails sent SMTP. Show Celery-generated emails. Where email sending logic.
tasks.py + MailHog.
Flask-Mail / SMTP se mail. Local MailHog fake server: SMTP 1025, UI 8025 β internet nahi, viva safe.
Asli send Celery task mein, request thread mein nahi. Beat 6pm reminder, export ke baad CSV attach optional.
MAIL_SERVER localhost demo. Gmail SMTP student account pe block common. Body mein user name personalization examiner dekhta hai.
Project example: screenshot 8025.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
10
What styling approach have you used on the frontend?
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Inspect a button class. bootstrap CDN or npm.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
11
What is Flask?
Times asked6
Official solution
SimpleFlask halka Python web framework. MAD2 REST API. Open source BSD.
Large apps possible blueprints+gunicorn. Flask(__name__) paths. Dev server not prod.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: GET /api/hello.
Project example: GET /api/hello.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
13
Explain HTTP verbs (GET, POST, PUT, PATCH, DELETE).
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: List 4 you actually coded.
Project example: List 4 you actually coded.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
16
What other authentication mechanisms are available in Flask besides JWT?
Times asked1
Official solution
SimpleFlask-Login sessions, HTTP Basic, OAuth. We used JWT. Available besides JWT.
What other authentication Flask.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX β asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: Not implemented OAuth.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
17
How is JWT built?
Times asked1
Official solution
Simpleheader+payload base64 HMAC secret β signature three segments. How JWT built.
HS256.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX β asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: jwt.io.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
18
How is JWT validated?
Times asked1
Official solution
SimpleSplit decode hmac compare exp < now user exists. Invalid 401. How JWT validated.
Library does it @jwt_required.
Authentication poochta hai "tu kaun hai?", Authorization poochta hai "tujhe yeh kaam karne ki permission hai?"
Authentication: login. Username + password hash check. Success pe JWT/session. Galat credentials = 401.
Authorization: uske baad role. Admin hi venue/lot delete kare, student nahi = 403 (logged in ho, allowed nahi).
MAD2: POST /api/login = authentication. @jwt_required identity. @roles_required('admin') ya Vue v-if="isAdmin" = authorization. Frontend hide sirf UX β asli deny backend pe.
Validation alag: form sahi bhara (email format, age 18+). Woh identity prove nahi karta. Password store hash (Werkzeug), JWT payload padha ja sakta hai isliye secret mat daalo.
Project example: Wrong token Postman 401.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
19
JWT vs Session-based authentication.
Times asked1
Official solution
SimpleSession school id card office mein rakha. Token photocopy jo tum har baar dikhate ho.
Session: Set-Cookie, server store, MAD1 Flask-Login. CSRF risk cookies auto-send.
Token/JWT: SPA + alag port Vue/Flask, scale easy, mobile. XSS if localStorage.
MAD2 typically JWT/Flask-Security token. httpOnly cookie safer lekin CORS+CSRF extra.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: We used sqlite. Could switch URI.
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Open models.
Project example: Open models.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
28
Explain relationships between your tables.
Times asked1
Official solution
SimpleUngli rakhe to 4-line formula β panic ki jagah structure.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Example
db.session.query(func.count(Booking.id)).scalar()
Project example: func.count(Booking.id).
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
30
Explain GROUP BY.
Times asked1
Official solution
SimpleGROUP BY collapse + aggregates per group. Dashboard count per venue.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: stats API func.count group venue_id.
Project example: stats API func.count group venue_id.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
31
Explain HAVING.
Times asked1
Official solution
SimpleHAVING after group. WHERE before. users with >5 bookings HAVING COUNT>5.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Venues having count>10.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
32
Explain SQL joins.
Times asked1
Official solution
SimpleJOIN ON fk=pk. inner match dono. left left saari. SQLAlchemy .join(User.roles).
What are joins. Explain SQL joins.
ORM objects ko tables se map karta hai β raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLiteβPostgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server β course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Maybe not used β theory + how would.
Project example: Maybe not used β theory + how would.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
34
What happens to AUTO_INCREMENT values after deleting a record?
Times asked1
Official solution
SimpleDelete ke baad AUTOINCREMENT wapas nahi. Sequence aage. Gaps normal.
Last auto-increment sqlite_sequence. Not needed usually.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Don't rely on ids 1,2,3 after deletes.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
35
What is the last auto-increment value?
Times asked1
Official solution
Simplesqlite_sequence / information_schema. Last auto-increment value. Not needed usually.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Don't rely.
Project example: Don't rely.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
36
How can you migrate data from one database to another?
Times asked1
Official solution
SimpleDump SQL/CSV new URI alembic import. sqlite3 .dump | psql careful types.
How migrate data one DB to another.
ORM objects ko tables se map karta hai β raw SQL kam. SQLAlchemy MAD2 default.
class User(db.Model) + Column + relationship. query.filter_by / db.session.get. Fayda: portable SQLiteβPostgres, injection se safer. Nuksaan: N+1, complex SQL.
SQLite file, zero server β course friendly. Postgres scale. Relationships: FK, backref, lazy/joinedload, cascade on delete. Constraints unique/not null integrity.
Bookings source of truth DB, Redis cache copy.
Project example: Not done, steps known.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
37
What is Vue.js?
Times asked5
Official solution
SimpleVue = UI ka smart assistant. Data badlo, screen khud update. MAD1 Jinja har click pe naya HTML.
Viva tipCDN scalable large teams ke liye weak (no SFC compile, caching 3rd party). Examiner 'which + why' poochta hai β jo use kiya wahi justify karo.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
39
Which one did you use and why?
Times asked2
Official solution
SimpleJo actually use kiya: CDN vs CLI / Vuex vs Pinia / fetch vs Axios β 1 reason + tradeoff.
Examiner vague 'which one' previous question se jodo. Package.json dikhao.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Don't invent unused library.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
40
What is Vuex?
Times asked3
Official solution
SimpleVuex/Pinia ghar ka notice board. Har room (component) same user/token dekhe.
State data, mutations sync change, actions async API phir commit.
Local data() sirf us component. Token/user global.
Pinia Vue 3 official, kam boilerplate. Vuex older MAD2 still common.
computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.
SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.
Project example: stores/user.js. Agar Vuex hai to Pinia ka naam mat lo unless used.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
43
What are Vue lifecycle hooks?
Times asked11
Official solution
SimpleLifecycle = component ki zindagi ke stages. API call tab jab DOM ready ho β mounted.
created: instance bani, this data, DOM nahi. mounted/onMounted: page pe aa gaya β fetch, Chart.js, setInterval.
updated: data change ke baad. unmounted: cleanup (clearInterval) warna memory leak.
Dashboards onMounted isliye: canvas/API tab valid. created mein $el nahi.
Viva tipcreated: data setup, DOM nahi. mounted/onMounted: $el mil gaya β fetch yahi. Dashboards isliye onMounted use karti hain.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
44
Why are lifecycle hooks useful?
Times asked1
Official solution
SimpleRight time side effects fetch timers. Cleanup unmount leak. Fetch after DOM.
Why lifecycle hooks useful.
Lifecycle = component ki zindagi: created (instance, DOM nahi) β mounted/onMounted (DOM ready β fetch, Chart.js yahi) β updated β unmounted (clearInterval).
Dashboard API created mein isliye nahi ki $el/canvas missing ho sakta. Composition API: onMounted(() => {}) setup ke andar. Options: mounted() method. Mix mat.
Examiner 'konsa hook use kiya' β related .vue kholo, line padh ke bolo.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Form + text + image.
Project example: Form + text + image.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
46
What is v-model?
Times asked4
Official solution
Simplev-model do tarfa glue: input likho to data, data badlo to input.
Shorthand :value + @input. Forms ke liye. Display ke liye {{ }} / v-bind kaafi.
v-model.number number input. checkbox boolean. select string.
Directives Vue ke special attributes hain β HTML ko superpower: v-if/v-show, v-for, v-bind (:), v-on (@), v-model.
v-if DOM se hataata/jodta. v-show sirf CSS display. Rare/permission: v-if. Bar-bar toggle: v-show. v-model two-way form. v-bind one-way JSβattribute.
:key v-for pe zaroori warna Vue galat reuse. v-html XSS. Secret UI ke liye sirf v-if kaafi nahi β API 403 bhi.
MAD1 Jinja server HTML. MAD2 yeh directives browser mein reactive.
Example
<input v-model="email">
<!-- same as -->
<input :value="email" @input="email = $event.target.value">
Project example: Login email/password v-model, submit pe JSON POST.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
47
What is v-bind?
Times asked1
Official solution
Simplev-bind one-way: JS β HTML attribute. UI se data automatic nahi aata.
Images src, disabled, class object, href. Colon shorthand.
Dynamic class :class="{ active: isOn }".
Directives Vue ke special attributes hain β HTML ko superpower: v-if/v-show, v-for, v-bind (:), v-on (@), v-model.
v-if DOM se hataata/jodta. v-show sirf CSS display. Rare/permission: v-if. Bar-bar toggle: v-show. v-model two-way form. v-bind one-way JSβattribute.
:key v-for pe zaroori warna Vue galat reuse. v-html XSS. Secret UI ke liye sirf v-if kaafi nahi β API 403 bhi.
MAD1 Jinja server HTML. MAD2 yeh directives browser mein reactive.
Example
<img :src="posterUrl" :alt="title">
<button :disabled="loading">Save</button>
<div :class="{ active: isOn }">
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: 3+ levels store better.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
56
What is the Composition API?
Times asked1
Official solution
SimpleOptions: data methods computed alag. Composition: setup() logic group, reuse.
Viva tipVersion package.json / Vue.version se dikhao. MAD2 dono allowed usually β jo use kiya uske hooks bolo (mounted vs onMounted).
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
59
What is v-memo?
Times asked1
Official solution
Simplev-memo Vue3 skip re-render if deps same. Big lists.
Optimization. Tree shaking Vue3 modular.
Redis in-memory key-value store hai β fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache β same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker β Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) β hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Viva tipWorker + Redis bina Beat ke user-triggered chalega. Scheduled jobs ke liye Beat bhi chahiye.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
63
How many Celery jobs/tasks have you implemented?
Times asked1
Official solution
SimpleGino jo implement: generally reminder, monthly, export. Beat schedule dikhao.
Don't claim 5 if 2.
Celery Python ka distributed task queue β HTTP request ko 10s email/CSV ke liye mat rokna.
Flow: Flask .delay() β Redis broker β Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.
MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process β mix mat karo.
Demo: tin terminals β redis-server, celery worker, celery beat β plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.
Project example: Open beat dict count keys + extra delay() tasks.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
64
What is Redis?
Times asked21
Official solution
SimpleRedis fridge pe sticky note hai β poori kitchen (database) kholne ki zarurat nahi.
Redis in-memory key-value store hai. Data RAM mein rehta hai, isliye disk wale SQLite/Postgres se kai guna tez.
MAD2 mein Redis do kaam karta hai:
1) Cache β same venue/show/dashboard JSON baar-baar DB se mat nikaalo.
2) Celery message broker β Flask task queue mein daalta hai, worker uthata hai.
Source of truth database hi hai. Redis band ho to cache miss ho jaata hai aur Celery queue ruk sakti hai. Crash pe cache gayab ho sakta hai β isliye important data sirf Redis mein mat rakho.
Project example: GET /api/venues pehle Redis dekho. Miss pe SQLAlchemy query, phir SET with timeout. Celery worker Redis list se daily reminder uthata hai.
Viva tipCache ke liye db=1, broker ke liye db=0 rakhna smart hai taaki keys mix na hon. Viva mein redis-cli ping β PONG dikhana strong hai.
Baar-baar same expensive kaam (DB query, counting bookings) mat karo. Result Redis jaise store mein timeout ke saath rakh do.
Cache hit: key mil gayi, DB skip. Cache miss: DB se lao, SET karo, return karo.
Tradeoff: speed vs stale data. Admin naya venue add kare aur cache 50s ka ho to user purani list dekh sakta hai β isliye write pe invalidation zaroori hai.
@cache.cached(timeout=50, query_string=True)
@app.route('/api/shows')
def shows():
return jsonify([s.serialize() for s in Show.query.all()])
Project example: Admin dashboard counts / venues list cache. Create/update/delete ke baad cache.delete('venues').
Viva tipprint('DB queried') function ke andar laga ke miss/hit demo karo β hit pe print nahi chalega.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
66
Why do we use caching?
Times asked5
Official solution
SimpleCache isliye taaki 100 users same dashboard pe DB ko 100 baar na maror dein.
Problem: repeated reads, slow page, extra load. Cache seconds ke liye snapshot deta hai.
Nahi use karna: har second badalne wala live stock, user-private secret data bina soch ke (key mein user_id hona chahiye).
Memoization caching ka subset hai (function args). HTTP 304 / browser cache alag layer.
Redis in-memory key-value store hai β fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache β same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker β Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) β hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
Memcached: simple key-value, yahi. Redis: data structures + expire + optional disk dump.
MAD2 Redis choose β cache aur broker ek hi process. Memcached Celery nahi chalaata.
Redis in-memory key-value store hai β fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.
MAD2 mein Redis do kaam: (1) cache β same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker β Flask task queue mein daalta hai, worker uthata hai.
Flow: cache.get(key) β hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.
Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
70
Difference between APIs, Webhooks, and WebSockets.
Times asked1
Official solution
SimpleAPI you call them. Webhook they call you. WebSocket both stay connected.
Difference APIs Webhooks WebSockets.
HTTP postcard (request-response). WebSocket phone call (dono taraf live). SSE radio (serverβclient stream). Webhook unka server tumhe POST karta hai (payment).
MAD2 mostly REST. Live dashboard = poll + Redis cache kaafi. Agar implement nahi kiya to design bolo, jhoot mat.
Project example: We REST. Others theory.
Project example: We REST. Others theory.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
71
Difference between AJAX and Fetch.
Times asked1
Official solution
SimpleAJAX idea hai, Fetch uska modern tool, Axios optional wrapper.
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: create_show route end.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
74
Display the remaining number of tickets on the booking page.
Times asked1
Official solution
Simplecapacity - booked_sum server. Display remaining on booking page.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: show.available field maintain.
Project example: show.available field maintain.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
75
Show the number of tickets booked in each booking summary.
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: unique constraint + 409.
Project example: unique constraint + 409.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
77
Make uniqueness case-sensitive or case-insensitive as required.
Times asked1
Official solution
Simpleemail.lower() before save. Unique index. SQLite LIKE case. Make uniqueness case-sensitive/insensitive as required.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: normalize on write.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
78
Prevent duplicate products/categories/services from being added.
Times asked1
Official solution
Simplequery.filter_by(name).first() 409. DB unique=True. Prevent duplicate category/product.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: unique constraint + 409.
Project example: unique constraint + 409.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
79
Validate manufacturing and expiry dates before saving.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Example
if Booking.query.filter_by(user_id=uid, slot_id=sid).first():
return jsonify(message='Already booked'), 400
Project example: Click book twice. Second 400 Already booked. DB unique.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
81
Prevent users from booking multiple appointments at the same time.
Times asked1
Official solution
Simpleoverlap query same user time 400. Prevent multiple appointments same time.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Booking time range.
Project example: Booking time range.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
82
Prevent users from creating drives for past dates.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: create drive.
Project example: create drive.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
83
Prevent users from applying to multiple drives/jobs after selection.
Times asked1
Official solution
Simpleif selected_elsewhere 400. Unique where status=selected. Prevent applying multiple drives after selection.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Application model.
Project example: Application model.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
84
Add an Admin activation route.
Times asked1
Official solution
SimpleGET/POST /activate/<token> set active True. Add Admin activation route.
Auth admin.
Examiner 2 cheezein: simple desi line + tumhare project ki exact file.
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Admin applications table.
Project example: Admin applications table.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
87
Remove department matching criteria from the code.
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.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: Would add PATCH status + available++.
Project example: Would add PATCH status + available++.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
91
Explain why some project features were not implemented.
Times asked1
Official solution
SimpleJo nahi kiya sach + reason + kaise add (model API Vue). Bluff worse.
4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.
Related mix mat karo β cache β Celery, authentication β authorization, v-if β v-show, Beat β Worker. Follow-up ke liye ek difference ready rakho.
Project example: If complete, polish only. If missing export, plan celery csv.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
5
Difference between v-if and v-show.
Times asked10
Official solution
Simplev-if element DOM se hataata/jodata hai, v-show sirf CSS display toggle karta hai.
v-if='isAdmin' β false ho to element exist hi nahi. Costly toggle, lekin hidden data DOM mein nahi.
v-show='open' β display:none. Fast toggle, element hamesha DOM mein.
Simplev-bind one-way data β view, v-model two-way (input ke saath sync).
<img v-bind:src='url'> ya <img :src='url'> β url change to image change, image se url nahi.
<input v-model='email'> β type karo to email variable turant update.
v-model = :value + @input ka shortcut. Forms mein v-model, attributes mein v-bind.
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
10
What is ORM?
Times asked49
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
11
Are you using ORM?
Times asked1
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
12
Advantages of ORM.
Times asked5
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.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
13
What is SQLAlchemy?
Times asked8
Official solution
SimpleSQLAlchemy Python ka sabse popular ORM hai. MAD1 mein Flask-SQLAlchemy wrapper use hota hai.
db = SQLAlchemy(app)
class Book(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(80), nullable=False)
Operations: db.session.add(obj), .commit(), .delete(obj), Model.query.all(), .filter_by(), .get_or_404(id).
db.Model ek class hai (function nahi). db object engine + session + metadata hold karta hai.
SQLALCHEMY_TRACK_MODIFICATIONS=False extra signals band karta hai, performance warning hatati hai.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
14
Flask-Security vs JWT.
Times asked1
Official solution
SimpleJWT = JSON Web Token β signed string jisme user id/role hota hai. Har request header mein jaata hai. Session server pe store, JWT client pe.
Login β server token deta hai β Authorization: Bearer <token>
Payload: {sub: user_id, role: admin, exp: ...} β padha ja sakta hai, change nahi (signature).
Session: browser cookie, server-rendered Flask ke liye simple.
Token: mobile/Vue SPA, scaling (server memory nahi). Store: memory/httpOnly cookie, localStorage XSS risk.
MAD1 mostly session. Flask-Security session+login, JWT APIs ke liye.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
15
What security mechanism have you used?
Times asked2
Official solution
SimplePassword DB mein plain text mat rakho β hash store karo jo reverse nahi hota.
from werkzeug.security import generate_password_hash, check_password_hash
user.password = generate_password_hash(request.form['password'])
check_password_hash(user.password, form_password)
Hashing β encryption. Leak pe bhi original password nahi milta (easy passwords rainbow table se β isliye salt + strong hash).
Column String(200) kyunki hash lamba hota hai. unique=True password pe mat lagao.
Community answers
No replies yet
No community answers yet
Open My solution to be the first to share yours.
My solution
Not submitted yet
16
What are Webhooks?
Times asked7
Official solution
SimpleWebSocket do-tarfa live connection, Webhook 'kisi event pe URL hit karo'.
WebSocket: chat, live scores. Connection open rehti hai.
Webhook: payment success pe Stripe tumhari /webhook URL POST karta hai. Connection nahi, ek HTTP call.
MAD1 mein usually nahi hote; REST request-response hota hai.
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'))
Perform a random code modification (project-specific).
Times asked1
Official solution
Yeh feature demo hai. Account ready rakho, steps bol ke dikhao.
Role ke hisaab login β action (create/approve/book) β DB/UI pe result β edge case (fail when slots=0 / blacklisted).
Do browser windows: admin + user. Search/filter alag se dikhao.
Agar feature nahi hai to sach bolo aur 2 minute mein kaise add karoge (query + template) explain karo.