a question to question

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 14 Jan 2011 11:56:51 +0100
Message-ID: <4D302BF3.3030304_at_nordea.com>


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

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.



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 Received on Fri Jan 14 2011 - 04:56:51 CST

Original text of this message