Oracle PeopleSoft Application Developer II: App Engine and Integration - 1Z0-242무료 덤프문제 풀어보기
You created a component interface based on a component that has a parent PSU_CRS_SESSN and one non-effective-dated child record PSU_STU_ENROLL.
The component interface PeopleCode was created by a developer and a snippet of that PeopleCode is as follows:
&oPsuStuEnrollCollection = &oPsuCrsEnroll.PSU_STU_ENROLL;
For &i = 1 To &oPsuStuEnrollCollection.Count
&oPsuStuEnroll = &oPsuStuEnrollCollection.Item(&i);
If &oPsuStuEnroll.ENROLL_STATUS = "ENR" then
&oPsuStuEnroll.ENROLL_STATUS = "RES";
End-if
End-For;
Which statement best describes what this snippet of PeopleCode is trying to accomplish?
The component interface PeopleCode was created by a developer and a snippet of that PeopleCode is as follows:
&oPsuStuEnrollCollection = &oPsuCrsEnroll.PSU_STU_ENROLL;
For &i = 1 To &oPsuStuEnrollCollection.Count
&oPsuStuEnroll = &oPsuStuEnrollCollection.Item(&i);
If &oPsuStuEnroll.ENROLL_STATUS = "ENR" then
&oPsuStuEnroll.ENROLL_STATUS = "RES";
End-if
End-For;
Which statement best describes what this snippet of PeopleCode is trying to accomplish?
정답: D
View the Exhibit, which displays your file layout for a purchase order. In your application engine program to export the data to a file, which statement will instantiate the rowset?


정답: E
Select three components of the integration gateway. (Choose three.)
정답: C,D,F
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.)
%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.)
정답: C,D
An Application Engine program has a Do While action with the following code:
%SELECT (TEMP_FLD)
SELECT 'COUNTER'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
What will be the result?
%SELECT (TEMP_FLD)
SELECT 'COUNTER'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
What will be the result?
정답: D
View the Exhibit, which shows the WS Security page for the BPEL node definition. You have consumed a Web service from the node BPEL that requires WS Security. On the Node Definitions page, you have entered PTTOOLS as the default user ID, DEMO as the external user ID, and DEMO as the external user password.
Based on this configuration, which user ID and password will be included in the SOAP header?

Based on this configuration, which user ID and password will be included in the SOAP header?

정답: C
Your customer presents you with a requirement for an Application Engine program that performs massive updates to reporting tables based on each day transactions.
The requirements are:
The Application Engine program must complete all processing within a four-hour window. In the event of an abend, there must be a way for the program to resume processing where it stopped.
What are your three design considerations? (Choose three.)
The requirements are:
The Application Engine program must complete all processing within a four-hour window. In the event of an abend, there must be a way for the program to resume processing where it stopped.
What are your three design considerations? (Choose three.)
정답: B,D,F
Component interface Find keys are mapped to ____.
정답: B
View the Exhibit.
This run control page executes an Application Engine program that updates the Course
table using the parameters entered by a user.
In addition to the run control page, which three elements must be in place? (Choose three.)

This run control page executes an Application Engine program that updates the Course
table using the parameters entered by a user.
In addition to the run control page, which three elements must be in place? (Choose three.)

정답: A,D,G
The Customer Orders page uses data from the ITEM table to perform price calculations. You decide to write a PeopleCode program to create a stand-alone rowset that will load data from the ITEM table into the data buffer. Select three PeopleCode statements that can be used with stand-alone rowsets. (Choose three.)
정답: C,D,F