COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How many transaction isolation levels are defined in java.sql.Connection interface?
|
|
4
|
|
|
3
|
|
|
5
|
|
|
2
|
Explanation:
Detailed explanation-1: -There are five levels of transaction isolation in the IBM® Developer Kit for Java™ JDBC API.
Detailed explanation-2: -A connection determines its own isolation level, so JDBC provides an application with a way to specify a level of transaction isolation. It specifies four levels of transaction isolation.
Detailed explanation-3: -four transaction isolation levels in SQL Server 7.0: Uncommitted Read (also called “dirty read"), Committed Read, Repeatable Read, and Serializable.
Detailed explanation-4: -There are 4 main types of isolation levels in a database: Read Committed. Read Uncommitted. Repeatable Reads.
There is 1 question to complete.