SRM Institute of Science and Technology

School of Computing

Department of Computing Technologies

21CSE354 – Full Stack Web Development

Question Bank Unit Wise

Unit – 1

Part – B Questions

1. Describe the basic structure of an HTML document. What are the key tags used, and
what role does each play?
2. Explain the importance of validating HTML code. What tools can be used for validation,
and how do they help in debugging?
3. How can you apply different fonts to text in an HTML document using CSS? Provide
examples of both web-safe fonts and custom fonts.
4. What are the different types of lists available in HTML? Explain with examples how
each type can be used in structuring content.
5. Explain the CSS box model. How do margin, padding, border, and content work together
to affect the layout of a web page?
6. How do you create external and internal links in HTML? What attributes are important
for each, and why?
7. How can you define and apply colors to elements in HTML using CSS? Discuss the
different ways to specify colors.
8. Describe how CSS transformations and transitions can be used to create interactive web
elements. Provide a simple example.
9. Describe the difference between relative, absolute, and fixed positioning in CSS. When
would you use each type of positioning?
10. What are media queries in CSS, and how do they contribute to responsive web design?
Provide an example of a media query that changes the background color of a page when
the screen width is less than 600px.
11. Explain the difference between CSS transformations and CSS transitions. How can you
use both to create a hover effect on an image that scales up smoothly when hovered?
 Part - C Questions

1. Discuss in detail the process of structuring an HTML document from scratch.

Explain how to validate the HTML code and the common errors encountered during
validation. Include examples of well-structured HTML code.
2. Explain how modern CSS techniques, including flexbox and grid, can be used to
create complex web layouts. Discuss the role of the CSS box model, positioning, and
floating in achieving a responsive design. Illustrate with examples.
3. Discuss the various techniques available in CSS for creating animations and
transitions. Explain how these techniques can enhance the user experience on a website.
Provide code examples that demonstrate the use of keyframes, transformations, and
transitions in CSS.
4. How can CSS be used to enhance the readability and aesthetics of text on a
webpage? Discuss the application of fonts, text alignment, spacing, lists, and text blocks.
Provide examples that show the use of different font properties, text shadows, and CSS
pseudo-elements for styling text.
5. Describe the process of embedding images, videos, and other multimedia elements
into an HTML document. Discuss the various attributes and CSS properties that can be
used to style and position these elements. Include examples that demonstrate responsive
design techniques for multimedia.
6. Explain the advanced techniques in CSS for controlling backgrounds and borders.
Discuss how multiple backgrounds can be layered, how borders can be styled with
different properties, and how these elements contribute to the overall design of a webpage.
Provide code examples.
7. You are tasked with creating a responsive web page for a local restaurant. The page
should include a header with the restaurant's logo, a navigation menu, a section for
featured dishes displayed in a grid format, and a footer with contact information. The
design should adapt well to both desktop and mobile screens.Explain how you would
structure the HTML document and use CSS to achieve a responsive layout. Discuss the use
of media queries, flexbox/grid layout for the featured dishes, and techniques for ensuring
that images and text scale appropriately on different screen sizes. Provide code snippets to
illustrate your approach.
8. A freelance web designer wants a portfolio page that showcases their work. The
page should include a brief introduction, a gallery of projects with descriptions, and a
 contact form. The designer wants the gallery to have hover effects that reveal more
information about each project and smooth transitions between sections of the page.
Describe how you would build this portfolio page using HTML and CSS. Focus on
structuring the content in HTML and using CSS for layout, hover effects, and transitions.
Explain how you would implement the hover effects for the gallery and ensure a smooth
user experience. Include relevant code examples.
9. A tech startup requires a landing page to promote their new product. The page
should include multiple sections, such as an introduction, features, testimonials, and a call-
to-action. Each section should have a unique background, and the transition between
sections should be seamless. The page must also include a sticky navigation bar that
highlights the current section as the user scrolls. Discuss how you would structure and
style this landing page using HTML and CSS. Explain how to implement the sticky
navigation bar and section highlighting using CSS. Describe how you would use
background images and colors effectively, and ensure smooth scrolling between sections.
Provide code examples to demonstrate your solution.

Unit - 2

Part – B Questions

1. Define JSX in React and explain why it is used.

2. List the built-in hooks available in React and their basic purpose.
3. Explain how React's component-based architecture differs from traditional UI
development.
4. Describe how the useState hook works in React with a basic example.
5. Differentiate how routing works in React with the help of react-router. Explain how you
can set up basic routes for different components.
6. Explain the difference between controlled and uncontrolled components in React forms.
Provide a basic example for each.

Part – C Questions

1. Interpret a React component that captures and displays user input in a form using the
useState hook. Explain each part of the code and the role of the useState hook.
2. Analyze it by comparing and contrast useEffect and useMemo hooks in React. Outline it
by when should each hook be used and state the implications of using them improperly.
 3. Evaluate the use of custom hooks in large-scale React applications. What are the benefits
and potential drawbacks of using custom hooks compared to built-in hooks?
4. Design a custom hook in React to manage form validation logic for multiple input fields.
Describe the use cases for this hook and explain how you can utilize useDebugValue to
label it for debugging purposes.
5. Create a React component that uses refs to manage focus on an input field and
demonstrate how to handle the form submission event. Explain the role of refs in this
example.
6. Develop a simple React application with two components using useContext for state
management and sharing data between them. Explain how useContext works and how it
can replace prop drilling in this scenario.

Unit - 3

Part – B Questions

1. With an example explain Update statement in SQL.

2. Explain natural join with example.
3. Distinguish between Left deep join order and Non-left deep join order.
4. With the syntax explain the SQL DML commands.
5. What are some common clauses used with SELECT query in SQL?
6. What is JDBC, and how does it help in database management for Java applications?
7. Describe the role of the DriverManager in JDBC.
8. Explain the difference between Statement and PreparedStatement in JDBC.
9. How does the ResultSet interface work in JDBC?
10. What is connection pooling, and why is it essential in high-traffic applications?

Part – C Questions

1. Write SQL Statements for the below

a. Create an EMPLOYEE table with EID, ENAME, DESIGNATION,

DEPARTMENT, DEPARTMENT_LOCATION, SALARY, CITY
b. Find the employee, who is coming from Chennai
c. Find the employees those who working for ACCOUNTS and working in Bengaluru
d. List the number of designations in the company.
 e. Find the employees details of all the employees those who are getting salary
between 10000 to 20000

2. A small-scale industry consists 5 employees in their Accounts department for carrying out
their business transaction. You are instructed to store the following details for these 5 employees in
the table and name the table as employees. Employee ID, Name, Date of Joining, Age, department
and salary

Generate the SQL statements for the following queries.

a. While store the Date of Birth (DOB) of all the employees use the appropriate function to
store the DOB values in MM-DD-YYYY Format.
b. Find the top 3 Salary
c. List the employee whose employee number is 100.
d. List the Employee whose salary is between 50 K to 1 Lac.
e. List the total number of employees in the company

3. Consider the relational database given below where primary keys underlined.

employee ( person_name, street, city)

works ( person_name, company_name, salary)

company ( company_name, city)

manages ( person_name, manager_name)

a) Find the names, cities, street address of residence of employees who work for First Bank
and earn more than 10,000$
b) Find the Company that has most employees
c) Find those companies who employees earn higher salary on average than average salary at
First Bank
d) Find all companies located in every city in which small Bank corporation is located.

4. Write a query using INTERSECT, UNION, UNION ALL, MINUS, set operator to list the
student id and residence location of the students. (8 MARKS)

Student table

Student_id Student_name City Age

1 Raj Chennai 25

2 Aditya Vizag 24

3 Ram Pune 26

4 Sam Delhi 28

Student personal table

Student_id Department College City Rank

1 Science DCE Chennai 4

2 Arts ABC Vizag 1

3 Commerce KEC Delhi 2

4 Science SIT Pune 3

5 Electronics KLN Pune 5

Employee (Business_Id, login_Id, Organization_Name, Organizational_level, Job_title, Gender,

Martial_status, BirthDate); (2 marks)

1. Write a query for SQL view (view name: Employee_Records) to fetch columns of the table
and filter the results using where clause with the martial_status ‘M’.

2. Write a query to drop SQL view table (view name: Employee_Records) table.

5. Consider the Players relation from Indian Kabaddi League.

Write SQL queries for the following along with their output.

Player (player_name, city, state)

Works (name, franchisee_name, bidmoney)

Company (franchisee_name, city)

Manages (player_name, manager_name)

a) Find the names of the players with their franchisee
b) Find the players who do not work for Chennai Kabaddi Kings.
c) Find the names and states of all players who are from the city Potheri.
d) Find the franchisee that has the most paid player.
e) Find the names of players who are getting more than the average bid-money of all the
players.

6. Table – StudentDetails

StudId Name EnrollmentNo DateOfJoining

11 Nick Panchal 1234567 01/02/2019
21 Yash Panchal 2468101 15/03/2017
31 Gyan Rathod 3689245 27/05/2018

Table – StudentStipend

StudId Project Stipend

11 P1 80000
21 P2 10000
31 P1 120000
a) Write an SQL query to fetch the number of students working in project ‘P1’.
b) Write an SQL query for creating a new table with data and structure copied from another
table.
c) Write an SQL query for fetching records that are present in one table but not in another table
using Minus.
d) Write an SQL query for fetching all the Students details from StudentDetails table who
joined in the Year 2018.
e) Write the SQL query to find the nth highest stipend from the table.

7. A company wants to connect its Java-based web application to a MySQL database to store
employee information. The database needs to store employee IDs, names, and departments. Write
the JDBC code to: Establish a connection to the MySQL database. & Insert a new employee record
into the database.

8. Imagine you're building a Java application that frequently updates and retrieves student grades
from a database. Design a solution using JDBC that allows: i)Transaction management where
multiple updates (grade changes) are handled, ensuring data consistency and
If an error occurs in one update, all updates should roll back to the previous state.

9. Discuss the steps involved in setting up a JDBC connection, from installing the database to
running SQL queries.

Unit - 4

Part – B Questions

1. What are the key differences between Spring and Spring Boot?
2. What is Spring Boot Auto-Configuration? How does it help in application development?
3. What are the key components of a basic Spring Boot application?
4. What are the different types of testing in Spring Boot?
5. Explain the key features of Spring Boot.
6. Describe the three-tier architecture in a Spring Boot application.
7. How does Spring Boot facilitate testing?
8. What is Spring Boot Actuator, and what are its benefits?
9. Discuss the importance of auto-configuration in Spring Boot.
10. What is Spring Boot and how does it simplify Spring-based development?
11. What is business logic in a Spring Boot application, and where is it typically implemented?
12. What is the difference between unit testing and integration testing in a Spring Boot
application?
Part – C Questions

13. Explain the concept of Spring Boot Auto-Configuration in detail. How does it work
internally, and what are the key annotations involved?
14. Describe the Three-Tier and Three-Layer Architecture in the context of Spring Boot.
Discuss the roles and responsibilities of each layer and how Spring Boot facilitates the
implementation of this architecture.
15. What is Testing in Spring Boot, and what are the various testing strategies and tools used
for effective testing? Provide examples for Unit, Integration, and Mock Testing in Spring
Boot.
16. Explain the concept of a Three-Tier Architecture and how it relates to a Three-Layer
Architecture in Spring Boot.
17. Discuss what Spring is and highlight its key features like Dependency Injection (DI),
Aspect-Oriented Programming (AOP), Data Access, and Transaction Management.
18. Discuss the role of the presentation layer in a Spring Boot application and how it interacts
with the business logic.
 Unit - 5

Part – B Questions

1. What is the role of the Data Layer in a Spring Boot application?

2. What are JPA Entities in Spring Boot?
3. What is the purpose of the @Repository annotation?
4. What is Spring Data JPA?
5. Define Microservices Architecture.
6. How do you choose a database for a Spring Boot application?
7. What are the benefits of using Spring Boot Data JPA?
8. What are CRUD operations in the context of databases?
9. Explain the role of @Entity in Spring Boot.
10. What is the difference between Monolithic and Microservices Architectures?

Part – C Questions

1. Explain the process of choosing a database in a Spring Boot application.

2. Describe how to implement CRUD operations using Spring Boot Data JPA.
3. What is the significance of repositories in Spring Boot, and how are they implemented?
4. How do you design a new service in a Microservices Architecture?
5. Explain the steps involved in moving from a Monolithic to a Microservices
Architecture.
6. Discuss the components of the Data Layer in Spring Boot.
7. Describe the interaction between the User Interface (UI) and the Spring Boot backend.
8. How does Spring Boot simplify the development of Microservices?
9. Explain the architecture of a Spring Boot application with multiple data sources.
10. Discuss best practices for database design in a Spring Boot project.