Re: a question to question

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Sun, 16 Jan 2011 18:14:02 +0800
Message-ID: <AANLkTimxdN4dC-jg68CEr4yCj8kECciMSMWCOEy7AsJ-_at_mail.gmail.com>

You mean to say that people actually read answers which don't even claim to be authoritative and correct ?

(sheesh : I thought that some of the stuff on the Internet at least presents itself as "correct" !)

Hemant

On Sun, Jan 16, 2011 at 5:42 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> 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
>

-- 

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com
http://web.singnet.com.sg/~hkchital

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

Received on Sun Jan 16 2011 - 04:14:02 CST