10 Marks
1. Discuss the four types of JDBC drivers.
2. Explain the difference between Statement, PreparedStatement, and
CallableStatement. When would you use each?
3. Explain how to handle exceptions in JDBC. What are the best practices
for managing SQLExceptions?
4. Describe the hierarchy of SQLExceptions and how they are thrown, as
well as best practices for error handling.
5. What is the purpose of the [Link] package, and how does it relate to
JDBC?
6. Discuss the role of the [Link] package, focusing on DataSource,
RowSet, and connection pooling.
7. What is the JDBC API, and how does it interact with different
databases?
8. Explain what is the role of the `session` object in JSP?
9. Explain what configurations or annotations are required to enable batch processing in
JPA?
10. Explain the difference between Statement, PreparedStatement, and CallableStatement.
When would you use each?
11. What is the significance of @ResponseBody in @RestController, and how does it
eliminate the need for view resolution?
12. What are Spring Boot starters, and how do they simplify dependency
mnagement?
13. Explain what are the basic steps to create a JDBC application?
20 Marks
1. What is the purpose of the @ManyToMany annotation in JPA, and how would you
implement a many-to-many relationship?
2. What is the difference between @Component,@Service,@Repository and @Controller
annotations in Spring Boot
3. Write a JSP program to display a Sample shopping Order calculation Form
and display output in tabular form.
4. Explain the concept of Object-Relational Mapping (ORM). How does Hibernate implement ORM?
10 Marks
1. How are requests and responses handled in a Servlet?
2. What is the role of the `doGet()` and `doPost()` methods in a Servlet?
3. Explain when and why each of these methods is used. What is the difference between GET
and POST HTTP methods?
4. Explain the concept of servlet request and response.
5. What classes in the [Link] package are used for handling HTTP requests and
responses?
6. What are the key methods provided by HttpServletRequest and HttpServletResponse for
handling request and response data?
7. What is the difference between GenericServlet and HttpServlet?
8. Explain the different techniques used for managing sessions in Servlets.
9. What are the different types of JDBC drivers? Describe their advantages and
disadvantages.
10. What are the life-cycle methods for a servlet?
11. Explain how does @Column differ from the default mapping in JPA?
12. What is HQL, and how does it differ from SQL? Provide an example of an HQL query.
13. What is the @RestController annotation in Spring, and how does it differ from @Controller?
14. How does Spring Data JPA reduce boilerplate code for data access and CRUD operations?
15. Explain what are the types of ResultSet?
20 Marks Questions
1. How does Spring handle exceptions globally in Spring MVC?
2. Write a Java Servlet program to read employee details including employee number (empno),
name, designation, basic pay, deductions, and allowances, and then calculate and display the net
salary. display the information in tabular form by selecting the details from Emp_sal database
table.
3. Explain how to implement a join table for a @ManyToMany relationship in JPA.
4. Write a Hibernate Program for product information and display the information by selecting the details
from product database table.
10 Marks
1. Explain what is the role of the `session` object in JSP?
2. Explain how to create, read, and invalidate sessions in a JSP page?
3. Explain the difference between a JSP and a Servlet ?
4. Explain what are the advantages and disadvantages of using JSP over Servlets?
5. Explain what are implicit objects in JSP?
6. Explain the concept of JPA and how it simplifies database interaction in Java
applications.
7. What is JPA, and what role does it play in Java enterprise applications?
8. What are the key advantages of using JPA in comparison to using plain JDBC?
9. What is the role of the DriverManager in JDBC, and how does it function in terms of
managing database connections?
10. Define JavaServer Pages (JSP). How does JSP differ from Servlets in terms of
architecture and functionality?
11. Explain the life cycle of a servlet. What are the key phases, and what methods are
invoked during each phase? init() service() destroy().
12. How does batch processing improve the performance of JPA-based applications?
13. How does Hibernate manage relationships between entities (One-to-One, One-to-
Many, Many-to-One, and Many-to-Many)?
14. How does Spring Boot simplify configuration and deployment of Spring applications?
15. How does Hibernate handle transaction management?
20 Marks Questions
1. Create a JPA application to perform CRUD operations on a simple entity (e.g., Product).
Include methods for creating, retrieving, updating, and deleting Product entities.
Demonstrate the use of EntityManager for persistence operations.
2. a)Write a servlet Program for student information and display the information in tabular form
by selecting the details from student database table OR b) Explain what is the purpose of
[Link]() method
3. Describe how you would implement a reactive REST API using Spring WebFlux.
4. Implement a program to handle different types of JDBC exceptions effectively. Write JDBC
Program to calculate Employee salary and print the salary statement in tabular form by selecting
the details from database table (Emp_Sal) using Prepared Statement.