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