Basic Oracle Concepts and Programming Question:
What Are the General Rules on Data Consistency?
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.
► 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.
| Previous Question | Next Question |
| What Are the Restrictions in a Oracle READ ONLY Transaction? | What Are Transaction Isolation Levels Supported by Oracle? |