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 answer will be the 3-rd correct answer in the question

Poll closed Jul 18, 2011.
  1. A.

    0 vote(s)
    0.0%
  2. B.

    0 vote(s)
    0.0%
  3. C.

    0 vote(s)
    0.0%
  4. D.

    0 vote(s)
    0.0%
  5. E.

    0 vote(s)
    0.0%
  6. F.

    0 vote(s)
    0.0%
  7. G.

    0 vote(s)
    0.0%
  8. H.

    0 vote(s)
    0.0%
  1. mliviu

    mliviu Guest

    This days I've try to resolve a few questions about the Oracle Forms, and I'm not sure that I've resolved correctly. The first question is:

    See exhibit:
    SQL> desc orders
    Name Null? Type
    ------------------------------ -------------- ------------------
    ORDER_ID NOT NULL NUMBER(12)
    ORDER_DATE NOT NULL DATE
    ORDER_MODE VARCHAR2(8)
    CUSTOMER_ID NOT NULL NUMBER(6)
    ORDER_STATUS NUMBER(2)
    ORDER_TOTAL NUMBER(8,2)
    SALES_REP_ID NUMBER(6)

    SQL> desc order_items
    Name Null? Type
    ----------------------------- -------------- ------------------
    ORDER_ID NOT NULL NUMBER(12)
    LINE_ITEM_ID NOT NULL NUMBER(3)
    PRODUCT_ID NOT NULL NUMBER(6)
    UNIT_PRICE NUMBER(8,2)
    QUANTITY NUMBER(8)
    ITEM_TOTAL NUMBER(10,2)
    Toggle HighlightingOpen in New WindowSelect All


    Question:
    Examine the structure of the ORDERS and ORDER_ITEMS tables. The ORDERS table has been denormalized in that the column ORDER_TOTAL contains the total cost for all ORDER_ITEMS linked to particular order via the foreign key ORDER_ID. You need to create a form that maintains the denormalized column in the database and displays the updated Order_Total whenever the Unit_Price or Quantity is changed on the screen. To achieve this, you have created a non-base-table Calculated item (ITEM_TOTAL in the Order Items block) that calculates UNIT_PRICE * QUANTITY and another non-base-table Calculated item (ORDER_TOTAL in the Control block) that summarized ITEM_TOTAL.
    Which three additional tasks must you do? (Choose three)

    Possible answers:

    A. Set the Database Item property of ORDER_TOTAL to Yes.
    B. Set the Update Allowed property of ORDER_TOTAL to Yes.
    C. Set the Single Record property of the Control block to Yes.
    D. Set the Query All Record property of the Order Items block to Yes.
    E. Set the Precompute Summaries property of the Order Items block to Yes.
    F. Create a null canvas item based on the ORDER_TOTAL column and set its Copy Value From Item property to CONTROL.ORDER_TOTAL.
    G. Write a database trigger to update ORDER_TOTAL in the ORDERS table when a change is written to the ORDER_ITEMS table.
    H. Write a stored procedure to update ORDER_TOTAL in the ORDERS table and call it from a When-Validate- Item trigger whenever a change is made to the UNIT_PRICE or QUANTITY fields.

    My opinion is that the correct answers are:

    "C. Set the Single Record property of the Control block to Yes."
    "D. Set the Query All Record property of the Order Items block to Yes."

    Also, I've found on internet that the 3-rd answer is :
    "E. Set the Precompute Summaries property of the Order Items block to Yes." - but for sure this is not correct- you cannot set simultaneously "Query all Records=YES" and "Precompute Summaries=YES" on the same data block.

    So:
    1 is my above observation correct?
    2 and wich is the 3-rd correct answer, and why,
    3 way the other remaining options(answers) are not correct?