Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd7cy2so!shaw.ca!news3.optonline.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsinpeer00.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: <9DaCb.26306$8y1.117940@attbi_s52> Subject: Re: OCP Certification Date: Fri, 12 Dec 2003 14:46:26 -0000 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 Lines: 49 Message-ID: <3fd9d4c2$0$9389$ed9e5944@reading.news.pipex.net> NNTP-Posting-Date: 12 Dec 2003 14:46:26 GMT NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1071240386 reading.news.pipex.net 9389 193.128.236.219:11642 X-Complaints-To: abuse@uk.uu.net Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:249976 so they were half right. It should have been B and D :( -- Niall Litchfield Oracle DBA Audit Commission UK "Lucyna Witkowska" wrote in message news:brcjmt$254$1@srv.cyf-kr.edu.pl... > Michael J. Moore 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