You have two entities, ItemEO and ProductEO. ItemEO contains the OrderId, ItemId, ProductId, Price,
and Quantity attributes. ProductEO contains the Id, ProductName, and ListPrice attributes. You need
to return rows as shown in the table.
How would you create a view object to encapsulate these rows? (Choose the best answer.)
A.
Create a view object based on the ItemEO entity and add ProductEО as a reference entity.
B.
Create a view object based on the ItemEO entity and modify the generated query to include SELECT
ProductEO.NAME, ProductEO.ID, FROM S_PRODUCT ProductEO.
C.
Create a view object based on the ItemEO entity and modify the WHERE clause to include
ItemEO.PRODUCT_ID = ProductEO.ID.
D.
Create a view object based on the ItemEO entity and create a view criteria to add ItemEO.PRODUCT_ID –
:productId. Define productId as a bind variable to be passed in by the UI.
E.
Create a view object based on the ItemEO entity and change the query mode to Expert. Define the query
as SELECT Item.ORD_ID, Item.ITEM_ID, Item.PRODUCT_ID, Product.NAME, FROM S_ITEM
Item JOIN S_PRODUCT Product ON Item.PRODUCT_ID=Product.Id.