1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

For exam 1z0-141: How to correctly set the calculated item properties?

Discussion in 'Oracle Forms and Reports' started by mliviu, Jul 9, 2011.

?

Wich is the 2-nd correct answer for current thread question?

Poll closed Jul 18, 2011.
  1. A.Database item must be set to No.

    0 vote(s)
    0.0%
  2. B.Update Allowed must be set to No.

    0 vote(s)
    0.0%
  3. C.Summary Function must be set to Sum.

    0 vote(s)
    0.0%
  4. D.Item Type must be set to Display Item

    0 vote(s)
    0.0%
  5. E.Calculation Mode must be set to Formula.

    0 vote(s)
    0.0%
  6. F.Calculation Mode must be set to Summary.

    0 vote(s)
    0.0%
  7. G.Summarized Block must be set to ORDER_ITEMS.

    0 vote(s)
    0.0%
  8. H.Formula must be set to an appropriate calculation.

    0 vote(s)
    0.0%
  1. mliviu

    mliviu Guest

    Question:The Orders form must display the item total for products ordered. You decide to implement this functionality by creating an item in the ORDER_ITEMS block as a Calculated item. The item total is calculated by multiplying the UNIT_PRICE of the product by the QUANTITY ordered.
    Which two items properties must be set? (Choose two)

    A.Database item must be set to No.
    B.Update Allowed must be set to No.
    C.Summary Function must be set to Sum.
    D.Item Type must be set to Display Item.
    E.Calculation Mode must be set to Formula.
    F.Calculation Mode must be set to Summary.
    G.Summarized Block must be set to ORDER_ITEMS.
    H.Formula must be set to an appropriate calculation.

    One correct answer is :
    "E.Calculation Mode must be set to Formula."
    I've found on internet that the seccond correct answer is :
    "A.Database item must be set to No."

    My incertitude is: in the conditions in wich an calculated item is not a database item(by default Forms behaviour), I suppose that is not mandatory to set "Database item" property to NO. In that case, I suggest that "H.Formula must be set to an appropriate calculation." is the 2-nd correct answer.

    Wich is the 2-nd correct answer and why?