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.
How should a developer handle a scenario where a stored procedure returns multiple result sets?
- Close the connection and reopen it
- Ignore additional result sets
- Use multiple ResultSets and process each separately
- Use only the first result set
To handle multiple result sets returned by a stored procedure, the developer should use multiple ResultSets and process each one separately. Ignoring additional result sets or closing and reopening the connection are not appropriate solutions.
In a transactional context, if one of the PreparedStatement executions fails, what should be the approach for handling this situation?
- Commit the successful executions, ignore the failure
- Continue with the next PreparedStatement
- Manually undo the changes of successful executions
- Rollback the entire transaction
In a transactional context, if one of the PreparedStatement executions fails, the appropriate approach is to rollback the entire transaction to maintain data consistency. Committing successful executions and ignoring the failure may lead to inconsistent data.
What is the primary purpose of transaction management in database operations?
- Encrypting data
- Ensuring data consistency
- Managing user permissions
- Optimizing queries
The primary purpose of transaction management is to ensure data consistency by either committing or rolling back changes as a single, atomic operation.
Which SQL statement is used to start a transaction in a database?
- BEGIN TRANSACTION
- COMMIT TRANSACTION
- ROLLBACK TRANSACTION
- START TRANSACTION
The START TRANSACTION statement is used to begin a transaction in a database, marking the starting point for a series of SQL statements to be treated as a single unit.
A transaction's property ensuring that either all its operations are completed successfully, or none are, is known as _________.
- Atomicity
- Consistency
- Durability
- Isolation
A transaction's property ensuring that either all its operations are completed successfully, or none are, is known as Atomicity.
A transaction in a financial application requires updating multiple accounts. If one update fails, what should happen to ensure data consistency?
- Commit the successful updates
- Ignore the failed update and proceed
- Log the failure and retry the update
- Rollback the entire transaction
In a financial application, to ensure data consistency, it's crucial to rollback the entire transaction if any update within it fails. This helps maintain the integrity of the financial data.
In transaction management, what does the term 'ACID' stand for?
- Advanced Commitment Integration Design
- All Committed in Database
- Association of Commitment in Databases
- Atomicity, Consistency, Isolation, Durability
'ACID' stands for Atomicity, Consistency, Isolation, and Durability, which are the key properties ensuring reliable and secure database transactions.