Re: a question to question

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Sun, 16 Jan 2011 09:42:33 +0000
Message-ID: <AANLkTi=n0ersMLAaA2VMH-vOaGwx2c4_=N4=DH6ddJu7_at_mail.gmail.com>

I think that's too harsh. The text comes from one ( more actually ) of the "brain dump" sites for OCP. Meaning it is what someone who was taking the test thought the answer to that question was. We're all allowed to be wrong sometimes. Similarly just trusting stuff on the internet - particularly if it comes without an explanation that we can evaluate is fool hardy - not because people are deliberately misleading you, though they do, but because they can be just wrong. .

On Fri, Jan 14, 2011 at 11:20 AM, Hemant K Chitale <hemantkchitale_at_gmail.com
> wrote:

> Those suggested answers are "designed" to make you *fail* the exam.
>
> A and F are the correct answers.
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
> sent from my smartphone
>
> On Jan 14, 2011 6:57 PM, "Remigiusz Sokolowski" <
> remigiusz.sokolowski_at_nordea.com> wrote:
>
> hi,
>
> just preparing to some exams and found some typical queries on internet
> with answers
>
> for example
> TK 2: Which two steps are performed the first time any Update statement
> is issued after the instance is started ? Choose two
> A. Creating the parse tree of the statement
> B.Writing the modified data blocks to data files
> C.Writing the modified data to the archived redo log files
> D.Updating the control file to indicate the most recent checkpoint
> E.Updating the data file header to indicate the most recent checkpoint
> F. Reading the blocks to database buffer cache if they are not already
> there
> 答案：C，D.
> -------------------------
> The answer is provided as C and D.
>
> But IMHO every query is a subject to parse before execution, and I would
> rather tell that blocks to be modified need to be read to buffer cache
> before modification and thus prior to writing the modified data to
> archived redo logs.
> Concluding A and F
>
> Or may be I do not understand the question well as English is not my
> primary language.
>
>
> TIA
> Remigiusz
>
> --
> Pole nakazi
>
> ----------------------------------------------------------------------
> Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
> pos : DBA at DIiUSI
> addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
> phone : +48 58 667 17 43
> mobile: +48 602 42 42 77
>
> Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
> wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod
> numerem: 0000021828,
> dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku,
> VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego,
> o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych,
> NIP: 586-000-78-20, REGON: 190024711
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Sun Jan 16 2011 - 03:42:33 CST