Oracle-L: RE: OCP Question

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 05 Aug 2003 08:14:23 -0800
Message-ID: <F001.005C9092.20030805081423@fatcity.com>

Jay,

I would guess B and E. I see no reason for a redo-log switch. Looks like a trick question. B is one correct answer. The other correct is either E or A. I would go for E.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, August 05, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L

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)

Redo-log switch must take place
Normal checkpoints on the file now occur
Oracle automatically marks the file for backup
All objects in the tablespace are checked for integrity
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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------