Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

What Are Transaction Isolation Levels Supported by Oracle?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

Oracle supports two transaction isolation levels:

► READ COMMITTED (the default option). If the transaction contains DML that requires row locks held by another transaction, then the DML statement waits until the row locks are released.
► SERIALIZABLE. If a serializable transaction contains data manipulation language (DML) that attempts to update any resource that may have been updated in a transaction uncommitted at the start of the serializable transaction, then the DML statement fails.


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
What Are the General Rules on Data Consistency?What Is a Data Lock in Oracle?