Which of the following allows non repeatable read in JDBC Connection?

Options
- TRANSACTION_READ_UNCOMMITTED
- TRANSACTION_READ_COMMITTED
- TRANSACTION_SERIALIZABLE
- TRANSACTION_REPEATABLE_READ


CORRECT ANSWER : TRANSACTION_REPEATABLE_READ

Discussion Board
Java

Good

Shubham 05-12-2020 02:17 AM

Answer - TRANSACTION_READ_UNCOMMITTED OR TRANSACTION_READ_COMMITTED

The answer given above is wrong as Non-Repeatable Reads happen when a query returns data that would be different if the query were repeated within the same transaction. It can occur when other transactions are modifying data that a transaction is reading. Transaction_Read_Uncommitted or Transaction_Read_Committed. A session is created when a connection to a specific database gets created. SQL statements gets executed and the results gets return within the context of a connection.

Rohit Sharma 09-16-2014 04:25 PM

Wrong answer

Actually, TRANSACTION_REPEATABLE_READ DOES NOT ALLOW non-repeatable reads in JDBC.

http://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.html

Answer is A or B.

Mark 02-19-2014 05:35 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement