Lately, I am creating a payroll system using oracle database. This is a mcqs on oracle architecture, which version of oracle supported multi-version read consistency?
The latest release Oracle 11g supports multi-version read consistency.
Multiple versions of the data can be materialized and the following features are offered:
1) Â The data obtained by a committed query is always consistent.
2) Â No dirty reads is allowed where uncommitted data is read by a transaction.
3) Â Database readers and database writers can't block each other.
For more details on Oracle consistency you should check Oracle official documentation.
Hello Finlay,
Oracle 11g is the latest release and it supports multi-version read consistency. The features offered are the following: A databases writers and readers can't block each other + the data obtained by a committed query is always consistent. And finally, no dirty reads is allowed where uncommitted data is read by a transaction.
