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

Asked By Finlay 50 points N/A Posted on - 11/19/2012

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?

• Status: Open
• Question Views: 957
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Aurtt munguia

Go To Solution

Best Answer

Best Answer

Answered By Aurtt munguia 0 points N/A #132366

Mcqs question on version of oracle for 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.

About Aurtt munguia

Questions
1

Answers
66

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 11/22/2012
• Question Category: Oracle Database

Answered By Manning Wickersham 0 points N/A #132367

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

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.

About Manning Wickersham

Questions
1

Answers
33

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 05/22/2013
• Question Category: Oracle Database