1Z0-242 試験問題を無料オンラインアクセス

You are testing a new asynchronous service operation to send employee job data to another system; however, no operation instance is created. Select three possible causes. (Choose three.)

• A.The service operation is not active on the receiving system.
• B.The sending node is paused.
• C.Publication PeopleCode is incorrect.
• D.No Publication PeopleCode exists.
• E.No outbound routings exist for the service operation.
• F.The sending domain is not active.

Examine this PeopleCode snippet:
&SQL = CreateSQL("Select %EffDtCheck(EFFDT) from %Table(PSU_INSTR_TBL)");
Select the correct option.

• A.The statement is valid.
• B.The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %Current(EFFDT) from %Table(PSU_INSTR_TBL)");
• C.The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %DateOut(EFFDT) from %Table(PSU_INSTR_TBL)");
• D.The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %DateIn(EFFDT) from %Table(PSU_INSTR_TBL)");
• E.The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %Date(EFFDT) from %Table(PSU_INSTR_TBL)");
• F.The statement is not valid. The correct syntax is:
  &SQL = CreateSQL("Select %CurrDate(EFFDT) from %Table(PSU_INSTR_TBL)");

An Application Engine program inserts rows into PS_VENDOR.
The program encounters an error and abends (ends abnormally).
You correct the error, but now PS_VENDOR is in an unknown state.
Select the correct statement.

• A.If Log File was enabled in Configuration Manager, a script file was created that you use to return the database to its original state. After you correct the error, you can run the program again.
• B.If Recover was enabled for the program, the changes to PS_VENDOR are rolled back. After you correct the error, you can run the program again.
• C.If a state record was defined for the program, PS_VENDOR is restored based on parameters that were written to the state record. Then you can restart the program using the same run control parameters.
• D.If Restart was enabled for the program, a checkpoint was saved with the last commit. After you correct the error, you can restart the program and processing will resume from the point of the last commit.
• E.If Resume was enabled in PeopleSoft Process Scheduler, the program automatically resumes processing after the condition that caused the error is corrected.

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 PS_PSU_STOCK_TBL
  SET QTY_ON_HAND = %QTY_ON_HAND - %QTY_ORDERED)
  WHERE ITEM_CD = %ITEM_CD
• B.UPDATE PS_PSU_STOCK_TBL
  SET QTY_ON_HAND = Bind(QTY_ON_HAND) - Bind(QTY_ORDERED)
  WHERE ITEM_CD = Bind(ITEM_CD)
• C.UPDATE PS_PSU_STOCK_TBL SET QTY_ON_HAND = %1 - %2 WHERE ITEM_CD = %3 (QTY_ON_HAND, QTY_ORDERED, 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 (QTY_ON_HAND)
  SELECT QTY_ON_HAND - QTY_ORDERED
  FROM PS_PSU_STOCK_TBL
  WHERE ITEM_CD = %Bind(ITEM_CD)

Examine the join in this Select statement:
SELECT A.TASK , B.EFFORT_AMT
FROM PS_PROJECT A , PS_EFFORT B
WHERE A.TASK = B.TASK
AND A.RESOURCE = B.RESOURCE
Select the equivalent Select statement.

• A.SELECT TASK , B.EFFORT_AMT
  FROM PS_PROJECT A , PS_EFFORT B
  WHERE %Join(A.TASK, B.RESOURCE)
• B.SELECT A.TASK , B.EFFORT_AMT
  FROM PS_PROJECT A , PS_EFFORT B
  WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT
  B)
• C.SELECT A.TASK , B.EFFORT_AMT
  FROM %Common(KEYS, PROJECT A, EFFORT B)
• D.SELECT A.TASK , B.EFFORT_AMT
  FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B)
• E.SELECT A.TASK , EFFORT_AMT
  FROM PS_PROJECT A , PS_EFFORT B
  WHERE %Common(PROJECT A, EFFORT B)