chapter 15 - 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.

Question 7

What does the execute() method of PreparedStatement do?

Answer 7

It executes the SQL statement and returns true if the result is a ResultSet, or false if the result is an update count or no result.

Question 8

When should you use execute() instead of executeQuery() or executeUpdate()?

Answer 8

Use execute() when the SQL could return either a ResultSet or an update count — such as dynamic SQL or stored procedures.

Question 9

After calling execute(), how do you access the result?

Answer 9

Use getResultSet() to access a ResultSet, or getUpdateCount() for the number of affected rows. Use getMoreResults() for additional results.