Register and log in with different user roles (Admin, Staff, User/Trekker).
7
Approve staff accounts from the Admin dashboard.
8
Create and assign treks.
9
Update trek slots/status.
10
Edit user profile.
11
Book a trek and demonstrate overbooking prevention.
12
Show bookings in the Admin dashboard.
13
Modify app.py.
14
Explain a specific route (e.g., booking route).
15
Explain the route logic.
16
Show backend validation in your code.
17
Which database have you used?
18
Where is your database configured/located?
19
What is ORM?
20
Which ORM have you used?
21
Write a query to:
Display only shortlisted students.
Display only pending/completed bookings.
Display only blacklisted users.
Display bookings matching a filter condition.
Display users with NULL mobile numbers.
22
Explain how cascading delete is implemented (e.g., deleting a company also deletes its drives).
23
What is url_for()?
24
Which parameter is passed to url_for()?
25
What is render_template()?
26
How is data passed from the backend to the frontend?
27
Write a basic Flask route (e.g., Hello World).
28
What is a session?
29
What is the data type of a session?
30
Explain server-side/backend validation.
31
Explain HTTP methods.
32
Difference between GET and POST.
33
Change the color of a button, heading, or dashboard element.
34
Modify a page to display only filtered records (e.g., shortlisted students, pending/completed bookings).