RE: a question to question
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'hemantkchitale@xxxxxxxxx'" <hemantkchitale@xxxxxxxxx>, "'remigiusz.sokolowski@xxxxxxxxxx'" <remigiusz.sokolowski@xxxxxxxxxx>
- Date: Fri, 14 Jan 2011 07:16:29 -0600
Whew!!! I read the question and was like ‘..it’s A and F..’
Glad you explained that LOL (Something interesting to keep in mind when
perusing the web I guess)
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Hemant K Chitale
Sent: Friday, January 14, 2011 5:21 AM
To: remigiusz.sokolowski@xxxxxxxxxx
Cc: oracle-l
Subject: Re: a question to question
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@xxxxxxxxxx<mailto: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<mailto: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
Other related posts:
