Re: OCP Question

  • From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
  • To: bill@xxxxxxxxxxxx, surachart@xxxxxxxxx
  • Date: Wed, 9 Dec 2009 21:12:55 -0800 (PST)

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@xxxxxxxxx> wrote:


From: Surachart Opun <surachart@xxxxxxxxx>
Subject: Re: OCP Question
To: bill@xxxxxxxxxxxx
Cc: "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxx> 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?

A. LGWR
B. SMON
C. DBWR
D. RWVR

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

Is the answer "RVWR"????

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






      

Other related posts: