In what scenarios is CallableStatement preferable over PreparedStatement?

  • Executing SQL queries with input parameters
  • Handling batch updates
  • Handling stored procedure calls
  • Optimizing read-only operations
CallableStatement is preferable when dealing with stored procedures as it allows the execution of precompiled SQL queries, making it suitable for scenarios where stored procedures are used.

A PreparedStatement can be optimized by the JDBC driver using __________.

  • batch processing
  • caching
  • connection pooling
  • query optimization
A PreparedStatement can be optimized by the JDBC driver using connection pooling, which involves reusing database connections to improve performance.

In a CallableStatement, the method _________ is used to execute a SQL function.

  • execute()
  • executeFunction()
  • executeQuery()
  • executeUpdate()
In a CallableStatement, the method executeFunction() is used to execute a SQL function.

To improve performance, a PreparedStatement uses _________ to precompile SQL statements.

  • compile()
  • precompile()
  • prepare()
  • prepareStatement()
To improve performance, a PreparedStatement uses the prepareStatement() method to precompile SQL statements.

Which method in a servlet is used by default to handle GET requests?

  • doGet()
  • doPost()
  • init()
  • service()
The doGet() method in a servlet is used by default to handle GET requests.

The CallableStatement method _________ is used to get the result set of a stored procedure.

  • executeQuery()
  • getCallResult()
  • getProcedureResult()
  • getResultSet()
The CallableStatement method getResultSet() is used to get the result set of a stored procedure.

A developer needs to insert multiple rows into a database efficiently. Which statement type and technique should they use?

  • Batch processing using PreparedStatement
  • Individual inserts using Statement
  • Stored Procedure with Cursor
  • Trigger for each row
Batch processing using a PreparedStatement is an efficient way to insert multiple rows into a database as it reduces the number of database round-trips. It allows the developer to group multiple SQL statements and execute them as a batch.

What is the role of the 'rollback' statement in transaction management?

  • Committing the changes made by the current transaction
  • Ending the current transaction
  • Initiating a new transaction
  • Reversing the changes made by the current transaction
The 'rollback' statement in transaction management is used to undo the changes made by the current transaction. If an error occurs or a condition is met, the 'rollback' command ensures that all changes made so far in the transaction are rolled back, maintaining data consistency.

What is the difference between 'dirty read' and 'non-repeatable read' in the context of transaction isolation levels?

  • Dirty read: Reading committed data
  • Dirty read: Reading uncommitted data
  • Non-repeatable read: Reading committed data
  • Non-repeatable read: Reading uncommitted data
In the context of transaction isolation levels, a 'dirty read' occurs when a transaction reads uncommitted data from another transaction, while a 'non-repeatable read' happens when a transaction reads data committed by another transaction but the data changes before the first transaction completes. Understanding these concepts is crucial in managing data consistency and isolation in concurrent transactions.

How do distributed transactions differ from local transactions?

  • Concurrency and Durability
  • Consistency and Recovery
  • Isolation and Atomicity
  • Scope and Participants
Distributed transactions involve multiple participants and a wider scope, whereas local transactions are limited to a single resource or database.