Oracle always enforces _________level read consistency.

Options
- Statement
- Transaction
- Isolation
- All of the above


CORRECT ANSWER : Statement

Discussion Board
Statement-Level Read Consistency

Oracle always enforces statement level read consistency. This guarantees that all the data returned by a single query comes from a single point in timeā€”the time that the query began. Therefore, a query never sees dirty data or any of the changes made by transactions that commit during query execution. As query execution proceeds, only data committed before the query began is visible to the query. The query does not see changes committed after statement execution begins.


Prajakta Pandit 03-2-2017 11:34 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement