In Oracle Database,to achieve transaction level consistency,which level of transaction isolation must be used?
A)Read Committed
B)Serializable
C)Repeatable Read
D)Read-only
E)Read Uncommitted

Question

Quizplus · Accepted Answer

Serializable isolation level guarantees transaction level consistency by ensuring that multiple transactions cannot interfere with each other. It achieves this by locking the rows and preventing other transactions from accessing them until the current transaction is complete. This level of isolation ensures that the database does not allow dirty reads, non-repeatable reads, and phantom reads, which helps in achieving consistency.

In Oracle Database,to Achieve Transaction Level Consistency,which Level of Transaction