so they were half right. It should have been B and D :(
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Lucyna Witkowska" <ypwitkow_at_nospamcyf-kr.edu.pl> wrote in message
news:brcjmt$254$1_at_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:46:26 CST
