DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ocp test question

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    65
    Dear all,

    This is an OCP test question
    A checkpoint will do the following:

    A. Write data buffers to disk; update the control file and data file headers with new SCN
    information
    B. Write data buffers to disk only
    C. Update the controlfile and write data buffers to disk
    D. Update the controlfile and file headers with new SCN information

    Please take time to answer the above question. one of the 4 choices from the above, is right. Which one?

    nk


  2. #2
    Join Date
    Apr 2001
    Posts
    110
    The answer should be (D) Update the controlfile and file headers with new SCN information.

    Writing of data buffer to disk is done by DBWn.
    The checkpoint background process only updates the controlfile and data file headers.


  3. #3
    Join Date
    Oct 2000
    Posts
    23
    though write buffer cached data to disk is done by DBWn, it will be done every checkpoint.

    So I do not know what the 'checkpoint do ' means.

  4. #4
    Join Date
    Nov 2000
    Posts
    65

    Question

    Hi eastking & oracbase,

    I agree with you guys!!

    http://www.dbasupport.com/forums/sho...threadid=10894

    Follow the above thread. you will see this as 20-25 question
    from the top. And it says that the answer is A!!

    I had my own doubts.. hence i wanted to check with you guys.

    thank you,
    nk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width