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?
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-- Mai
Re: RE: OCP 9i New Features for DBAs
Yeah, tell me, too! I'm about to teach a 5-day course for passing OCP in January. Don't mind if I post completely inaccurate answers to this list at this time, I just have to change my way of thinking for then ;) Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, November 20, 2003 8:35 PM Subject: RE: RE: OCP 9i New Features for DBAs 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 DBAsRyan,I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle9i Database: New Features for Administrators Exam Guide book. Even thoughthere are a number of inaccuracies it was good preparation especially thesample exams it provides. Regarding 9.2 vs 9.0 content in the exam it allseemed to be 9.0.Hope all goes well when you take your exam.Cheers,Chris -Original Message-Sent: 12 November 2003 18:25To: Multiple recipients of list ORACLE-Lim going to take it soon. I was going to just read howard rogers guide thenthe 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 havefelt> compelled to change the name of the test. However, I think it possiblethat> 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 whetherthe> 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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 Ci
RE: RE: OCP 9i New Features for DBAs
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).
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).
Re: RE: OCP 9i New Features for DBAs
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).
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).
RE: OCP 9i New Features for DBAs
Runs on 9.2 but there's nothing specific to 9.2 rather than 9.0, IIRC. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA. -Original Message- Dunscombe, Chris Sent: Thursday, November 13, 2003 3: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: Pete Sharman 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).
