Mcqs question on version of oracle for multi-version read consistency

Asked By 50 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Aurtt munguia
Best Answer
Best Answer
Answered By 0 points N/A #132366

Mcqs question on version of oracle for multi-version read consistency

qa-featured

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.

Answered By 0 points N/A #132367

Mcqs question on version of oracle for multi-version read consistency

qa-featured

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.

Login/Register to Answer

Related Questions