Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!news3.optonline.net!newshosting.com!news-xfer2.atl.newshosting.com!209.98.3.206.MISMATCH!hermes.visi.com!news-out.visi.com!petbe.visi.com!tor-nx1.netcom.ca!tor-nn1.netcom.ca.POSTED!not-for-mail
From: "Syltrem" <syltremzulu@videotron.ca>
Newsgroups: comp.databases.oracle.server
References: <pparimal.y8xua@mail.mcse.ms> <9DaCb.26306$8y1.117940@attbi_s52> <brcjmt$254$1@srv.cyf-kr.edu.pl>
Subject: Re: OCP Certification
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <2IkCb.6950$G1.32082@tor-nn1.netcom.ca>
Date: Fri, 12 Dec 2003 10:01:57 -0500
NNTP-Posting-Host: 216.191.6.50
X-Complaints-To: abuse@allstream.net
X-Trace: tor-nn1.netcom.ca 1071241086 216.191.6.50 (Fri, 12 Dec 2003 09:58:06 EDT)
NNTP-Posting-Date: Fri, 12 Dec 2003 09:58:06 EDT
Organization: Allstream
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:249981

I downloaded the whizlabs trial, and noted 4 errors or misleading
questions/answers in 10 questions IIRC. Quite bad.
The ones from selftest software are not bad at all. A few badly stated
questions, and when this is the case they always agree to change them in a
next version. Good product I would say.

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Lucyna Witkowska" <ypwitkow@nospamcyf-kr.edu.pl> a écrit dans le message de
news:brcjmt$254$1@srv.cyf-kr.edu.pl...
> Michael J. Moore <NOhicamelSPAM@comcast.net> wrote:
> > Don't buy "Oracle OCP Oracle9i Database: Fundamentals I Exam Guide".
This is
> > without a doubt the worse technical book I have ever read. I have marked
> > over 40 errors in this book. Some are simply hard mis-statements of
fact,
> > and other are more trivial, like words left out of supposed DML syntax.
But
> > the worst part is the unclear style of writing where the author(s)
> > apparently have no ability to put themselves in the readers shoes and
see
> > that a given statement could be understood in multiple ways.
> > Here is a single example of the kind of crap that this book is chock
full of
> > ...
> > P.133  "Note that dropping the redo log group does not remove the actual
> > file from your host machine. Those files do get automatically removed
from
> > the machine when the redo log group or members are dropped."
>
> Also errors in Whizlabs OCP-1Z0-007 Exam Simulator.
> My favourite one:
> Consider the following query:
>  SELECT Item_no FROM Item
>   WHERE Expiry_date = (SELECT Order_date FROM Order
>     WHERE Item_no = 2)
> Which of the above is true?
> A. The subguery will return the Order dates for item no 2 outer query.
> B. The subquery will return an error
> C. The outer query will return the item no for those items whose expiry
> date is the same as the order date for item 2.
> D. The outer query will return an error.
> Authors said answers A and D are correct.
>
> My answer is: there is no ORDER named table in Oracle!!!
> Greetings,
> LW