Re: a question to question
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: remigiusz.sokolowski@xxxxxxxxxx
- Date: Fri, 14 Jan 2011 17:08:29 +0530
I too agree with A and F
thnaks..subodh
On 14 January 2011 16:26, Remigiusz Sokolowski <
remigiusz.sokolowski@xxxxxxxxxx> 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@xxxxxxxxxx>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
