Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OCP Certification

Re: OCP Certification

From: Michael J. Moore <NOhicamelSPAM_at_comcast.net>
Date: Fri, 12 Dec 2003 14:41:58 GMT
Message-ID: <WskCb.94901$_M.498917@attbi_s54>

> 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

WTF! :-) Received on Fri Dec 12 2003 - 08:41:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US