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 addItemEO.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 asSELECT 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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |