RE: RE: OCP 9i New Features for DBAs

Jared,  

I didn't make a detailed list but where I clearly noticed the inaccuracies was in the sample exam questions at the back of the book e.g.  

In which version of Oracle was hash partitioning introduced?  

1. 7
2. 8
3. 8i
4. 9i

Answer D. The real answer as we know is C.  

Which statement is true about the TIMESTAMP WITH TIME ZONE datatype?  

1. It represents absolute time.
2. In addition to the date and time, you can store the time zone displacement (offset), which requires additional bytes of storage.
3. In addition to the date and time, you can store the time zone displacement (offset), without consuming additional bytes of storage.
4. You can use the NLS_TIMESTAMP_TZ_FORMAT initialisation parameter to specify the default timestamp format for retrieval.

    Answer C. The real answer is B.  

What this means is that you need to checkout the answers when marking yourself just to be on the safe side. I must point out that on a couple of occaisions the book was right when I initially thought it was wrong.  

Cheers,  

Chris

-----Original Message-----
Sent: 20 November 2003 18:35
To: Multiple recipients of list ORACLE-L

Chris,

Care to share details on the inaccuracies?

Jared

        "Dunscombe, Chris" <Chris.W.Dunscombe_at_accenture.com> Sent by: ml-errors_at_fatcity.com

 11/20/2003 02:44 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> 
        cc:         
        Subject:        RE: RE: OCP 9i New Features for DBAs

Ryan,

I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle 9i Database: New Features for Administrators Exam Guide book. Even though there are a number of inaccuracies it was good preparation especially the sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all seemed to be 9.0.

Hope all goes well when you take your exam.

Cheers,

Chris

-----Original Message-----
Sent: 12 November 2003 18:25
To: Multiple recipients of list ORACLE-L

im going to take it soon. I was going to just read howard rogers guide then the otn one.

you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me.
>
> From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> Date: 2003/11/12 Wed PM 12:19:32 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: OCP 9i New Features for DBAs
>
> Chris
> I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle
> would have had to go back and recreate the test. And Oracle would have
felt
> compelled to change the name of the test. However, I think it possible
that
> any question whose answer would be true for 9.0 but false for 9.2 might be
> removed.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Wednesday, November 12, 2003 10:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> I'm currently studying for this exam but can't find info to say whether
the
> exam covers 9.2 or just 9.0. Anyone any clues
>
> Thanks,
>
> Chris Dunscombe
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Dunscombe, Chris
> INET: Chris.W.Dunscombe_at_accenture.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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: <ryan_oracle_at_cox.net
 INET: ryan_oracle_at_cox.net

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: Dunscombe, Chris
 INET: Chris.W.Dunscombe_at_accenture.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: Dunscombe, Chris
  INET: Chris.W.Dunscombe_at_accenture.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).