Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OCP Certification
> 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