Mark C. Stock wrote:
> "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
> news:s5adnZ6J_aWZSq3fRVn-ug_at_comcast.com...
>
>>"Pawel" <pmg3REMOVETHIS_at_op.pl> wrote in message
>>news:1ddkggkvuacra$.dlg_at_www.pmg3.pl...
>>
>>>I'm currently preparing to 1z0-007 exam, and I'm trying to solve some of
>>>the exam problems from the TestKing publication.
>>>I've come across a strange problem:
>>>
>>>"A SQL query cannot display data from table B that is referred to in its
>>>subquery, unless table B is included in the main query's FROM clause"
>>>
>>>According to the provided answers, this is FALSE.
>>>However, I typed into SQL*PLUS a following statement:
>>>
>>>SELECT e.last_name, (SELECT d.location_id FROM departments d
>>>WHERE d.department_id = e.department_id) LOCATION
>>>FROM employees e
>>>/
>>>
>>>(I'm working with the HR schema provided with Oracle database)
>>>
>>>
>>>....and it works perfectly, even though table d is not referenced in the
>>>main query's FROM clause....
>>>
>>>Is it a mistake in the TesKing's material???
>>
>>yes.
>>
>>a lot of such questions on such exams are based on unstated assumptions,
>>and on obsolete versions of oracle -- others are just plain wrong.
>>
>>not a good indicator of the insight of managers and policy makers who rely
>>on certifications and other irrelevant tests
>>
>>++ mcs
>>
>>
>
>
> in light of Gump's post... looks like I have to retract the 'yes', as I did
> not read the OP as carefully as Gump
>
> | The stated answer is "FALSE".
> |
> | You have produced a SQL query that proves that stated answer is
> | correct. That is, you CAN display data from table B that is referred
> | to in its subquery where table B is NOT included in the main query's
> | FROM clause.
>
> so, my apologies to TesKing
>
> my rant about poor quality exams and their place in management decision
> making is inapplicable to to this situation
>
> (still don't like certification exams, though)
>
> ++ mcs
I'm still confused as to whether the question calls for the correct
answer or a wrong one. But my statements about the poor quality of
the exam and its prep materials stands.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Mar 11 2005 - 11:02:38 CST
