COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which isolation level prevents dirty read in JDBC, connection class.
|
|
TRANSACTION ____ READ ____ COMMITTED
|
|
|
TRANSACTION ____ READ ____ COMMITTED
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The repeatable read transaction isolation level is the default. This isolation level prevents dirty reads and non-repeatable reads, but does not prevent phantom reads. A dirty read is a read operation that occurs on data that has been modified by a transaction but has not been committed.
Detailed explanation-2: -Read Uncommitted − It is the lowest level of isolation. At this level; the dirty reads are allowed, which means one can read the uncommitted changes made by another.
Detailed explanation-3: -By default, SQL Server uses an isolation level of Read Committed, which means a query cannot read data modified by another transaction that has not yet committed, thus preventing dirty reads.
There is 1 question to complete.