Online Access Free 1Z0-242 Practice Test

Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.
&SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1", PSU_TASK_TBL.TASK);
&Var1 = &SQL.Fetch(&Var2);
Select the two correct statements. (Choose two.)

• A.&Var2 is populated with EFFORT_AMT from the row fetched.
• B.&Var1 is populated with TRUE if a row is fetched.
• C.&Var1 is populated with EFFORT_AMT from the first row returned.
• D.&Var2 specifies which row to fetch.
• E.&Var1 is populated with the number of rows returned.
• F.&Var1 is populated with EFFORT_AMT from the row fetched.
• G.&Var2 specifies which field to fetch.

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.Modifies each child row if any row has ENROLL_STATUS = ENR
• B.Inserts a child row if any row has ENROLL_STATUS = ENR
• C.Modifies each child row in which ENROLL_STATUS =ENR
• D.Inserts a child row if ENROLL_STATUS = ENR

View the Exhibit, which shows Code Set Values. You will be using these code set values for the ORDER_STATUS field between System A (sender) and System B (recipient).
Which code set group, based on the data displayed in the exhibit, needs to be associated with System A?

• A.PO_STATUS
• B.TRAINING
• C.PARTICIPANT
• D.RTN_STATUS

View the Exhibit that shows the message tree structure for the STUDENT_INFO message. Based on this structure, which two statements describe the message? (Choose two.)

• A.Student is an alias for the record.
• B.The alias for this message is Student.
• C.This is a non-rowset-based message.
• D.This is a rowset-based message.
• E.The description for the STUDENT_ID field is ID.
• F.The EMPHASIS field is included in the message.

An Application Engine program incorporates PeopleCode and SQL. Which three statements are correct? (Choose three.)

• A.SQL Select statements can be used to control program flow.
• B.If a program executes a step with a SQL Insert or Update statement, it must also execute a step with a Commit action before completion.
• C.All SQL statements are executed using SQL actions.
• D.Steps are the smallest unit of work that can be committed within a program.
• E.All PeopleCode is executed using PeopleCode actions.