OraFAQ Forum: Training & Certification » Query regarding exam question of 1Z0-042

Home » Other » Training & Certification » Query regarding exam question of 1Z0-042 (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query regarding exam question of 1Z0-042 [message #521448]

Tue, 30 August 2011 01:21

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Hi All,

I was going through the practice questions of exam 1z0-042.
I got following question and options of that question.

Quote:

Which two steps are performed the first time any UPDATE statement is issued after the instance is started?

A. Creating the parse tree of the statement
B. Writing the modified data blocks to the 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

As per my knowledge, answer is A & F.
But it was mentioned that correct answer is C & D.

Can anyone please tell me what is the correct answer?

regards,
Delna

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521452 is a reply to message #521448]

Tue, 30 August 2011 01:50

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I agree with you.

Regards
Michel

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521454 is a reply to message #521452]

Tue, 30 August 2011 01:55

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Thanks Michel sir.

Is there any reference where I can confirm this?

regards,
Delna

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521455 is a reply to message #521454]

Tue, 30 August 2011 02:02

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

It's probably in the concepts book (sorry, I've gone through so much reading I lose track of what is held where).

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521459 is a reply to message #521455]

Tue, 30 August 2011 02:44

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Same problem here. Sad

regards,
Delna

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521478 is a reply to message #521459]

Tue, 30 August 2011 04:51

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

There's no way it's C and D.
C happens for every update, regardless of how many times its been run

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521485 is a reply to message #521478]

Tue, 30 August 2011 07:55

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Doesn't C only happen for committed updates?

I thought logs were only archived when no longer in use. I may be mistaken.

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521486 is a reply to message #521485]

Tue, 30 August 2011 08:09

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

Possibly, I should check really, but regardless, it's still not related to the first time an update is run after restart.

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521487 is a reply to message #521485]

Tue, 30 August 2011 08:42

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

Both committed updates and uncommitted changes will (eventually) be in the archive logfiles. The way I think if it is that Oracle doesn't really do rollback at all. The ROLLBACK command generates another set of DML statements that reverse the effect of the first set, and then commits the whole lot as one transaction. So C applies to both committed and uncommitted changes (though it is still wrong, of course.

Report message to a moderator

Re: Query regarding exam question of 1Z0-042 [message #521556 is a reply to message #521487]

Wed, 31 August 2011 02:13

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Cheers.

It has been a little while before I looked at the archive log mechanics in 'anger', I assumed I'd forgotten something.

Bit of a hijack Wink

Report message to a moderator

Previous Topic:	Need Some Guidance For implementing one Application as oracle DBA
Next Topic:	Oracle Application Framework (OAF) Training

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 08 07:51:01 CDT 2025