41.) What is the purpose of the JDBC BatchUpdateException class?
A) To handle exceptions when executing SQL queries
B) To manage database transactions
C) To provide information about batch update failures
D) To retrieve metadata about the database
42.) Which JDBC interface is used to work with large binary or character data, such as images or text documents?
A) Blob
B) Clob
C) A and B both
D) NClob
43.) In JDBC, what is the purpose of a CallableStatement?
A) To execute complex SQL queries
B) To call stored procedures in the database
C) To handle SQL exceptions
D) To create database triggers
44.) Which method allows you to retrieve additional information about database connections in JDBC?
A) getDatabaseInfo()
B) getConnectionInfo()
C) getMetaData()
D) getDatabaseDetails()
45.) Which SQL join type returns all rows from both tables, filling in missing values with NULL?
A) INNER JOIN
B) LEFT JOIN
C) RIGHT JOIN
D) FULL JOIN
46.) What is the purpose of the JDBC “Savepoint” interface?
A) To save the entire database state
B) To set a specific point within a transaction to which you can later roll back
C) To create database backups
D) To prevent SQL injection attacks
47.) In JDBC, what is the significance of the ‘isClosed()’ method for a Connection object?
A) It checks if the database is closed.
B) It checks if the JDBC driver is closed.
C) It checks if the connection to the database is closed.
D) It checks if the connection pool is closed.
48.) Which JDBC feature allows you to specify the fetch size for a result set?
A) Connection pooling
B) Batch processing
C) ResultSet pagination
D) Statement caching
49.) In JDBC, what is the significance of the RowSet interface?
A) It represents a single row from a result set.
B) It is used to retrieve metadata about database tables.
C) It provides a scrollable and updatable result set.
D) It handles exceptions during SQL query execution.
50.) In JDBC, what is the primary purpose of the DriverManager class?
A) To manage database connections and connection pooling
B) To provide access to the JDBC API documentation
C) To execute SQL queries asynchronously
D) To control database server configurations