Consider code: String query = "SELECT * FROM users WHERE id=" + userId; stmt.executeQuery(query); What security issue exists?
How would you implement batch processing in JDBC for multiple INSERT operations?
What is the difference between execute(), executeQuery(), and executeUpdate()?
Which JDBC feature allows you to call stored procedures?
In JDBC, what does the ResultSet.TYPE_SCROLL_INSENSITIVE constant represent?
Advertisement
What is the difference between update() and updateRow() methods in ResultSet?
A developer wants to prevent SQL injection attacks while executing dynamic queries. Which approach is most secure?
What is the default transaction isolation level in JDBC when autocommit is disabled?
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?
