Top Actual 1Z0-242 courses Tips!

Free of 1Z0-242 exam cram materials and bundle for Oracle certification for consumer, Real Success Guaranteed with Updated 1Z0-242 pdf dumps vce Materials. 100% PASS PeopleSoft Application Developer II: App Engine & Integration exam Today!

2016 Sep 1Z0-242 Study Guide Questions:

Q21. – (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: C 

Q22. – (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 tested the following SQL Select statement in your database query tool and it returned the expected results. (Line numbers have been added for clarity.) 

1.

 SELECT a.ORDER_LINE_NBR 

2.

 , a.ITEM_CD 

3.

 , a.QTY_ORDERED 

4.

 , b.QTY_ON_HAND 

5.

 FROM PS_PSU_ORDER_DTL a 

6.

 , PS_PSU_STOCK_TBL b 

7.

 WHERE a.ITEM_CD = b.ITEM_CD 

You copy and paste the SQL statement to a Do Select action, but it needs to be modified so that it populates the PSU_ORDERS_AET state record. 

What do you need to do? 

A. Change line 1 to: 

%SELECT a.ORDER_LINE_NBR 

B. Add this line before line 1: 

INSERT INTO PS_PSU_ORDERS_AET 

C. Add this line before line 1: 

%SELECT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

D. Add this line before line 1: 

%UPDATE (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

E. Add this line after line 7: 

%INSERT (ORDER_LINE_NBR, ITEM_CD, QTY_ORDERED, QTY_ON_HAND) 

Answer: C 

Q23. – (Topic 0) 

When you service-enable a component interface, the request 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: A 

19. – (Topic 0) 

Examine the join in this Select statement: 

SELECT A.TASK , B.EFFORT_AMT

 FROM PS_PROJECT A , PS_EFFORT B

 WHERE A.TASK = B.TASK 

AND A.RESOURCE = B.RESOURCE 

Select the equivalent Select statement. 

A. SELECT A.TASK , B.EFFORT_AMT 

FROM PS_PROJECT A , PS_EFFORT B 

WHERE %Join(A.TASK, B.RESOURCE) 

B. SELECT A.TASK , B.EFFORT_AMT 

FROM PS_PROJECT A , PS_EFFORT B 

WHERE %Common(PROJECT A, EFFORT B) 

C. SELECT A.TASK , B.EFFORT_AMT 

FROM %Common(KEYS, PROJECT A, EFFORT B) 

D. SELECT A.TASK , B.EFFORT_AMT 

FROM PS_PROJECT A , PS_EFFORT B 

WHERE %Join(COMMON_KEYS, TASK A, EFFORT_AMT 

B) 

E. SELECT A.TASK , B.EFFORT_AMT 

FROM %Join(COMMON_KEYS, PROJECT A, EFFORT B) 

Answer: E 

1Z0-242  braindumps

Most recent 1Z0-242 download:

Q24. – (Topic 0) 

You are testing a new asynchronous service operation to send employee job data to another system; however, no operation instance is created. Select three possible causes. (Choose three.) 

A. The sending node is paused. 

B. The sending domain is not active. 

C. No Publication PeopleCode exists. 

D. Publication PeopleCode is incorrect. 

E. No outbound routings exist for the service operation. 

F. The service operation is not active on the receiving system. 

Answer: C,D,E 

Q25. – (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 

Q26. – (Topic 0) 

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? 

A. The program will abend because PS_INSTALLATION does not have a COUNTER field. 

B. The Do While action will go into an infinite loop because the Select statement will always return true. 

C. The actions following the Do While action will never execute because the Select will never return true. 

D. The Do While will execute at least once, no matter what the result of the Select. 

E. The Do While will execute as expected, as long as COUNTER is being incremented in PS_INSTALLATION for every loop. 

F. The Do While will execute as expected, as long as COUNTER is being incremented in the state record for every loop. 

Answer: F 

certleader.com

Vivid 1Z0-242 testing material:

Q27. – (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: E 

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: D 

Q28. – (Topic 0) 

View the Exhibit. 

An object-oriented PeopleCode program traverses the data buffer to get the value for Session Number (SESSION_NBR) in the Session Details record (PSU_CRS_SESSN) on the Course Sessions page. 

The program uses a built-in function to instantiate the Level 0 object, then uses object methods to instantiate the remaining data buffer objects. 

Select the option that represents the order in which the program instantiates the data buffer objects. 

A. &Row_Level0, &Row _Level1, &Record, &Field 

B. &Rowset_Level0, &Row_Level1, &Record, &Field 

C. &Rowset_Level0, &Rowset_Level1, &Row_Level1, &Record, &Field 

D. &Rowset_Level0, &Row _Level0, &Rowset_Level1, &Row _Level1, &Record, &Field 

Answer: D 

Q29. – (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: B 

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: D 

Q30. – (Topic 0) 

You have been asked to import a CSV file. You create the file layout definition for the record structure and enter your default file name on the Preview tab. When you preview the file, only the first column of the preview grid is populated. What will you do to correct this problem? 

A. change the file layout format to match the input file 

B. specify file record IDs that match the input file records 

C. increase the field length to accommodate the input data 

D. change the definition delimiter to match the one that is used in the input file 

E. decrease the start position and adjust the field length to match the input data start position and length 

Answer: D 

About 1Z0-242 Information: 1Z0-242 Dumps

Certleader Dumps
Certleader is a company specialized on providing high quality IT exam materials and fully committed to assist our respected clients crack any IT certification tests on their 1st efforts.