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? A) 7 B) 8 C) 8i D) 9i Answer D. The real answer as we know is C. Which statement is true about the TIMESTAMP WITH TIME ZONE datatype? A) It represents absolute time. B) In addition to the date and time, you can store the time zone displacement (offset), which requires additional bytes of storage. C) In addition to the date and time, you can store the time zone displacement (offset), without consuming additional bytes of storage. D) 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" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/20/2003 02:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > Date: 2003/11/12 Wed PM 12:19:32 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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. > [EMAIL PROTECTED] > > -----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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).