1Z0-242 | The Secret of Oracle 1Z0-242 pdf
Q41. - (Topic 0)
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. Do While %Bind(Counter) < 1000
B. %SELECT (COUNTER)
FROM PS_INSTALLATION
Where COUNTER < 1000
C. If %Bind(Counter) >= 1000 then
Exit;
D. %Select(COUNTER)
FROM PS_STATE_AET
Where COUNTER < 1000
E. %Select(COUNTER)
SELECT 'X'
FROM PS_INSTALLATION
WHERE %Bind(COUNTER) < 1000;
Answer: E
Q42. - (Topic 0)
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.)
A. Using a state record with a type of derived/work will improve processing speed, but field values will be lost if there is an abend.
B. Using a run control record with a type of derived/work will improve processing speed, but field values will be lost if there is an abend.
C. If the program commits frequently, less work will be lost if a restart is needed. However, each commit takes processing time.
D. If the program commits frequently, fewer benchmarks are needed, which saves time. However, more work must be redone if a restart is needed.
E. If the Disable Restart checkbox is selected for an Application program, processing time is reduced because Application Engine does not record checkpoints. However, the developer must build restart logic into the program.
F. If the Disable Restart check box is not selected, derived/work state record field values are stored to PS_AERUNCONTROL before each commit. However, using a derived/work state record improves processing speed.
Answer: A,C,E
Q43. - (Topic 0)
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?
A. Inserts a child row if ENROLL_STATUS = ENR
B. Modifies each child row in which ENROLL_STATUS =ENR
C. Inserts a child row if any row has ENROLL_STATUS = ENR
D. Modifies each child row if any row has ENROLL_STATUS = ENR
Answer: B
Q44. - (Topic 0)
View the Exhibit.
As the developer, what do you need to do to make this PeopleSoft Application Engine program restartable?
A. Set the state record to derived/work.
B. Remove all section-level and step-level auto commits.
C. Nothing more. The Do Select action is set to Restartable.
D. Select the Disable Restart check box on the Program Properties page.
E. Deselect the Disable Restart check box on the Program Properties page.
Answer: E
Q45. - (Topic 0)
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 %DateIn(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 %CurrDate(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 %Current(EFFDT) from %Table(PSU_INSTR_TBL)");
Answer: C
Q46. - (Topic 0)
Component interface Find keys are mapped to ____.
A. all keys in a component search record
B. search keys in a component search record
C. duplicate order keys in a component search record
D. alternate search key in a component search record
E. search and alternate search keys in a component
Answer: E
Q47. - (Topic 0)
When you service-enable a component interface, the response message shape for the Get method contains _____.
A. Get keys
B. Find keys
C. Object key
D. CI buffer structure
E. Find key collection
Answer: D
Q48. - (Topic 0)
Which two tasks do you need to complete after consuming a Web service? (Choose two.)
A. Add a point-to-point routing.
B. Add the appropriate OnRequest handler.
C. Secure the service operation with a permission list.
D. Write the PeopleCode to invoke the service operation.
E. Update the connection properties on the service operation.
Answer: C,D
Q49. - (Topic 0)
On the Service Operation definition page, the Introspection link is used to _____.
A. provide a Web service
B. consume a Web service
C. add a new service operation
D. add a new service operation version
E. add routing to existing service operation
Answer: E
Q50. - (Topic 0)
Which two modifications can you make to an individual component interface property? (Choose two.)
A. Change the name.
B. Set up synchronization.
C. Add a user-defined method.
D. Expose a standard method.
E. Make the property read-only.
Answer: A,E