Interview Questions and Answers - Python, SQL, Django & Projects
Python (Basic to Advanced)
Q: What are Python?s key features?
A: Python is interpreted, dynamically typed, high-level, and supports OOP. It has a large standard library, is
open-source, and has extensive community support.
Q: Explain list vs tuple in Python.
A: Lists are mutable, whereas tuples are immutable. Lists use more memory, but provide more flexibility.
Q: What are Python decorators?
A: Decorators allow you to modify the behavior of a function or class. They are often used for logging, access
control, memoization, etc.
Q: What is a lambda function?
A: An anonymous function in Python defined using the `lambda` keyword. Example: `lambda x: x + 1`.
Q: What is the difference between deep copy and shallow copy?
A: A shallow copy copies the outer object but references the same inner objects. A deep copy copies
everything recursively.
SQL (Basic to Advanced)
Q: What is the difference between WHERE and HAVING?
A: WHERE filters rows before grouping, HAVING filters groups after aggregation.
Q: What is normalization?
A: Process of organizing data to reduce redundancy. Normal forms include 1NF, 2NF, 3NF, etc.
Interview Questions and Answers - Python, SQL, Django & Projects
Q: Explain JOIN types.
A: INNER JOIN returns matching rows, LEFT JOIN returns all from left and matching from right, RIGHT JOIN
is vice versa, FULL OUTER JOIN returns all matched or unmatched rows.
Q: How to find the second highest salary in SQL?
A: Use: `SELECT MAX(salary) FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);`
Q: What is a subquery?
A: A query within another SQL query. Can be used in SELECT, FROM, WHERE clauses.
Django (Basic to Advanced)
Q: What is Django?
A: A high-level Python web framework that enables rapid development of secure and maintainable websites.
Q: What is MTV architecture?
A: Model-Template-View. Model handles data, Template is the frontend, View processes requests and
returns responses.
Q: How does Django ORM work?
A: Django ORM maps models to database tables. Queries are constructed using Python syntax.
Q: What are middleware in Django?
A: Middleware are hooks into Django?s request/response processing. Used for tasks like authentication,
logging, etc.
Q: How do you implement authentication in Django?
Interview Questions and Answers - Python, SQL, Django & Projects
A: Use `[Link]`, create users, apply login/logout views, and use `@login_required` decorators.
Project-Based Questions (MindCare Connect & CareMind)
Q: Explain your MindCare Connect project.
A: MindCare Connect is an AI-powered web app for student mental health support. It includes features like AI
chatbot, mood tracking, resource library, and crisis support.
Q: How did you implement the chatbot in MindCare Connect?
A: Used Gemini API to provide conversational support. Backend is Django, integrated with JavaScript on the
frontend.
Q: What technologies were used in MindCare Connect?
A: Frontend: HTML, CSS, JS. Backend: Django. Features include AI chatbot, journaling with AI insights, peer
support, etc.
Q: What was the goal of the CareMind project?
A: CareMind was developed using [Link] (backend) and HTML/CSS/JS (frontend). It helps in managing
mental health through self-care tools.
Q: How did you handle authentication and security?
A: Implemented Django authentication with login/signup. Secured with SSL, two-factor authentication, and
high-contrast accessible UI.