JDBC

Question 1

What is JDBC?

Answer 1

Java Database Connectivity (JDBC) is a Java API to connect and execute queries with a database. The classes and interfaces of the JDBC allow the application to send requests made by the user to the specified database

Question 2

What are the core interfaces/classes in JDBC?

Answer 2

DriverManager
Connection
Statement
PreparedStatement
ResultSet
SQLException
RowID

Question 3

What is a stored procedure and how would you call it in Java?

Answer 3

It is a prepared SQL code that can be saved so that it can be called over and over again. To call it in Java, you would use the CallableStatement interface.

Question 4

What is the difference between Statement and PreparedStatement?

Answer 4

Statement is used to execute string based SQL queries

PreparedStatement is used to execute SQL queries that contain parameters

Question 5

Steps to executing an SQL query using JDBC?

Answer 5

1. Establish a connection to the database
2. Create a statement
3. Execute a query
4. If the query returns a result, process the result using ResultSet
5. Close the connection

Question 6

How to execute stored procedures using JDBC?

Question 7

Which interface is responsible for transaction management?

Answer 7

Connection interface provides methods to manage transactions