Unit - 1
What principles of modular design should be followed to create maintainable and scalable modules within a web application?
What role does dependency injection play in module design, and how can it be used to enhance the testability and flexibility of a web application?
What techniques can be implemented in the design of a web application to anticipate and mitigate the impact of failures, ensuring robustness and reliability?
Explain the role of Scrum Master, Product Owner, and Development Team
Explain the Golden circle method used by leaders to communicate
Unit - 2
With examples, explain various ways of positioning CSS rules.
How many types of selectors are there? Name them.
Name the three cascade principles used by CSS to handle conflicts.
Name the inheritable and non-inheritable CSS properties
Distinguish between block level elements and inline elements
Name the three places where you can insert JavaScript in a HTML page
Explain the three types of outputs produced by JavaScript. Give examples.
How does jQuery handle events, and what is the syntax for binding an event handler to a specific event?
How does jQuery facilitate dynamic manipulation of the Document Object Model (DOM)?
Describe $.ajax(), $.get(), and $.post() methods of jQuery.
Describe the following Bootstrap components.
What is progressive enhancement of a user experience design?
Provide examples of common UX design patterns that enhance user experience.
Unit - 3
How do foreign keys enforce referential integrity in MySQL, and what are the implications of using ON DELETE and ON UPDATE cascade actions?How do unique constraints differ from primary keys in MySQL?
What are the benefits and limitations of using views in database design?
Write a SQL query to select all employees from the employees table who were hired after January 1, 2024, and whose email address ends with 'example.com'.
Write a SQL query to insert a new row into the employees table with the following data: id = 1, first_name = 'Rajesh', last_name = 'Kumar', email = 'Rajesh.Kumar@example.com', and hire_date = '2023-01-15'.
Write a SQL query to select all orders from an orders table along with the corresponding customer names from a customers table, assuming both tables have a customer_id column.
Write a SQL query to select all customers from a customers table along with any orders they have placed from an orders table. Include customers who have not placed any orders.
Write a SQL query to count the number of employees hired in each year from the employees table.
Write a SQL query to count the number of employees hired in each year and display only those years where more than 5 employees were hired.
Write a SQL query to calculate the average number of orders placed per customer from an orders table.
Unit - 4
Write code for a model in Django for an entity called "Product" having fields called "name" (100 characters), price (10 digit number with 2 decimal digits), and "description" (text field)
Write two pieces of code in Django to map a path 'hello/' to a view called 'hello_world' which generates a HTTP response "Hello World!"
Explain Django RESTful Framework (DRF) with an example.
Name the three architectural layers of a Django application and mention responsibility of each layer.
Name three types of dependency injections with an example for each type.
Explain serialisation and de-serialisation with an example.
What is FastAPI? Mention its key features.
What are Routers in Django? When would you use a router?
Create an endpoint /students/ that links to a controller to list all students from the Student model.
Develop an endpoint /students/create/ that links to a controller to create a new student entry in the Student model.
Set up an endpoint /students/update/<int:id>/ that links to a controller to update the details of a student with a specific ID in the Student model.
Design an endpoint /students/delete/<int:id>/ that links to a controller to delete a student with a specific ID from the Student model.
Implement an endpoint /students/<int:id>/ that links to a controller to retrieve the details of a student with a specific ID from the Student model.
Create an endpoint /courses/ that links to a controller to list all courses from the Course model.
Develop an endpoint /courses/create/ that links to a controller to create a new course entry in the Course model.
Set up an endpoint /courses/update/<int:id>/ that links to a controller to update the details of a course with a specific ID in the Course model.
Design an endpoint /courses/delete/<int:id>/ that links to a controller to delete a course with a specific ID from the Course model.
Implement an endpoint /courses/<int:id>/ that links to a controller to retrieve the details of a course with a specific ID from the Course model.
What are the benefits of serializing Django models?
Name the five common methods of Django models.
What are meta options of Django models? How many meta options are supported in Django? Name them.
Unit - 5
Name various URL patterns supported by Django.
Explain the difference between static and dynamic URL patterns in Django with an example.
Explain the role of the model in the MVT pattern.
Explain the role of the view in the MVT pattern.
Explain the role of the template in the MVT pattern.
With an example, describe how context data is passed from a view to a template in Django.
Explain what template tags are in Django. Show how to use the for tag to loop through a list of items and display them in a template items.html.
How can you include one template inside another? Create a partial template header.html and include it in base.html.
How do you reference static files (like CSS, JavaScript) in Django templates? Demonstrate this in a template layout.html with a linked CSS file.
How do you add comments in Django templates? Add comments in a template example.html to explain different sections of the template.
How do you use if conditions in Django templates? Create a template status.html that displays different messages based on the value of a variable status.
Name decorators and mixin classes available in Django to implement permissions and access control.