Re: OCP Certification

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Fri, 12 Dec 2003 14:35:09 +0000 (UTC)
Message-ID: <brcjmt$254$1@srv.cyf-kr.edu.pl>

Michael J. Moore <NOhicamelSPAM_at_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 Received on Fri Dec 12 2003 - 08:35:09 CST