Level2_144 MAD2 Level 1 Aug 2, 2026 Copy link 1 Explain the directory structure of your application. 2 Give a short demonstration of your application. 3 Explain models.py. 4 Open any one Vue component/file and explain it. 5 Which version of Vue are you using (Vue 2 or Vue 3)? 6 Difference between Vue CLI and Vue CDN. 7 Why did you use Vue CDN? Show where it is included (index.html). 8 How many Vue files/components do you have? 9 What is the difference between v-if and v-show? 10 What is Axios? Have you used it? 11 Show your fetch() API calls. 12 If the backend returns a 400 Bad Request response, how does the frontend handle it? 13 What do you know about Vuex? 14 What are State, Mutations, and Actions in Vuex? 15 What is the purpose of Actions? 16 Explain how RBAC is implemented in your application. 17 How does the @role_required decorator work? 18 What is the difference between back_populates and backref? 19 What is cache? 20 Where does Redis store its cache? 21 Change the Celery schedule so that both the monthly report and daily reminder run at 5:20 PM. 22 What types of browser storage are available? 23 How are you rendering charts in your application? (e.g., Chart.js) 24 Change the Chart.js bar chart so that it uses only two colors.
level3_24 MAD2 Level 1 Aug 2, 2026 Copy link 1 Demonstrate your complete application. 2 Explain your entire codebase (backend and frontend). 3 Explain your database/models in detail. 4 Explain the flow of a feature from frontend to backend (e.g., booking/service flow). 5 Explain every library/package used in your project and why it is needed. 6 Explain every API used in your application. 7 Explain the challenges and learnings from MAD1 and MAD2. 8 Add a new database entry using a Python script or the terminal. 9 Change the background color of the page/body. 10 Change the background color of a specific div/login box. 11 Set a background image. 12 Change the font/text color. 13 Change the button color. 14 Change the navbar color. 15 Move the navbar (center/bottom/footer). 16 Move the header to the center of the page. 17 Modify a database column and update the application accordingly. 18 What is Vue? 19 What are JavaScript frameworks? 20 What is Vue Router? 21 What are Vue Routes? 22 What are Vuex Mutations and Actions? 23 What is AJAX? 24 What is Server-Sent Events (SSE)? 25 What is an Opaque Request? 26 What is Flask? 27 Can a Flask endpoint/API return a Boolean value? 28 What happens if a database table is empty? What does the query return? 29 What is ORM? 30 Explain your database schema/models. 31 What type of database errors can occur? (e.g., inserting a string into an integer column) 32 What happens if invalid data is inserted into an empty table? 33 How many models have you used? 34 Difference between frontend validation and backend validation. 35 Which validation is more important, frontend or backend? 36 What is Git? 37 What is Version Control? 38 Difference between Git and a Version Control System (VCS). 39 What is another name for a Version Control System? 40 What are Webhooks? 41 What is CSRF? 42 What is XSS? 43 What is DoS (Denial of Service)? 44 Difference between Privacy and Security. 45 What is Redis? 46 What is Celery? 47 What is Caching? 48 What is Point-to-Point Messaging? 49 Difference between Task Queue and Message Queue. 50 What is CSS? 51 What is Inline CSS? 52 Difference between Inline CSS and Internal CSS. 53 What are the different ways to store data in the browser/client? 54 Difference between Local Storage, Session Storage, and Cookies. 55 What is SMTP? 56 What are the advantages and disadvantages of SMTP? 57 Rate your application out of 5 and justify your rating. 58 If your application crashes in production, how would you debug and resolve the issue?
Level2_116 MAD2 Level 1 Aug 1, 2026 Copy link 1 Demonstrate the complete application. 2 Show the project/folder structure. 3 Show the requested features/pages during the demo. 4 Explain specific parts of the code when asked. 5 Display the number of days remaining before book access is revoked. 6 What is ORM? 7 What is relationship()? 8 What is backref? 9 Difference between backref and back_populates. 10 What is cascade="all" (Cascade options)? 11 Why did you use __tablename__? What happens if we remove it
level2_99 MAD2 Level 1 Aug 1, 2026 Copy link 1 Demonstrate the complete application. 2 Show the database schema. 3 Display the password in red next to the login button on the navigation bar. 4 Make a requested code change and explain it. 5 What is ORM? 6 Explain your database structure. 7 Explain Foreign Keys. 8 What happens if a referenced (parent) record is deleted? (Referential integrity / cascade behavior.) 9 What changes would you make to migrate your application from SQLite to PostgreSQL? 10 What are the main components of Celery? 11 Difference between Redis and Celery. 12 Difference between Celery Beat and Celery Worker.
level2_93 MAD2 Level 1 Aug 1, 2026 Copy link 1 Introduce yourself. 2 Demonstrate your application. 3 Explain every feature and implementation in your project thoroughly. 4 Prevent users from booking more tickets than the available capacity. 5 Display the total number of bookings made by a user in the Bookings page. 6 Validate the signup username so that it only accepts an email format (e.g., abc@xyz.com). 7 Add a Download CSV button to export all venues into a single CSV file. 8 Display the total/current booking count. 9 Explain the Vue directives/components (v-if, v-for) used in your code. 10 What are Props in Vue? 11 What is ORM? 12 What is Redis caching? 13 Why did you use Redis caching? 14 Where did you implement Redis caching in your project?
Level_2_93 MAD2 Level 1 Aug 1, 2026 Copy link 1 Demonstrate your application. 2 Implement an Export All Theatres feature (export data for all theatres at once). 3 Display the booking count. 4 What are the properties/options in Vue, and which ones have you used? 5 Explain the libraries/packages you have used in your project and why you chose them.
level2_96 MAD2 Level 1 Aug 1, 2026 Copy link 1 Demonstrate your complete application. 2 Create a new user, venue, show, and complete a booking. 3 What should happen to bookings if a movie/venue is deleted? 4 If the total seats for a show are reduced below the number of existing bookings, how would you handle it? 5 Show your database models and explain your design decisions. 6 Why did you use separate date and time columns instead of a single datetime column? 7 Show all Vue components. 8 Show where all frontend routes/URLs are defined. 9 Show where you implemented caching. 10 Demonstrate daily reminders/monthly reports. 11 Change the reminder schedule and demonstrate it working. 12 Show how emails are sent. 13 Change the navbar color/background. 14 Change simple frontend styling (e.g., background color). 15 If cache already contains old data after inserting new records, how would you update it? 16 Instead of calling cache.clear(), how would you clear cache for only one specific route? 17 What is Vue.js? 18 Why did you choose Vue instead of React? 19 Why use Vue instead of plain HTML/CSS/JavaScript? 20 What are the advantages of Vue.js? 21 What is the Virtual DOM? 22 What are the advantages and disadvantages of the Virtual DOM? 23 What is the difference between v-if and v-show? 24 In which scenarios would you prefer v-if over v-show (or vice versa)? 25 Explain all Vue directives. 26 Difference between Vue CLI and Vue CDN. 27 How do components communicate in Vue? 28 What is emit() / this.$emit()? 29 How do you share data globally across all Vue components? (Vuex/Pinia) 30 Why did you use a static admin account instead of storing roles in the database? 31 If someone copies the /user URL into another browser, can they bypass login? 32 If a user changes their role in Local Storage (e.g., from doctor to admin), why are they able or unable to access admin pages? 33 Where is authentication enforced in your application? 34 Show your SQL models. 35 Why did you design your database this way? 36 Difference between Primary Key and Unique Key. 37 Can a Unique Key be used to define relationships between tables? 38 How would you normalize your database to improve scalability? 39 What is Redis? 40 What is Celery? 41 Where have you implemented caching? 42 How do you invalidate stale cache when the database changes? 43 What is a callback function? 44 Explain the fetch() request in one of your Vue components. 45 Open package.json and explain the purpose of the packages/dependencies used. 46 What is Local Storage? 47 What is Session Storage? 48 What are Cookies? 49 Difference between Local Storage, Session Storage, and Cookies.
Level2_86 MAD2 Level 1 Aug 1, 2026 Copy link 1 Demonstrate your complete application. 2 Show and explain your models/controllers. 3 Show the Vue components you created. 4 Show the cached API endpoints and explain how cache invalidation works. 5 Show your Celery implementation and scheduled jobs. 6 Show the job scheduling reports. 7 Show how emails are sent using SMTP. 8 Show how CSV export is implemented. 9 Show how JWT is stored in the browser. 10 Explain your API authentication flow in code. 11 How have you implemented authentication? 12 How is route protection (login_required / JWT authentication) implemented? 13 How have you implemented RBAC? 14 Why is password hashing required? 15 Have you implemented password hashing? 16 Why are you using fs_uniquifier? 17 What are Vue lifecycle hooks? Explain the ones you used. 18 What are Props in Vue? 19 Show a Vue component and explain its fetch() request and lifecycle hook. 20 What is a Single File Component (SFC)? 21 How do you create a new route in Vue? 22 What are Parent Routes and Child Routes? 23 What is Redis? 24 Why is Redis faster than a relational database? 25 How have you implemented Redis? 26 What is caching? 27 Why do we need caching? 28 Where have you implemented caching? 29 How do you invalidate/delete cache? 30 Difference between Caching and Memoization. 31 What is Memoization? 32 Explain Celery with respect to your project. 33 How many Celery jobs have you implemented? 34 What did you use Celery for? 35 Which database have you used? 36 Is it a relational database or NoSQL database? 37 What is a relational database? 38 What is a NoSQL database? 39 What is a Primary Key? 40 Why are database integrity constraints required? 41 What is database indexing? 42 What is joinedload? 43 Why did you use joinedload? 44 Write the query without using joinedload. 45 In what situations should joinedload be used? (N+1 Query Problem) 46 What is a decorator? 47 Why use a decorator instead of a normal function? 48 Difference between jsonify and json.dumps. 49 What are WebSockets? 50 What are Webhooks? 51 If your application had 1 million users and all reminder emails had to be sent within 15 minutes, how would you scale the system?