Free Oracle 1Z0-242 Exam Dumps Questions & Answers

You created a component interface based on a component that has a parent and one noneffective-dated child (Level 0 and 1). You have been asked to write the PeopleCode to insert a new row in the collection if the row does not exist. In order to determine whether the row already exists, which method will you use?

• A.GetEffectiveItem()
• B.InsertItem()
• C.ItembyKeys()
• D.GetEffectiveItemNum()
• E.CurrentItem()

View the Exhibit.
This PeopleCode program disables the CHARGE_BACK field:
Local Row &Row;
&Row = GetRow();
&Row.PSU_TASK_EFFORT.CHARGE_BACK.Enabled = False;
For this program to work as shown, what is the highest level at which it could be placed?

• A.PSU_TASK_TBL (Table) - Search Record
• B.PSU_TASK_EFFORT (Table)
• C.PSU_TASK_TBL (Table)
• D.CHARGE_BACK (Record Field)
• E.PSU_TASK_RESOURCES (Component)
• F.PSU_TASK_RSRC (Table)

The Application Engine program PSU_PROC_ORD uses values from PS_PSU_ORDER_DTL and PS_PSU_STOCK_TBL to update PS_PSU_STOCK_TBL.
You used a Do Select action to select QTY_ON_HAND, QTY_ORDERED, and ITEM_CD from PS_PSU_ORDER_DTL into the state record.
You added a SQL action to update PS_PSU_STOCK_TBL using the values in the state record.
Which code would you use in the SQL action?

• A.%UPDATE (QTY_ON_HAND)
  SELECT QTY_ON_HAND - QTY_ORDERED
  FROM PS_PSU_STOCK_TBL
  WHERE ITEM_CD = %Bind(ITEM_CD)
• B.UPDATE PS_PSU_STOCK_TBL
  SET QTY_ON_HAND = %1 - %2
  WHERE ITEM_CD = %3
  (QTY_ON_HAND, QTY_ORDERED, ITEM_CD)
• C.UPDATE PS_PSU_STOCK_TBL
  SET QTY_ON_HAND = %Bind(QTY_ON_HAND) - %Bind(QTY_ORDERED)
  WHERE ITEM_CD = %Bind(ITEM_CD)
• D.UPDATE PS_PSU_STOCK_TBL
  SET QTY_ON_HAND = Bind(QTY_ON_HAND) - Bind(QTY_ORDERED)
  WHERE ITEM_CD = Bind(ITEM_CD)
• E.%UPDATE PS_PSU_STOCK_TBL
  SET QTY_ON_HAND = %QTY_ON_HAND - %QTY_ORDERED)
  WHERE ITEM_CD = %ITEM_CD

View the Exhibit that shows the definition for the PO_QUEUE queue
Which three statements describe how this queue will function? (Choose three.)

• A.When the PeopleSoft Integration Broker archive process is run, the system will delete message transaction data from the current run-time tables.
• B.All messages will be processed sequentially in the order in which they are sent.
• C.If an error occurs on a message, all subsequent messages will remain in a status of New.
• D.Messages will be processed in parallel.
• E.If an error occurs on a message, all messages except those with the same high-level key will continue to process.
• F.When the PeopleSoft Integration Broker archive process is run, the system will write message transaction data to the archive tables and delete the data from the current runtime tables.

Which two characteristics are required to create Transform type application engine programs? (Choose two).

• A.You must define the psft_function in the application engine program.
• B.The Action Type is either XSLT or PeopleCode.
• C.The Program Type is Transform Only.
• D.You must set the Graphical Mapper option to Yes.
• E.The input and output message names must be defined in the application engine program properties, even if Oracle Graphical Mapper is not used.