Java Programming - MCQ Practice Questions

Which method is used to check if a CallableStatement has a return value from a stored procedure?

A batch update operation fails partially. How can you identify which statements failed in the batch?

In JDBC, what is the purpose of using a SavePoint in a transaction?

A developer creates a JDBC connection but forgets to close it. What might be the consequence?

Consider a scenario where a developer retrieves a ResultSet and then closes the Statement object. What happens to the ResultSet?

What is the optimal approach to handle JDBC resources to prevent memory leaks in a production application?

In a multi-threaded JDBC application, why should each thread have its own Connection object?

Consider a scenario: A developer uses Statement with user input directly in SQL queries. What is the primary risk?

In a JDBC application, when using transactions with setAutoCommit(false), what happens to intermediate savepoints if rollback() is called?

Which JDBC feature should be used for executing multiple SQL statements in a batch for optimal performance?

In JDBC, what is the significance of setting FetchSize on a Statement when dealing with large ResultSets?

When using JDBC with Spring Framework in 2024-25, which approach is recommended for resource management?

A developer wants to retrieve data from a stored procedure that returns multiple result sets and output parameters. Which approach is correct?

A query execution takes 5 seconds consistently. Which JDBC optimization technique should NOT be used for this scenario?

In a JDBC application using batch updates, what happens if one statement in the batch fails?

A Java application requires connection pooling to handle 1000+ concurrent database requests efficiently. Which JDBC component should be implemented?

In JDBC metadata operations, which method is used to retrieve information about table structure, column names, and their data types?

Which of these correctly demonstrates the Producer Extends Consumer Super (PECS) principle?

What will happen with this code? List list = new ArrayList<String>(); list.add(123); // Adding Integer String s = (String) list.get(0);

Consider this code: public <T extends Comparable<T>> T getMax(T a, T b) { return a.compareTo(b) > 0 ? a : b; } What is the benefit of this recursive bound <T extends Comparable<T>>?