JDBC

Question 1

Which interface can be used to execute a stored procedure on the database?

Answer 1

The CallableStatement interface in Java is used to execute stored procedures on a database. It is part of the java.sql package and allows calling both stored procedures and functions.

Question 2

JDBC stands for Java Database Connectivity and is used to connect Java applications to databases.

Answer 2

true

Question 3

In JDBC, the Connection interface is used to send SQL statements to the database.

Answer 3

False (The Statement interface is used to send SQL statements, while Connection is used to establish a database connection.)

Question 4

The DriverManager class is responsible for loading database drivers and establishing connections.

Answer 4

True

Question 5

The ResultSet interface in JDBC is used to update the structure of the database tables.

Answer 5

False (ResultSet is used to retrieve and navigate query results, not update table structure.)

Question 6

JDBC in Java 17 supports try-with-resources to automatically close resources such as Connection, Statement, and ResultSet.

Answer 6

True.