Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

What Are the General Rules on Data Consistency?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

► All SQL statements always work with a snapshot of the database to provide data consistency.
► For READ WRITE transactions, the snapshot is taken when each statement starts.
► For READ ONLY transactions, the snapshot is taken when the transaction starts.
► The snapshot never include uncommitted changes from other transactions.
► The snapshot always include uncommitted changes from its own transaction.

Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
What Are the Restrictions in a Oracle READ ONLY Transaction?What Are Transaction Isolation Levels Supported by Oracle?