It is more faster and easier to pass the Oracle 1Z0-242 exam by using 100% Guarantee Oracle PeopleSoft Application Developer II: App Engine & Integration questuins and answers. Immediate access to the Abreast of the times 1Z0-242 Exam and find the same core area 1Z0-242 questions with professionally verified answers, then PASS your exam with a high score now.

2017 Feb 1Z0-242 answers

Q31. - (Topic 0) 

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 = %1 - %2 

WHERE ITEM_CD = %3 

(QTY_ON_HAND, QTY_ORDERED, ITEM_CD) 

B. %UPDATE (QTY_ON_HAND) 

SELECT QTY_ON_HAND - QTY_ORDERED 

FROM PS_PSU_STOCK_TBL 

WHERE ITEM_CD = %Bind(ITEM_CD) 

C. UPDATE PS_PSU_STOCK_TBL 

SET QTY_ON_HAND = %Bind(QTY_ON_HAND) - %Bind(QTY_ORDERED) 

WHERE ITEM_CD = %Bind(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 PS_PSU_STOCK_TBL 

SET QTY_ON_HAND = %QTY_ON_HAND - %QTY_ORDERED) 

WHERE ITEM_CD = %ITEM_CD 

Answer:


Q32. - (Topic 0) 

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 specifies which row to fetch. 

B. &Var2 specifies which field to fetch. 

C. &Var1 is populated with TRUE if a row is fetched. 

D. &Var1 is populated with the number of rows returned. 

E. &Var2 is populated with EFFORT_AMT from the row fetched. 

F. &Var1 is populated with EFFORT_AMT from the row fetched. 

G. &Var1 is populated with EFFORT_AMT from the first row returned. 

Answer: C,E 

48. - (Topic 0) 

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

A. Steps can call other steps. 

B. Sections execute sequentially. 

C. Steps can call other programs. 

D. Steps execute alphabetically within a program. 

E. Sections are ordered alphabetically following MAIN. 

Answer: C,E 


Q33. - (Topic 0) 

Your customer asks you to evaluate an Application Engine program that she thinks is taking too long. 

You suggest that set processing may improve the Application Engine program performance. 

Select three reasons why you think set processing will help. (Choose three.) 

A. Set processing reduces network traffic by making fewer server trips. 

B. Set processing uses load balancing to distribute processing across multiple servers. 

C. Set processing reuses SQL statements where possible, which reduces overhead significantly. 

D. Set processing uses stored procedures, which are more efficient than Application Engine SQL. 

E. Set processing transfers much of the processing work from Application Engine to the RDBMS, where there is less processing overhead. 

F. Set processing selects only the rows that will be processed, rather than using conditional constructs to determine which rows to process. 

Answer: A,E,F 


Q34. - (Topic 0) 

You have been asked to create the handler for an asynchronous service operation that is being sent outbound to several external nodes. When the service operation is sent, you need to be able to add criteria to filter the nodes. Which method will you implement in the handler PeopleCode to accomplish this? 

A. OnNotify 

B. OnRouteSend 

C. OnAckReceive 

D. OnRequestSend 

E. OnRouteReceive 

Answer:

37. - (Topic 0) 

Select a good reason to select Disable Restart in an Application Engine program. 

A. The program commits every row. 

B. Selecting Disable Restart improves performance because it causes Application Engine to defer all commits until processing completes. 

C. The program does a lot of preparation work up front, like joining tables and loading data into temporary work tables. 

D. The program only commits once, when the program successfully completes. 

E. The program performs crucial and time-sensitive data processing. 

Answer:


Q35. - (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:


Renewal 1Z0-242 free draindumps:

Q36. - (Topic 0) 

View the Exhibit, which shows the file layout for SETID_FILE. You have been asked to write the PeopleCode to export SETIDs to a flat file, along with an action row indicating whether the action is an addition or a change. The resulting flat file will contain a row indicating the action followed by a row containing transaction data. The PeopleCode will be placed on the SETID_TBL.SETID.SavePostChange event. 

Which set of statements will write both the AUDIT_ACTN and SETID_TBL rows to the file? 

A. &SETID = SETID_TBL.SETID; 

If %Mode = "A" Then 

&rRec1.AUDIT_ACTN.Value = "A"; 

Else 

&rRec1.AUDIT_ACTN.Value = "C"; 

End-If; 

&SETIDOUT.WriteRecord(&rRec1); 

&rRec2 = GetRecord(); 

&SETIDOUT.WriteRowset(&rRec2); 

B. &SETID = SETID_TBL.SETID; 

If %Mode = "A" Then 

&rRec1.AUDIT_ACTN.Value = "A"; 

Else 

&rRec1.AUDIT_ACTN.Value = "C"; 

End-If; 

&SETIDOUT.WriteRecord(&rRec1); 

&rRec2 = GetRecord(); 

&SETIDOUT.WriteRecord(&rRec2); 

C. &SETID = SETID_TBL.SETID; 

If %Mode = "A" Then 

&rRec1.AUDIT_ACTN.Value = "A"; 

Else 

&rRec1.AUDIT_ACTN.Value = "C"; 

End-If; 

&SETIDOUT.WriteRowset(&rRec1); 

&rRec2 = GetRecord(); 

&SETIDOUT.WriteRowset(&rRec2); 

Answer:


Q37. - (Topic 0) 

You created a component interface with the standard methods of Create, Find, Get, Cancel, and Save. You secured the component interface and provided full access to all the methods. You want to test the GET method to access the online information. Which three steps will you use to test the GET method? (Choose three.) 

A. Open the component interface in Application Designer. 

B. Right-click in the component interface view and select Test Component Interface. 

C. Save the data by selecting File, Save. 

D. Use the Find option to test the GET method after supplying key values. 

E. Use the Get Existing option to test the GET method after supplying key values. 

F. Enter data in the Component Interface Tester tool. 

G. Validate that the data has been modified and saved by accessing the online component or using the database query tool. 

Answer: A,B,E 


Q38. - (Topic 0) 

An Application Engine program uses a Do Select action. What occurs when the Select statement is executed? 

A. Each row returned by the Select statement is stored in the state record. The Select statement continues until no more rows are returned. Then, the control passes to the calling section. 

B. All rows returned by the Select statement are stored in a cursor. Then, the control is passed to the calling section. 

C. All rows returned by the Select statement are stored in the state record. Then, the control is passed to the next section in the program. 

D. All rows returned by the Select statement are stored in a cursor. The first row is stored in the state record. Then, the remaining actions in the step are processed sequentially. Thereafter, the control returns to the Do Select to fetch another row, until no more rows are returned. 

E. When a row is returned, the remaining steps in the section execute and control returns to the calling step. 

F. When a row is returned, it is stored in the state record. Then, the control is passed to the calling section. 

Answer:


Q39. - (Topic 0) 

Which IntBroker class method do you use to send a synchronous request? 

A. Publish 

B. InboundPublish 

C. SyncRequest 

D. GetSyncIBInfoData 

E. ConnectorRequest 

Answer:

21. - (Topic 0) 

View the Exhibit. Note the Application Engine action MAIN.Loop.W. 

Setting the Action Type to ReUse can significantly reduce the run time for certain 

Application Engine programs. 

Is this program a good candidate for ReUse, and why? 

A. Yes. ReUse is most effective in a SQL looping construct. 

B. Yes. ReUse reduces compile time for PeopleCode statements. 

C. No. ReUse reduces compile time for PeopleCode, but this loop is in a Do While action. 

D. No. ReUse is most effective in a SQL looping construct, but this loop is in a PeopleCode action. 

E. Yes. ReUse reduces the number of checkpoints because fewer SQL Insert statements are performed. 

Answer:


Q40. - (Topic 0) 

You created a component interface based on a component that has a parent PSU_STUDENT_TBL and one non-effective-dated child record PSU_STUDENT_EXP. 

The component interface PeopleCode was created by a developer and a snippet of that PeopleCode is as follows: 

&oPsuStudentExpCollection = &oStuProfile2.PSU_STUDENT_EXP; &item = &oPsuStudentExpCollection.ItemByKeys("PT"); 

If &item <> Null Then 

&j = &item.ItemNum; 

&oPsuStudentExp = &oPsuStudentExpCollection.Item(&j);

 If &oPsuStudentExp.SKILL = "PT" And &oPsuStudentExp.PROFICIENCY = "L" 

Then 

&oPsuStudentExp.PROFICIENCY = "M"; 

End-If; 

Else 

&oPsuStudentExp = &oPsuStudentExpCollection.InsertItem(1); 

&oPsuStudentExp.SKILL = "PT"; 

&oPsuStudentExp.PROFICIENCY = "M"; 

&oPsuStudentExp.DATE_LAST_MAINT = PSU_CRS_SESSN.END_DATE; 

End-If; 

Which statement best describes what this snippet of PeopleCode is trying to accomplish? 

A. Inserts a child row and sets the SKILL, PROFICIENCY, and DATE_LAST_MAINT values, if SKILL is not equal to T 

B. Insert a child row and sets the SKILL, PROFICIENCY, and DATE_LAST_MAINT values, if SKILL is equal to T 

C. Inserts a child row and sets the SKILL, PROFICIENCY and DATE_LAST_MAINT values, if SKILL is equal to "PT" and PROFICENCY is equal to 

D. Modifies the PROFICIENCY of a child row if SKILL is T and PROFICIENCY is for that row 

E. Modifies the value of PROFICIENCY of the child row in which SKILL is T and PROFCIENCY is , else if SKILL is not T inserts a child row and sets the SKILL, PROFICIENCY, and DATE_LAST_MAINT value 

Answer:

77. - (Topic 0) 

View the Exhibit that shows the PeopleCode used to publish the LOCATION_SYNC service operation. This code has been placed in the SavePostChange event in the SETID field in the LOCATION_TBL record. When a user updates the location in the PeopleSoft Pure Internet Architecture and saves the page, what data from the page will be copied into the message structure? 

A. The entire rowset 

B. Only the rows of data at level 0 

C. Only the rows of data at level 1 

D. Only the rows of data that have changed in the rowset 

E. The original values of the changed rows, as well as the rows of data that have changed 

Answer: