Online Access Free 1Z0-242 Exam Questions

Which type of message is most often used for PeopleSoft-to-PeopleSoft integrations?

• A.Non-rowset-based message parts
• B.Rowset-based message parts
• C.Non-rowset-based message
• D.Rowset-based message

An Application Engine program is structured with sections, steps, and actions. Which two statements are correct? (Choose two.)

• A.Steps can call other programs.
• B.Steps execute alphabetically within a program.
• C.Steps can call other steps.
• D.Sections are ordered alphabetically following MAIN.
• E.Sections execute sequentially.

View the Exhibit.
This is the state record for the PSU_CUST_CHG Application Engine program.
How will selecting a Record Type of Derived/Work for the state record affect the program
PSU_CUST_CHG at run time?

• A.It will execute as expected unless the program needs to be restarted.
• B.It will execute as expected only if it does not update database tables.
• C.It will execute, but performance could be improved by using SQL View.
• D.It will abend (abnormal end) because the Record Type for a state record must be SQL Table.
• E.It will abend (abnormal end) because the Record Type for a state record must be Temporary Table.

An Application Engine program requires a loop that will exit after 1000 rows have been processed. The COUNTER field in the state record is incremented in each iteration of the loop. Which option contains code that could be used in a Do While action to test for COUNTER?

• A.%Select(COUNTER)
  FROM PS_STATE_AET
  Where COUNTER < 1000
• B.%SELECT (COUNTER)
  FROM PS_INSTALLATION
  Where COUNTER < 1000
• C.Do While %Bind(Counter) < 1000
• D.If %Bind(Counter) >= 1000 then
  Exit;
• E.%Select(COUNTER)
  SELECT 'X'
  FROM PS_INSTALLATION
  WHERE %Bind(COUNTER) < 1000;

The Application Engine program PSU_PROC_CRSE has a Do Select action with the following code:
%Select (COURSE, EFFDT, DESCR, TOOLS_REL)
SELECT COURSE
, EFFDT
, DESCR
, TOOLS_REL
FROM PS_PSU_COURSE_TBL A
WHERE A.EFFDT <= (SELECT MAX(A1.EFFDT)
FROM PS_PSU_COURSE_TBL A1
WHERE A1.COURSE = A.COURSe
AND A1.EFFDT <= GETDATE())
The program works fine in testing, but it fails when run on an Oracle database platform.
Select the two approaches that will resolve the problem and give the expected results. (Choose two.)

• A.Select the Active check box on the step so that the PeopleSoft Application Engine automatically selects the current row.
• B.Change the WHERE clause to WHERE %EffdtCheck(PSU_COURSE_TBL A, %CurrentDateIn).
• C.Change the SELECT clause to SELECT DISTINCT.
• D.Delete the Where clause.
• E.Replace the GETDATE() function with the %CurrentDateIn system variable.
• F.Change the WHERE clause to WHERE A.EFFDT = MAX(EFFDT).