level2_98 MAD2 Level 1 Aug 1, 2026 Copy link 1 What is ON DELETE CASCADE? 2 In the browser's Network tab, after logging in, the password is visible in the request payload. How would you prevent or hide it? 3 How would you implement template inheritance (MAD1) in Vue? (For example, displaying the Navbar on every page.)
Level2_101 MAD2 Level 1 Aug 1, 2026 Copy link 1 Demonstrate your project. 2 Explain all the features implemented in your application. 3 Explain your database schema and how the tables are connected. 4 Explain the search functionality in your project. 5 Explain the API endpoints implemented in your project and why they are used. 6 Show the Celery jobs and explain the data flow. 7 Where did you use Flask-Security in your project? 8 Have you referred to AI while writing your code? 9 What is a Blueprint in Flask? 10 What is Flask(__name__)? Can we remove the __name__ parameter? 11 What is WSGI? 12 What is a Python decorator? 13 How is a decorator different from a normal function? 14 Write a simple "Hello World" decorator. 15 What are dunder methods in Python? 16 What is __repr__()? How is it different from __str__()? 17 What is serialize() in models? 18 What is exception handling? 19 What are the different types of exceptions in Python? 20 What is the base class of all exceptions? 21 What is a dataclass in Python? 22 What are the default ports for Flask and Vue (CLI/Vite)? 23 What is SMTP, and what port does it use? 24 What is the difference between a Primary Key and a Unique Key? 25 Can a Primary Key be replaced with UNIQUE + NOT NULL + AUTO_INCREMENT? Why or why not? 26 What is indexing, and why is it used? 27 How do you create an index on multiple columns in SQLAlchemy? 28 What does db.String(128) mean? How is 128 stored internally? 29 What does lazy="dynamic" do in SQLAlchemy relationships? 30 What does cascade="all, delete-orphan" do? Can it work the opposite way? 31 What are joins in databases? 32 Can database models be changed after the application is deployed to production? If yes, how? 33 What is caching, and why is it used? 34 What is the difference between cache.cached and cache.memoize? 35 What is the difference between Memcached and Redis? 36 What exactly is cached when using the @cache.cached decorator? 37 What are the main components of Celery? 38 How do you prioritize Celery tasks? 39 What happens if you swap the order of @jwt_required and @role_required decorators? 40 What fallback mechanisms have you implemented to prevent data leakage? 41 What is the difference between json, jsonify, json.dumps, and marshal? 42 What is the difference between POST, PUT, and PATCH? 43 Explain HTTP status codes: 400, 401, 403, and 404. 44 What is the difference between WebSockets and Webhooks? 45 How do WebSockets work? 46 What is the difference between Sessions and Cookies? 47 What is the difference between synchronous and asynchronous programming? 48 What are Vue routes, and why do we use them? 49 What are Vue slots? 50 What are Vue props? 51 What is the difference between props and slots? 52 What are Vue lifecycle hooks? 53 What are Vue directives? 54 What is pagination, and why is it used? 55 How would you scale your application to support millions of users? 56 What happens if the application load increases to millions of requests? 57 Optimize a piece of code containing multiple if conditions without using if-else. 58 Implement a search by username feature. 59 Implement a dropdown menu in a form. 60 Add a timestamp column to a table and display it in the dashboard. 61 Change Celery scheduling so that the daily reminder always executes before the monthly report. 62 Change Celery scheduling so that the daily reminder always executes before the monthly report. 63 Make changes to the Admin Dashboard functionality.
Level3_41 MAD2 Level 1 Aug 1, 2026 Copy link 1 What are Vue lifecycle hooks, and which ones did you use? 2 Explain how watch works in Vue and where you used it. 3 If you want to change the database from SQLite to another database (e.g., MySQL/PostgreSQL), what changes would you make in the code? 4 What is the need for a virtual environment?
proctor785 MAD1 Level 1 Aug 1, 2026 Copy link 1 Run the application and give a complete project demonstration. 2 Explain the project folder structure. 3 How many controllers/routes do you have? 4 Explain the models.py file. 5 Explain the authentication routes (login and registration). 6 Explain the Jinja2 code used in your templates. 7 If used, explain template inheritance. 8 What does cascade="all, delete" mean in SQLAlchemy? 9 Difference between redirect() and render_template(). 10 What are the advantages and disadvantages of Flask-SQLAlchemy ORM? 11 Difference between Horizontal Scaling and Vertical Scaling. 12 What is Time Complexity? 13 Write a Flask route for admin_delete_trek_staff.
Level2 141 MAD1 Level 1 Aug 1, 2026 Copy link 1 Show ID card. 2 Verify GitHub collaborator access. 3 Choose either Portal Download or Checksum Verification. 4 Run the application and demonstrate the core functionalities: User Registration & Login Trek CRUD (Create, Update, Delete) Search functionality Staff assignment Staff approval Admin blacklist functionality 5 Open routes.py and explain the registration route using your project code. 6 What is ORM? 7 Explain MVC architecture. 8 Difference between Authentication and Authorization. 9 Write a Flask registration route in Notepad/VS Code.
Proctor 784 MAD1 Level 1 Aug 1, 2026 Copy link 1 Download the submission from the portal and perform checksum verification. 2 Complete project demonstration. 3 Explain every feature/functionality of the website. 4 Demonstrate different user roles (Staff → Admin approval → User booking flow). 5 Did you use any APIs in your project? 6 Explain the models.py file. 7 Explain your project using the MVC architecture. 8 Did you use ORM? If not, how does your project still follow MVC architecture? 9 How did you protect your project from SQL Injection attacks? 10 Which HTTP methods did you use in your project? 11 Which other HTTP methods do you know? 12 What is a Client and a Server? 13 What is the purpose of @app.route? 14 Difference between Authentication and Authorization. 15 Name some network protocols. 16 What is the use of {{ }}, {% %}, and {# #} in Jinja? 17 Display the logged-in staff member's name on the Staff Dashboard. 18 Display the logged-in staff member's name on the Staff Dashboard. 19 Display start date and end date on trek cards. 20 Add a new Age column to the User table. 21 Add the Age field to the registration form. 22 Update the registration route to save the age in the database. 23 Add validation so only users younger than 50 years can register. 24 Be prepared for questions involving adding a new database field and updating the frontend, backend, and business logic accordingly.
Level2 Viva Proctor 785 MAD1 Level 1 Aug 1, 2026 Copy link 1 Show ID card. 2 Download and run the project. 3 Demonstrate all project features. 4 Explain the project folder structure. 5 Explain the purpose of app.py, models.py, and routes.py. 6 Explain any randomly selected line of code from your project. 7 What is ORM? What are its advantages and disadvantages? 8 Explain MVC architecture. 9 Difference between backref and back_populates. 10 CSS priority (Inline, Internal, External). 11 What are database constraints? 12 Difference between structured and unstructured data. 13 Basic JavaScript concepts (even if not used in the project). 14 Difference between horizontal and vertical scaling. 15 Difference between Primary Key and Foreign Key. 16 What is lazy loading? 17 What are REST APIs? 18 What are HTTP methods? 19 What is SQL Injection? How can you prevent it? 20 What is render_template()? 21 Add a new Delete Trek button on the Trekkers page that deletes the selected trek when clicked.
level1_11 MAD1 Level 1 Aug 1, 2026 Copy link 1 Complete project demonstration (User, Staff, and Admin flows). 2 Add a new trek. 3 Book a trek. 4 Mark a trek as completed from the Staff dashboard. 5 Explain a route from your project in detail (its working and logic). 6 What is ORM? 7 What are HTTP methods? 8 What is a backref relationship in SQLAlchemy? 9 Difference between Authentication and Authorization. 10 Difference between Inline, Internal, and External CSS. 11 Change the application's port number. 12 Set a default value for the trek status field. 13 Change the login button color using CSS. 14 Write a Jinja for loop to display trek location and name. 15 Write a Flask route to find blacklisted staff. 16 Write a Jinja for loop (in Notepad/VS Code).