OCP Question

From: Jay Wade <fish_dba_at_hotmail.com>
Date: Tue, 05 Aug 2003 07:59:23 -0800
Message-ID: <F001.005C908F.20030805075923@fatcity.com>

Hello:

I was going through some OCP questions and wanted to make sure that my answers where correct.
This question comes from a 3rd party testing site, I have been checking each question against my study guides to make sure they are correct.

I've done some testing and think that my answers might be correct but would like to double check as well as get anyone elses option on the answers and the reasoning for option E.

When the status of the tablespace moves from read-only to read write, which tow events occur?
(Choose Two)

1. Redo-log switch must take place
2. Normal checkpoints on the file now occur
3. Oracle automatically marks the file for backup
4. All objects in the tablespace are checked for integrity
5. The the DBWn process writes to the data files of the tablespace

I believe the answers are A, B

Reason:
A) I tested moving the a tablespace from read-only to read write and have noticed a log switch after moving the tablespace to a writeable state. B) Since it is on longer Read-Only it will be updated during the checkpoint process
C) Doesn't happen, at least in my reading or testing D) No verify structure is issued, or any of the other oracle tools for object checking are used
E) I'm alittle unsure of this one, it should update the headers how since it is in a Read Write mode, although this should only happen at a checkpoint right?

Thanks in Advance,
Jay

---

MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Wade
  INET: fish_dba_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Tue Aug 05 2003 - 10:59:23 CDT