+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Nov 2011
    Posts
    5

    Questions about 1Z0-042 test

    Hi All,

    I was going through the practice questions of exam 1z0-042.
    I got following question and options of that question.
    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?

  2. #2
    THE Gimp Clown Fish! nemowolf's Avatar
    Join Date
    Jun 2007
    Location
    Bay Area
    Posts
    4,935
    Quote Originally Posted by Brewster View Post
    Hi All,

    I was going through the practice questions of exam 1z0-042.

    I got following question and options of that question.
    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?

    Lets reverse this. What makes you think that answer A and F are correct instead of C and D!?

    TechIMO Folding@home Team #111 - Crunching for the cure!

  3. #3
    Junior Member
    Join Date
    Nov 2011
    Posts
    5
    I seemly skip this questions in my study materials before,but I don't remember which study materials it is written.so i want to confirm.

Quick Reply Quick Reply

If you are already a member, please login above.

What planet do we live on?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 3d mark test questions
    By daiddu in forum General Tech Discussion
    Replies: 6
    Last Post: November 3rd, 2004, 11:00 PM
  2. Questions...questions that need answering
    By Ymer in forum Technical Support
    Replies: 5
    Last Post: September 25th, 2003, 01:43 PM
  3. Test exams/ questions
    By ribster in forum Certification and Education
    Replies: 1
    Last Post: January 31st, 2003, 12:54 PM
  4. Wireless, wired, which router questions questions
    By Detritus in forum Networking and Internet
    Replies: 8
    Last Post: October 18th, 2002, 01:28 PM
  5. Modem test ? Test number?
    By amdkt7 in forum General Tech Discussion
    Replies: 12
    Last Post: April 7th, 2002, 01:28 PM

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Copyright 2014 All Enthusiast, Inc