Re: OCP Question

From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Wed, 9 Dec 2009 21:12:55 -0800 (PST)
Message-ID: <4192.67666.qm_at_web32007.mail.mud.yahoo.com>

Bill,
Obviously you didn't realize you were studying for the dyslexic version of the OCP...  :)

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen  
"Go away before I replace you with a very small and efficient shell script..."

• On Wed, 12/9/09, Surachart Opun <surachart_at_gmail.com> wrote:

From: Surachart Opun <surachart_at_gmail.com> Subject: Re: OCP Question
To: bill_at_intactus.com
Cc: "Oracle-L_at_freelists.org" <oracle-l_at_freelists.org> Date: Wednesday, December 9, 2009, 10:06 PM

If you enabled flashback database, you'll see this process.

check flashback database status .
SQL> select flashback_on from v$database;

> RVWR writes the Flashback Database data to Flashback Database logs

Surachart Opun
http://surachartopun.com

On Thu, Dec 10, 2009 at 4:31 AM, Bill Zakrzewski <bill_at_intactus.com> wrote:

Hi all -

I am studying for the 10g OCP exam and came across a question that is incorrect in the book and wanted to know if it was just a typo or totally incorrect.

Question:
What is responsible for applying the "before" images to the database during a Flashback Database recovery?

1. LGWR
2. SMON
3. DBWR
4. RWVR

The answer key stated "D. RWVR", but if this is the correct answer it should be "RVWR".

Is the answer "RVWR"????

Thanks,
Bill--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 09 2009 - 23:12:55 CST