Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mock Exam Q.12.page 428 HFEJB

 
Girija Siva
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All
THe question 12 on page 428 says answer D is correct. Does not this answer return all the order even the ones that have no line items.
Thanks

Here is the reference of the question
Given CMP beans
CustomerBean (1) <-----> OrderBean(n)
OrderBean (1) <------> LineItemBean(n)

Which will return all the orders that have line items?

A. SELECT DISTINCT o
FROM Order o, IN (o.lineItems)li
B SELECT DISTINCT (OBJECT)o
FROM Order o, IN (o.lineItems)li
C SELECT OBJECT(o)
FROM Order o
WHERE o.lineItems = 0
D SELECT OBJECT(o0
FROM Order o
 
Simon Ingram
Ranch Hand
Posts: 173
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I agree with you, Girija. The book seems wrong.
 
Roger Chung-Wee
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This issue has been answered here.
 
Girija Siva
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Simon and Roger
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic